LIBRARY ISBN (Unique Key) Shelf Table Attributes 1. Shelf

LIBRARYDATABASEBooksTable Attributes 1.     BookCategory (Fiction, Romance) –drop down list2.     BookID (Primary Key)3.     BookTittle4.     ShelfNo.

5.     ISBN(Unique Key)ShelfTable Attributes1.     ShelfNo. (Primary Key)2.     ShelfName  LibraryDatabase traits 1.     BookCategory (varchar 30)2.

Best services for writing your paper according to Trustpilot

Premium Partner
From $18.00 per page
4,8 / 5
4,80
Writers Experience
4,80
Delivery
4,90
Support
4,70
Price
Recommended Service
From $13.90 per page
4,6 / 5
4,70
Writers Experience
4,70
Delivery
4,60
Support
4,60
Price
From $20.00 per page
4,5 / 5
4,80
Writers Experience
4,50
Delivery
4,40
Support
4,10
Price
* All Partners were chosen among 50+ writing services by our Customer Satisfaction Team

     BookID (varchar 10)3.     BookTittle (text 50)4.     ShelfNo (int 10)5.

     ISBN(int 20) Keywords = Book ID1.     ShelfNo. (varchar 10)2.     ShelfName (text) CUSTOMER SERVICE DATABASE CustomerTable Attributes1.     CustomerID (Primary key)2.     CustomerName3.

     CustomerTel 4.     CustomerAddress 5.     Typeof Service 6.

     ServiceCode (Foreign Key) ServiceTable Attributes1.     ServiceCode (Primary Key)2.     ServiceName3.

     ServiceTime Span  CustomerService Database traits 1.     CustomerID  (varchar 30)2.     CustomerName (text 50)3.     CustomerTel  (varchar 20)4.     CustomerAddress (varchar 30)5.

     Typeof Service (text)6.     ServiceTime Span (varchar 10) Keywords = Customer ID 1.      Service code (varchar 20)2.     ServiceName (text)3.     ServiceTime Span (varchar) Attributes – these are thecharacteristics of a table in a database. They define a table.Accordingto Mike Chapple on a web page published On 28th December 2017, hedescribed Attributes as columns in a table which contain describingcharacteristics of the rows.

He further stated that an attribute is a columnname in a table   Primary Key- This is aspecial key that uniquely identifies an attribute.HansPetter Halvorsen in his book Introductionto Database Systems pg 6 , he has explained a Primary key as a special caseof unique keys. He differentiated Primary keys and Unique keys by stating thatthe former the constraint NOT NULL enforced and the latter is not automaticallyenforced Foreign Key- this is aprimary key of another table in a table.Accordingto http://www.shumon.me/decode/wp-content/uploads/2015/05/db_keys.pdf  the author has explained that a Foreign keyis the Primary key of another table.

The foreign key is used to enhancereferential integrity of data.      References 1.      MikeChapple 28th Dec 2017 https://www.

thoughtco.com/attribute-definition-10192442.     HansPetter Halvorsen, 1st Nov 2016, Introductionto Database Systems , pg 6  3.     http://www.shumon.me/decode/wp-content/uploads/2015/05/db_keys.pdf  pg 2 explanation of Foreign Key