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