Share via

What is the Normalization form (3NF) for the following table?

Minhaz Rabbi 51 Reputation points
2021-12-11T09:40:36.69+00:00

This is a huge table, and I am new to this topic. Please help me....

Book_order(Customer_name, Email, Password, Book_name, Book_Id, Book_price, Report_Id, Report_des, Technician_Id, Technician_Name, Technician_email, Author_name, Author_address, Shopping_cart_id, Cost, Count, Ship_address, Bill_address)

Azure SQL Database
0 comments
Accepted answer
  1. Alberto Morillo 34,676 Reputation points MVP Volunteer Moderator
    2021-12-11T12:17:32.203+00:00

    Book_order(Book_order_Id [PK], Customer_Id [FK], Order_Date, Shopping_cart_id, Ship_address, Bill_address)

    Book_order_details(Book_order_Id [PK][FK], Book_Id [PK][FK], Price, Count)

    Reports (Report_Id {PK], Report_des, Technician_Id [FK])

    Technicians (Technician_Id, Technician_Name, Technician_email)

    Customers(Customer_Id [PK], Customer_name, Email, Password)

    Books (Book_Id [PK], Book_name, Book_price, Cost)

    Books_Authors (Book_Id [PK][FK], Author_Id [PK][FK])

    Author (Author_Id [PK], Author_name, Author_address)

    PK = Primary Key
    FK = Foreign Key

    More tables may need to be created like Shopping Cart tables, Employees table to associated with each Book Order, etc.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.