31

Tables (7)

Author (Untitled6)

  • Author id (Key) — Primary key — NOT NULL
  • Author Name (Field)
  • Affiliation (Field2)
  • Career (Field3)
  • Register date (Field4)

Book (Untitled5)

  • InfoNo (Key) — Primary key — NOT NULL
  • OrdNo (Key2) — Foreign key → Order.OrdNo — NOT NULL
  • ISBN (Field)
  • title (Field2)
  • edition (Field3)
  • publisher (Field4)
  • NumofPages (Field5)
  • DeliveryDate (Field6)
  • YearPublished (Field7)
  • Category id (Key3) — Foreign key → Category.Category id — NOT NULL
  • Author id (Key4) — Foreign key → Author.Author id — NOT NULL

Category (Untitled7)

  • Category id (Key) — Primary key — NOT NULL
  • CtgName (Field)

Order (Untitled2)

  • OrdNo (Key) — Primary key — NOT NULL
  • RegNo (Key2) — Foreign key → Request.RegNo — NOT NULL
  • OrdDate (Field)
  • Price (Field2)
  • Field3
  • Field4

People Type (Untitled3)

  • People id (Key) — Primary key — NOT NULL
  • People name (Field)
  • Phone number (Field2)
  • Rental status (Field3)
  • People type (Field4)
  • Field5

Rental (Untitled4)

  • RentNo (Key) — Primary key — NOT NULL
  • People id (Key3) — Foreign key → People Type.People id — NOT NULL
  • InfoNo (Key4) — Foreign key → Book.InfoNo — NOT NULL
  • RentStartDate (Field)
  • Field2
  • Field3
  • Field4
  • Field5
  • InfoNo (Key2) — NOT NULL

Request (Untitled)

  • RegNo (Key) — Primary key — NOT NULL
  • MemNo (Key2) — Foreign key → People Type.People id — NOT NULL
  • ISBN (Field)
  • title (Field2)
  • authors (Field3)
  • publishers (Field4)
  • Field5