Individual Assignment 3
Tables (8)
Untitled (ProcessingStatus)
- Key (id) — Primary key — NOT NULL
- Field (status)
Untitled (category)
- Key (id) — Primary key — NOT NULL
- Field (name)
Untitled2 (Order)
- Key (id) — Primary key — NOT NULL
- Field (title)
- Field2 (author)
- Field3 (IISBN)
- Field4 (publisher)
- Key (processid) — Foreign key → Untitled.Key — NOT NULL
- Key (memberid) — Foreign key → Untitled5.Key — NOT NULL
Untitled3 (DeliveredBook)
- Key (id) — Primary key — NOT NULL
- Field3 (loanstatus)
- Field
- Key (orderid) — Foreign key → Untitled2.Key — NOT NULL
- Key (ISBN) — Foreign key → Untitled4.Key — NOT NULL
Untitled4 (BookInfo)
- Key (ISBN) — Primary key — NOT NULL
- Field3 (title)
- Field4 (edition)
- Field5 (publisher)
- Field6 (pubyear)
- Field7 (pagenumber)
- Field8 (deliverdate)
- Key (categoryid) — Foreign key → Untitled.Key — NOT NULL
- Key (authorid) — Foreign key → Untitled7.Key — NOT NULL
Untitled5 (Member)
- Key (id) — Primary key — NOT NULL
- Field (name)
- Field2 (contact)
- Field3 (loanstatus)
- Field4 (position)
Untitled6 (Loan)
- Key (id) — Primary key — NOT NULL
- Field3 (loandate)
- Field4 (returndue)
- Field5 (actualreturn)
- Key (memberid) — Foreign key → Untitled3.Key — NOT NULL
- Key (deliveredbookid) — Foreign key → Untitled5.Key — NOT NULL
Untitled7 (Author)
- Key (id) — Primary key — NOT NULL
- Field (name)
- Field2 (affiliation)
- Field3 (career)
- Field4 (regidate)