ex6
Tables (4)
Authors (Untitled3)
- securityNumber (Key) — Primary key — NOT NULL
- authorsName (Field)
- authoorsAddress (Field2)
Book (Untitled)
- isbn (Key) — Primary key — NOT NULL
- title (Field)
- publicationDate (Field2)
- securityNumber (Key2) — Foreign key → Authors.securityNumber — NOT NULL
Book'sPublisher (Untitled2)
- book'spublisherId (Key) — Primary key — NOT NULL
- isbn (Key2) — Foreign key → Book.isbn — NOT NULL
- publisherName (Field)
- publisherAddress (Field2)
- publisherIdentifier (Field3)
Printers (Untitled4)
- printersId (Key) — Primary key — NOT NULL
- printerName (Field)
- printerAddress (Field2)
- booksNumber (Field3)
- printingDeadLine (Field4)
- book'spublisherId (Key2) — Foreign key → Book'sPublisher.book'spublisherId — NOT NULL
- isbn (Key22) — Foreign key → Book'sPublisher.isbn — NOT NULL
- securityNumber (Key3) — Foreign key → Authors.securityNumber — NOT NULL