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 |
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more