The Normalization of APUBookstore are as follows 1 NF 1NF Key Publisherid PK

The normalization of apubookstore are as follows 1 nf

This preview shows page 15 - 20 out of 35 pages.

The Normalization of APU_Bookstore are as follows: 1 NF 1NF Key Publisher_id PK Book_id PK Cust_Id PK Invoice_Id PK Publisher_Name Publisher_Address Publisher_Country Book_Name Book_Category Author ISBN Rate Send_Date Book_Quantity First_Name Last_Name Cust_Address Cust_Phone Invoice_No 10
Image of page 15
Quantity Is_Member Order_Date Order_Quantity Invoice_Date Is_Paid Tran_Date Total Pay_Type Deliver_date Delivery_status Opinion Rating 11
Image of page 16
2 NF 3 NF 12 2NF Publisher_Id PK Book_Id PK Invoice_Id PK Publisher_Name Publisher_Address Publisher_Phone Publisher_Country Invoice_date Is_Paid Book_Quantity Book_Name Book_Category Author ISBN Rate Send_Date Order_Date Order_Quantity 2 NF Key Cust_Id PK Book_Id FK First_Name Last_Name Cust_Address Cust_Phone Delivery_Status Total Tran_date Opinion Rating Table 3 2 NF Key Invoice_Id FK Tran_id Invoice_date Is_Paid Pay_Type Key PK Publisher_Country 3NF Cust_id Book_id First_Name Last_Name Cust_Address Cust_Phone Invoice_No Quantity Is_Member Books 3NF Publisher_Id Book_id Book_Name Book_Category Author ISBN Rate Send_date Book_Store 3NF Key Publisher_Id FK Book_Id FK Quantity Book_Category Order_Details Key Invoice_Id PK Book_Id FK Publisher_Id FK Order_Date Order_Quantity Purchase_Transaction 3NF Key Invoice_Id FK Publisher_Id FK Invoice_Date Is_Paid Transction 3NF Key Invoice_Id FK Tran_Date Tran_Id Total Pay_Type Delivery 3NF Key Book_id FK Cust_Id Quantity Deliver_date Delivery_Status Feedback 3NF Key Cust_Id FK Book_Id FK Opinion Rating
Image of page 17
5. Database Schema Database schema is a visual representation of a database with a set of rules that govern a database or to the entire set of objects belonging to a particular user. The process of creating a database schema is known as data modeling. A database schema helps programmers to interact with the database. The Database schema abstracted from DBMS of APU_Bookstore are as follows: 1. Publisher The Schema shown above is of table Publisher which consists of Publisher_Id as Primary key and Integer, Publisher_Name as Varchar of length 32, Publisher_Address as Varchar of length 50, Publisher_Phone as varchar of length 10 and Publisher_Country as Varchar of length 32 and all of them are not null. Publisher_id and Publisher_phone are unique. 13
Image of page 18
2. Book The above figure shows the schema of table Book which consists of Column Names like Publisher_id and Book_Id as integer, Book_Name as Varchar of length 32, Book_Category as Varchar of length 10, Author as Varchar of length 20, ISBN as Varchar of length 10, Rate as money and Send_Date as date. Publisher_Id and Book_Id are Foreign key and Primary key respectively. 3. Book_Store The above figure is a schema of Book_Store which consists of Column names like Publisher_Name as integer, Book_Id as integer, Book_Quantity is also as integer and Book_Category as Varchar of length 10. Publisher_id and Book_id are Foreign keys.
Image of page 19
Image of page 20

You've reached the end of your free preview.

Want to read all 35 pages?

  • Spring '19
  • Relational model, Database normalization

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture