Fit to page D Page view A Read aloud Problem 1 is worth 40% of the assignment grade. Convert the data shown below into a dependency diagram. Natural Earthscapes : Database- E\Spring 2017 Germanna\MS Access Project 1\Natural Earthscapes.accdb (Access 2007 - 2016 file format) - Access Home Create External Data Database Tools Y. 21 Ascending l Descending File Tell me what yr want to do.. Sign in Cut T.Selection Replace Copy Advanced- Go To- Find Paste Filter Refresh All View Format Painter Remove Sort Toggle Filtee Select Views Clipboard Sort & Filter Find Text Formatting Customer Customer Customer Wednesday, February 15, 2017 5:16:30 PM Customer Number Last Name First Name Street Cty Telephone Number Balance Amount Pald worker Number AB10 Alvarez Frances 23 Robbins Luberty Coner (540) 555-4321 $45.00 $305.00 303 Breaton Alex 345 Levick Kingston (703) 555-6987 $80.00 $280.00 305 BR16 Jean 68 Passmore Luberty Corner (540) 555-3412 $0.00 $370.00 307 FE45 Ferdon 98 Magee Anderson (703) 555-8789 $70.00 $0.00 305 GM52 Gammort Frank Bill 314 Oakley Kingston (540) 555-7889 $29.00 $135.00 303 HJ07 Heijer 44 Rising Sun Liberty Corner (703) 555-4576 $60.00 $104.00 303 KL12 Klinger Cynthia Page 1 of 1 3/8 4. ere to search 58 Navigation Pane

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

CASE STUDY 3 - Normalization

Objectives After completing this case study, the student should be able to use Draw.IO to:

Understand 1nf, 2nf and 3nf 2. Modify a database to 3nf. 3. Convert an ER diagram into a dependency diagram. 4. Eliminate and explain all partial and transitive dependencies. 5. Show and explain all dependencies using a blue line.

Requirements:

You must use Draw.IO or MS Visio to complete this case study.

Create an ER diagram

Explain all normalization issues that exist in the ER Diagram.

I want the ER Diagram before normalization and after normalization.

Explain all normalization problems that you corrected between the first and second ER diagram.

Normalize the data in the ER Diagram to 3NF See the video for a demonstration on how to do this: https://www.youtube.com/watch?v=Nq91b4TQ29Q

Create a dependency diagram using the information from your ER diagram. See the video for a demonstration on how to do this: https://www.youtube.com/watch?v=wFOJnRxqrp8

You must label all determinants and dependencies.

Fit to page
D Page view A Read aloud
Problem 1 is worth 40% of the assignment grade. Convert the data shown
below into a dependency diagram.
Natural Earthscapes : Database- E\Spring 2017 Germanna\MS Access Project 1\Natural Earthscapes.accdb (Access 2007 - 2016 file format) - Access
Home
Create
External Data
Database Tools
Y.
21 Ascending
l Descending
File
Tell me what yr want to do..
Sign in
Cut
T.Selection
Replace
Copy
Advanced-
Go To-
Find
Paste
Filter
Refresh
All
View
Format Painter
Remove Sort Toggle Filtee
Select
Views
Clipboard
Sort & Filter
Find
Text Formatting
Customer
Customer
Customer
Wednesday, February 15, 2017
5:16:30 PM
Customer Number
Last Name
First Name
Street
Cty
Telephone Number
Balance Amount Pald worker Number
AB10
Alvarez
Frances
23 Robbins
Luberty Coner (540) 555-4321
$45.00
$305.00
303
Breaton
Alex
345 Levick
Kingston
(703) 555-6987
$80.00
$280.00
305
BR16
Jean
68 Passmore
Luberty Corner (540) 555-3412
$0.00
$370.00
307
FE45
Ferdon
98 Magee
Anderson
(703) 555-8789
$70.00
$0.00
305
GM52
Gammort
Frank
Bill
314 Oakley
Kingston
(540) 555-7889
$29.00
$135.00
303
HJ07
Heijer
44 Rising Sun
Liberty Corner
(703) 555-4576
$60.00
$104.00
303
KL12
Klinger
Cynthia
Page 1 of 1
3/8
4.
ere to search
58
Navigation Pane

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions