exercise 6 new
Tables (6)
Author
- A ID cardNumber (IDcardnumber) — int(20) — Primary key — NOT NULL
- A Name (name) — char(20)
- A Address (address) — char(100)
- Field
BOOK (Book)
- ISBN — int(20) — Primary key — NOT NULL
- TITLE (Title) — char(100)
- PublicationDate (publicationDate) — int(20)
- PublisherID (publisher) — char(100)
PrintingHouse (printinghouse)
- Key (PrintingHouseID) — int(20) — Primary key — NOT NULL
- Field (Name) — char(100)
- Field (address) — char(100)
- ISBN — int(20) — Foreign key → BOOK.ISBN — NOT NULL
Publisher
- PublisherID — int(20) — Primary key — NOT NULL
- P Name (name) — char(100)
- P Address (address) — char(100)
- ISBN — int(20) — Foreign key → BOOK.ISBN — NOT NULL
Untitled (Contract)
- Key (contractID) — int(20) — Primary key — NOT NULL
- ISBN — int(20) — Foreign key → BOOK.ISBN — NOT NULL
- Key (PrintingHouseID) — int(20) — Foreign key → PrintingHouse.Key — NOT NULL
- Field (number of copies) — int(20)
- Field (deadline) — int(20)
Untitled (BOOK_author)
- ISBN — int(20) — Foreign key → BOOK.ISBN — NOT NULL
- A ID cardNumber (IDcardnumber) — int(20) — Foreign key → Author.A ID cardNumber — NOT NULL