Create a view of the data structure in First Normal Form Using Excel or Word

Create a view of the data structure in Second Normal Form Using Excel or Word

Create a view of the data structure in Third Normal Form Using Excel or Word 

 

Apply the normalization process to the Veterinary Office List—Version One relation shown below to develop a set of normalized relations. Show the results of each of the steps in the normalization process.

 

Un-normalized/Zero Normal Form - Course Books at Bookstore BookID BookName 1 Database Concepts 2 Accounting Basics 3 Programming in Python CourselD_1 CISS 143 ACCTG 101 CourseName_1 Database Design Intro Accounting CourselD_2 CISS 123 CISS 101 shade primary key columns in gray CourseName_2 MS Access Advanced CourselD_3 CISS 243 Programming I CISS 102 CourseName_3 Advanced DBMS Web Development BookISBN 12435-6789-11 4444-5555-66 1111-2222-33 BookPrice CalcPricePlus Tax PublisherID 110.00 Pearson 165.00 McGraw Hill 55.00 McGraw Hill 100.00 150.00 50.00 PublisherPhone AuthorID AuthorEmail 330-111-2222 Kroenke kroenke@pearson.com 800-333-4444 Smith smith@mcgraw.com 800-333-4444 Smith smith@mcgraw.com (Note: the CalcPricePlusTax column is always a calculation of the Price + 10% Tax)