Question: Task 2 Check the following schema against the different normalization rules (i.e., 1NF, 2NF, 3NF, BCNF). Fix the schema if any of the normalization rules

 Task 2 Check the following schema against the different normalization rules

Task 2 Check the following schema against the different normalization rules (i.e., 1NF, 2NF, 3NF, BCNF). Fix the schema if any of the normalization rules is violated ORDERS (ISBN, DatePurch, CustName, CustAddress, CustPhone, CustEmail, Title, Author, Reviewer, Review, DateReviewed, Price) -A table called ORDERS, which contains data about the ordered books. It has the attributes ISBN (a number that this company assign), DatePurch, CustName, CustAddress, CustPhone, CustEmail, Title (title of the book), Author, Reviewer, DateReviewed, Review and Price. ISBN is the primary key. There may be more than one authors for a book. There may be more than one review for a book. There may be more than one reviewer for a book -A reviewer may review for different books. ISBN is the primary key

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!