midterm
Tables (6)
Book
- Key (ISBN) — char(13) — Primary key — NOT NULL
- Field (Bname) — char(30)
- Field (PublisihgDate) — date
- Key (PID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (KDC) — int(3)
- Field (Format) — text
- Field (price) — int
Untitled (Publisher)
- Key (PID) — char(10) — Primary key — NOT NULL
- Field (Pname) — char(20)
- Field (address) — char(50)
Untitled (Author)
- Key (RegistrationNumber) — char(14) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (adress) — char(50)
- Field (phone) — char(11)
- Field (bestseller) — text
Untitled (Book_Author)
- Key (ISBN) — char(13) — Foreign key → Book.Key — NOT NULL
- Key (RegistrationNumber) — char(14) — Foreign key → Untitled.Key — NOT NULL
- Field (Anumber) — int(2)
Untitled (Topic)
- Key (KID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Field (People) — text
- Key (ISBN) — char(13) — Foreign key → Book.Key — NOT NULL
- Field (Accident) — text
Untitled (Keyword)
- Key (KID) — int(10) — Primary key — NOT NULL