ERD Excercise6
Tables (4)
Authors (Untitled3)
- SecurityNumber (Key) — char(13) — Primary key — NOT NULL
- Name (Field) — char(30)
- Adress (Field2) — char(100)
- ISBN (Key2) — char(13) — Foreign key → Books.ISBN — NOT NULL
- Title (Field3) — char(30) — Foreign key → Books.Title
Books (Untitled)
- ISBN (Key) — char(13) — Primary key — NOT NULL
- Title (Field) — char(30) — Primary key
- SubTitle (Key2) — char(50) — Primary key — NOT NULL
- PublicationDate (Field2) — char(8)
Printer (Untitled4)
- ID (Key) — char(5) — Primary key — NOT NULL
- Name (Field) — char(10)
- Adress (Field2) — char(100)
- NumberOfBooks (Field3) — char(6)
- PrintingDeadline (Field4) — char(8)
- ISBN (Key2) — char(13) — Foreign key → Books.ISBN — NOT NULL
- Title (Field5) — char(30) — Foreign key → Books.Title
Publisher (Untitled2)
- Id (Key) — char(5) — Primary key — NOT NULL
- Name (Field) — char(20)
- Adress (Field2) — char(100)
- ISBN (Key2) — char(13) — Foreign key → Books.ISBN — NOT NULL
- Title (Field3) — char(30) — Foreign key → Books.Title