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 (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
Get step-by-step solutions from verified subject matter experts
