Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

"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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems 23rd European Conference Adbis 2019 Bled Slovenia September 8 11 2019 Proceedings Lncs 11695

Authors: Tatjana Welzer ,Johann Eder ,Vili Podgorelec ,Aida Kamisalic Latific

1st Edition

3030287297, 978-3030287290

More Books

Students also viewed these Databases questions

Question

What is paper chromatography?

Answered: 1 week ago

Question

Explain the cost of capital.

Answered: 1 week ago