Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Your Business is a spreadsheet from a poorly organized database/business. (See Excel File) You are a database consultant hired to review their data and create
"Your Business" is a spreadsheet from a poorly organized database/business. (See Excel File) You are a database consultant hired to review their data and create a new database. Write your answer in the provided space for each question and save it as a PDF file. Then submit one PDF file only. 1. Find all the dependencies: Solution: 2. Normalize to 2 NF. Give each table a name and list the attributes in each table. Provide structural answers only in DBDL showing functionalities and tables. Solution: 3. Specify primary and foreign keys for each table (Tables that are in 3NF ). Provide structural answers only in DBDL showing functionalities and tables. Solution: 4. Write a set of business rules to go along with your normalized tables Solution: Do not include the data. The data is provided for your reference. You may have to reuse attributes, but do not create any additional fields
Step 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