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)