Question
Complete the assignment by performing the following Use the table below as a starting point for your database design. The file contains some sample data
Complete the assignment by performing the following
Use the table below as a starting point for your database design. The file contains some sample data from the mississippi.com online bookstore. Analyze the data to determine the meaning of the data in order to determine dependencies. Also use your judgment and past experience in the process of identifying data meaning.
Normalize the database to 3NF. Create a spreadsheet showing your 3NF tables including the data. Under your normalized tables, itemize the steps you took during the process of normalization. For each step describe briefly the process. The items for 2NF and 3NF should identify the dependencies involved.
Once the database in correctly normalized to 3NF, create an ER diagram using a modeling tool of your choice.
author3 isbn date reviewed view custName custAddress custPhone Greg Anderson Dave Ferro Rob Hilton 94.00 | 978-14390803 Naadace. "I had to buy this book for island.com school." "I like it John Locke 815 Oceanic 481-516-2342 9/22/2004 with computer Charles Cir Oracle SQL By 42.00 978- 9/15/2009 "I use SOL kaustinKate Austin 316 Ajira 243-261-5184 9/22/2004 0137142835 n Dean Ray Dean 65.00 978- Rigo, 0073047027Ruth, 5/6/2008, 11/15/2008, Bok" 6/4/2008 The best Java jlocke@ John Locke 815 Oceanic 481-516-2342 |5/23/2010 Cir with Java Bavitha using", "Very Good Book" "I had to buy blinus@ this book for darma.org Linus school." "I like it Greg Anderson Dave Ferro Rob Hilton 94.00 | 978-14390803 Naadace. 11/5/2007 Benjamin 1977 Darma 5/23/2010 with computer Charles VillageStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started