Individual Assignment3

Tables (7)

Author (Untitled2)

  • IdentificationNo (AutNo) — INT — Primary key — NOT NULL — Unique Number of Author
  • AuthorName (AutName) — VARCHAR — NOT NULL — AuthorName
  • Affiliation (AutAffiliation) — VARCHAR — Affiliation of Author
  • AuthorData (AutData) — VARCHAR — Author Data like career
  • registration date (AutRegDate) — DATATIME — NOT NULL — Registration Date of Author

Book (Untitled4)

  • IdentificationNo (AutNo) — INT — Foreign key → Author.IdentificationNo — NOT NULL — Unique Number of Author
  • Booktitle (BookTitle) — VARCHAR — NOT NULL — Title of book
  • edition (BookEdition) — INT — book edition
  • ISBN (BookISBN) — CHAR — NOT NULL — Book ISBN
  • publisher (BookPublisher) — VARCHAR — NOT NULL — book publsiher
  • publication year (BookPubYear) — INT — NOT NULL — publication year
  • category (BookCategory) — VARCHAR — NOT NULL — Category of book
  • page (BookPage) — CHAR — NOT NULL — the number of pages
  • delivery date (BookDelDate) — DATE — NOT NULL — Delivery date of book
  • UniqueNo (BookUniNo) — INT — Foreign key → Rental card.UniqueNo — NOT NULL — Unique Number of each of books

Member (.)

  • ID (MemID) — VARCHAR — Primary key — NOT NULL — Portal ID (Same as StuNo, Facto)
  • Password (MemPassword) — VARCHAR — NOT NULL — Portal Password
  • Name (MemName) — VARCHAR — NOT NULL — Name
  • Rank (MemRank) — VARCHAR — NOT NULL — status - student, professor, employee

Purchase (Untitled)

  • RegNo — INT — Foreign key → Registration.RegNo — NOT NULL — Registration Number
  • IdentificationNo (AutNo) — INT — Foreign key → Author.IdentificationNo — NOT NULL — Unique Number of Author
  • PurchaseTitle (PurTitle) — VARCHAR — NOT NULL — Book title of Purchase application
  • Purchase Author (PurAuthor) — VARCHAR — NOT NULL — Author name of Purchase application
  • Purchase publisher (PurPublisher) — VARCHAR — publisher name of purchase application

Registration (,)

  • RegNo — INT — Primary key — NOT NULL — Registration Number
  • ID (MemID) — CHAR — Foreign key → Member.ID — NOT NULL — Portal ID (Same as StuNo, Facto)

Rent (Untitled3)

  • RegNo — INT — Foreign key → Registration.RegNo — NOT NULL — Registration Number
  • Name (RenName) — VARCHAR — NOT NULL — Name of person who rent books
  • RentDate (RenDate) — DATETIME — NOT NULL — Date of rent
  • Contact point (RenContact) — INT — NOT NULL — Contact point (like phone number)

Rental card (Untitled5)

  • UniqueNo (BookUniNo) — INT — Primary key — NOT NULL — Unique Number of each of books
  • RegNo — INT — Foreign key → Rent.RegNo — NOT NULL — Registration Number
  • Rental deadline (RentDeadline) — DATETIME — NOT NULL — Deadline of rental
  • Return status (RentStatus) — BOOLEAN — NOT NULL