ex_6
Tables (5)
AUTHOR (Untitled3)
- AuthorIdNo (Key) — char(13) — Primary key — NOT NULL
- ISBN (Key2) — char(8) — Foreign key → BOOKS.ISBN — NOT NULL
- AuthorName (Field) — char(4)
- AuthorAddress (Field2) — char(10)
- PubId (Key3) — char(8) — Foreign key → PUBLISHER.PubId — NOT NULL
- ISBN (Key22) — char(8) — Foreign key → PUBLISHER.ISBN — NOT NULL
BOOKS (Untitled)
- ISBN (Key) — char(8) — Primary key — NOT NULL
- Title (Field) — char(10)
- PublicationDate (Field2) — char(8)
- Publisher (Field3) — char(6)
CONTRACT (Untitled5)
- ContractId (Key) — char(8) — Primary key — NOT NULL
- ISBN (Key2) — char(8) — Foreign key → BOOKS.ISBN — NOT NULL
- NumberOfBooks (Field) — number
- PrintingDeadline (Field2) — date
PRINTER (Untitled4)
- PrinterId (Key) — char(8) — Primary key — NOT NULL
- PrinterName (Field) — char(4)
- PrinterAddress (Field2) — char(10)
- ISBN (Key2) — char(8) — Foreign key → BOOKS.ISBN — NOT NULL
PUBLISHER (Untitled2)
- PubId (Key) — char(8) — Primary key — NOT NULL
- ISBN (Key2) — char(8) — Foreign key → BOOKS.ISBN — NOT NULL
- PubName (Field) — char(8)
- PubAddress (Field2) — char(10)