sql btcamp hw 6
Tables (7)
AUTHOR (Untitled4)
- SSN (Key) — Primary key — NOT NULL
- authorName (Field)
- authorAddress (Field2)
BOOK (Untitled2)
- ISBN (Key) — Primary key — NOT NULL
- publisherID (Key2) — Foreign key → PUBLISHER.publisherID — NOT NULL
- bookName (Field)
- pusblishDate (Field2)
BOOK_WRITE (Untitled3)
- ISBN (Key) — Foreign key → BOOK.ISBN — NOT NULL
- publisherID (Key2) — Foreign key → BOOK.publisherID — NOT NULL
- SSN (Key3) — Foreign key → AUTHOR.SSN — NOT NULL
CONTRACT (Untitled5)
- duedate (Field)
- numberOfBooks (Field2)
- phID (ID) — Foreign key → PRINTINGHOUSE.phID — NOT NULL
- ISBN (Key) — Foreign key → BOOK.ISBN — NOT NULL
- publisherID (Key2) — Foreign key → BOOK.publisherID — NOT NULL
PRINTINGHOUSE (Untitled7)
- phID (ID) — Primary key — NOT NULL
- phName (Field)
- phAdress (Field2)
PUBLISHER (Untitled)
- publisherID (Key) — Primary key — NOT NULL
- publisherName (Field)
- publisherAddress (Field2)
TAG (Untitled6)
- tagID (Key) — Primary key — NOT NULL
- description (Field)
- ISBN (Key2) — Foreign key → BOOK.ISBN — NOT NULL
- publisherID (Key22) — Foreign key → BOOK.publisherID — NOT NULL