Entity Relationship Model Of Book Store System
- 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 |
|
Author |
AuthorID |
Unique id of author |
Int |
NotNull |
No |
|
AuthorName |
Name of the author |
Varchar (20) |
NotNull |
No |
|
|
Publisher |
PublisherID |
Unique id of publisher |
Int |
NotNull |
No |
|
PublisherName |
name of the publisher |
Varchar (20) |
NotNull |
No |
|
|
Books |
ISBN |
Unique identity of books |
Int |
NotNull |
No |
|
Title |
Title of books |
Varchar (20) |
NotNull |
No |
|
|
AuthorID |
Author of the book |
Int |
NotNull |
No |
|
|
PublisherID |
Publisher of the book |
Int |
NotNull |
No |
|
|
CategoryCode |
Category code of the books |
Int |
NotNull |
No |
|
|
Book Store |
BookStoreId |
Unique id of book store |
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 |
|
|
Invoice |
InvoiceNo |
Invoice number |
Int |
NotNull |
No |
|
PurchaseID |
Purchase identification |
Int |
NotNull |
No |
|
|
CuastomerId |
Identification of customer |
Int |
NotNull |
No |
|
|
BooksStoreId |
Id of the Book Store |
Int |
NotNull |
No |
|
|
Title |
Title of the book |
Varchar (20) |
NotNull |
No |
|
|
InvoiceDate |
Date of invoice |
Date |
NotNull |
No |
|
|
PaymentStatus |
Payment status of the book |
Varchar (20) |
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 |
|
|
CustomerID |
Customer unique identification |
Int |
NotNull |
No |
|
|
Customer |
CustomerNo |
Customer unique field |
Int |
NotNull |
No |
|
CustomerName |
Name of the Customer |
Varchar (20) |
NotNull |
No |
|
|
CustomerAddress |
Address of the Customer |
Varchar (20) |
NotNull |
No |
|
|
CustomerMail |
Mail of the Customer |
Varchar (20) |
NotNull |
No |
|
|
CustomershipExpiry |
Expiry date of the Customership |
Date |
NotNull |
No |
|
|
CustomerContact |
Contact of the Customer |
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 |
|
|
BookStoreId |
Identification of the book Store |
Int |
NotNull |
No |
