100%(2)2 out of 2 people found this document helpful
This preview shows page 15 - 20 out of 35 pages.
The Normalization of APU_Bookstore are as follows:1 NF1NF Key Publisher_id PKBook_id PKCust_Id PKInvoice_Id PKPublisher_NamePublisher_AddressPublisher_CountryBook_NameBook_CategoryAuthorISBNRateSend_DateBook_QuantityFirst_NameLast_NameCust_AddressCust_PhoneInvoice_No10
5.Database SchemaDatabase schema is a visual representation of a database with a set of rules that govern adatabase or to the entire set of objects belonging to a particular user. The process of creating adatabase schema is known as data modeling. A database schema helps programmers tointeract with the database.The Database schema abstracted from DBMS of APU_Bookstore are as follows:1.PublisherThe Schema shown above is of table Publisher which consists of Publisher_Id as Primary keyand Integer, Publisher_Name as Varchar of length 32, Publisher_Address as Varchar of length50, Publisher_Phone as varchar of length 10 and Publisher_Country as Varchar of length 32and all of them are not null. Publisher_id and Publisher_phone are unique.13
2.BookThe above figure shows the schema of table Book which consists of Column Names likePublisher_id and Book_Id as integer, Book_Name as Varchar of length 32, Book_Category asVarchar of length 10, Author as Varchar of length 20, ISBN as Varchar of length 10, Rate asmoney and Send_Date as date. Publisher_Id and Book_Id are Foreign key and Primary keyrespectively.3.Book_StoreThe above figure is a schema of Book_Store which consists of Column names likePublisher_Name as integer, Book_Id as integer, Book_Quantity is also as integer andBook_Category as Varchar of length 10. Publisher_id and Book_id are Foreign keys.