Assignment Part 1: Entity-Relationship Diagram For Old Print Bookstore
- December 21, 2023/ Uncategorized
Attributes Data Dictionary
Student Name: Student Id: Student FAN:
Student Name: Student Id: Student FAN:
|
Entity or Relationship Name |
Attributes |
Description |
Data Type and Length |
Nulls |
Multi-valued |
|
Publisher |
PublisherID |
Publisherid is the unique item in publisher |
Int |
NotNull |
No |
|
PublisherName |
Publisher name is the name of the publisher |
Varchar (20) |
NotNull |
No |
|
|
Author |
AuthorID |
Unique id of author |
Int |
NotNull |
No |
|
AuthorName |
Name of the author |
Varchar (20) |
NotNull |
No |
|
|
AuthorType |
Type of author |
Varchar (20) |
NotNull |
No |
|
|
Books |
ISBN |
Unique identity of books |
Int |
NotNull |
No |
|
Title |
Title of books |
Varchar (20) |
NotNull |
No |
|
|
CategoryCode |
Category code of the books |
Int |
NotNull |
No |
|
|
AuthorID |
Author of the book |
Int |
NotNull |
No |
|
|
PublisherID |
Publisher of the book |
Int |
NotNull |
No |
|
|
Inventory |
InventoryNo |
Unique identification of a book in the inventory |
Int |
NotNull |
No |
|
ISBN |
Book identity |
Int |
NotNull |
No |
|
|
Price |
Book price |
Currency |
NotNull |
No |
|
|
Date |
Data of registration |
Date |
NotNull |
No |
|
|
NumberOfCopies |
Number of copies |
Number |
NotNull |
No |
|
|
Request |
RequestID |
Unique id of request |
Int |
NotNull |
No |
|
StartDate |
Start date of request |
Date |
NotNull |
No |
|
|
ExpiryDate |
Expiry date of request |
Date |
NotNull |
No |
|
|
watchSpecification |
Watch specification |
Varchar (20) |
NotNull |
No |
|
|
StausCode |
Status of the request |
Varchar (20) |
NotNull |
No |
|
|
memeberNo |
Member number |
Int |
NotNull |
No |
|
|
Invoice |
InvoiceNo |
Invoice number |
Int |
NotNull |
No |
|
PurchaseID |
Purchase identification |
Int |
NotNull |
No |
|
|
MemberNo |
Member number |
Int |
NotNull |
No |
|
|
Title |
Title of the book |
Varchar (20) |
NotNull |
No |
|
|
Publisher |
Book publisher |
Varchar (20) |
NotNull |
No |
|
|
MemeberNo |
Member number |
Int |
NotNull |
No |
|
|
Title |
Title of the book |
Varchar (20) |
NotNull |
No |
|
|
Publisher |
Publisher of the book |
Varchar (20) |
NotNull |
No |
|
|
InventoryId |
Inventory id from which the book was taken |
Int |
NotNull |
No |
|
|
InvoiceDate |
Date of invoice |
Date |
NotNull |
No |
|
|
PaymentStatus |
Payment status of the book |
Varchar (20) |
NotNull |
No |
|
|
Member |
MemberNo |
Member unique field |
Int |
NotNull |
No |
|
MemberName |
Name of the member |
Varchar (20) |
NotNull |
No |
|
|
MemberAddress |
Address of the member |
Varchar (20) |
NotNull |
No |
|
|
MemberMail |
Mail of the member |
Varchar (20) |
NotNull |
No |
|
|
membershipExpiry |
Expiry date of the membership |
Date |
NotNull |
No |
|
|
memberContact |
Contact of the member |
Number |
NotNull |
No |
|
|
Category |
CategoryCode |
Category code |
Int |
NotNull |
No |
|
CategoryName |
Name of the category |
Varchar (20) |
NotNull |
No |
|
|
Purchase |
PurchaseId |
Purchase unique key field |
Int |
NotNull |
No |
|
RequestId |
Request id |
Int |
NotNull |
No |
|
|
InventoryNo |
Inventory number |
Int |
NotNull |
No |
