LIbrary

Tables (4)

BOOKs (Untitled)

  • Book_ID (Key) — Primary key — NOT NULL
  • titl (Field) — nvarchar(35)
  • author (Field2) — nvarchar(35)
  • ISBN (Field3) — nvarchar(20)
  • publication dat (Field4) — DateTime
  • genre. (Field5) — nvarchar(20)

Borrowing Rigester (Untitled3)

  • Borrow_ID (Key) — int — Primary key — NOT NULL
  • borrowing dat (Field) — DateTime
  • User_ID (Key3) — int — Foreign key → USERs.User_ID — NOT NULL
  • due _Date (Field2) — DateTime
  • Returen Date (Field3) — DateTime
  • fines (Field4) — int
  • ID_CopyBook (Key2) — int — Foreign key → Copy Of Book.ID_CopyBook — NOT NULL

Copy Of Book (Untitled4)

  • ID_CopyBook (Key2) — int — Primary key — NOT NULL
  • Book_ID (Key) — int — Foreign key → BOOKs.Book_ID — NOT NULL
  • AbilityToBorrow (Field) — Bit

USERs (Untitled2)

  • User_ID (Key) — int — Primary key — NOT NULL
  • User_Name (Field) — nvarchar(40)
  • phone Number (Field2) — int
  • library card (Field3) — int