ERD Exercise_6
Tables (13)
Untitled (Book)
- Key (ISBN) — integer(20) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (Publishing_date) — interger(8)
- Field (Publisher_name) — char(30)
- Field (Author_name) — char(30)
- Key (Publisher_ID) — integer(20) — Foreign key → Untitled.Key — NOT NULL
- Key (KDC) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Publisher)
- Key (Publisher_ID) — integer(20) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(50)
Untitled (Author)
- Key (ssn) — integer(20) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(50)
Untitled (Print)
- Key (print_ID) — integer(20) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(50)
Untitled (Contract)
- Key (contractNO) — char(100) — Primary key — NOT NULL
- Field (printing_number) — int(20)
- Field (print_date) — int(20)
- Key (ISBN) — integer(20) — Foreign key → Untitled.Key — NOT NULL
- Key (print_ID) — integer(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (Book_Author)
- Key (ISBN) — integer(20) — Foreign key → Untitled.Key — NOT NULL
- Key (ssn) — integer(20) — Foreign key → Untitled.Key — NOT NULL
- Field (role) — char(30)
Untitled (KDC)
- Key (Code) — int(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (dexcription) — text
Untitled (Subject)
- Key (subID) — char(30) — Primary key — NOT NULL
- Field (subjectHeading) — char(30)
- Field (description) — text
Untitled (Book_Subject)
- Key (ISBN) — integer(20) — Foreign key → Untitled.Key — NOT NULL
- Key (subID) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (Event)
- Key (eventID) — char(30) — Primary key — NOT NULL
- Field (eventname) — char(30)
- Field (description) — text
Untitled (Book_Event)
- Key (ISBN) — integer(20) — Foreign key → Untitled.Key — NOT NULL
- Key (eventID) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (Person)
- Key (PersonID) — char(30) — Primary key — NOT NULL
- Field (Personname) — char(30)
- Field (description) — text
Untitled (Book_Person)
- Key (ISBN) — integer(20) — Foreign key → Untitled.Key — NOT NULL
- Key (PersonID) — char(30) — Foreign key → Untitled.Key — NOT NULL