Homework 2 - Questions
pdf
School
Northeastern University *
*We aren’t endorsed by this school
Course
6700
Subject
Industrial Engineering
Date
Apr 3, 2024
Type
Pages
2
Uploaded by CaptainSparrowMaster1000
Homework 2
IE 6700 Data Management for Analytics
Readings: 1. Chapter 6: Relational Databases –
The Relational Model 2. Practice review questions in Chapter 6 Problem 1. BOSTransit, a transportation company, manages bookings for their shuttle service. The table below displays some details of client reservations for shuttles. Assume that a shuttle driver is assigned to a single shuttle, but a shuttle can be assigned to one or more drivers.
(a)
Identify the functional dependencies represented by the attributes shown in the table below. (a)
Normalize the table in 3NF normalized form. Note: The answer should be in relations format, and you do not need to create a new table for the normalized relations. The table has been given to identify functional dependencies, prime and non-prime attribute types only. Job ID Job Date/Time Driver ID Driver Name Taxi ID Client ID Client Name Job Pickup Address 101 25/07/14 10:00 D101 Jane Smith T101 C201 Chris Johnson 5 Main St, Paisley 102 29/07/14 10:00 D101 Jane Smith T101 C201 Chris Johnson 5 Main St, Paisley 103 30/07/14 11:00 D102 John Doe T102 C201 Chris Johnson 8 Elm St, Paisley 104 2/08/14 13:00 D103 Susan White T103 C202 Mike Green 10 Oak Lane, Paisley 105 2/08/14 13:00 D104 Kevin Black T101 C203 Emily Young 15 Maple Rd, Paisley 106 25/08/14 10:00 D102 John Doe T102 C204 Linda Grey 20 Cedar St, Paisley
Problem 2. Normalize the table shown below to 3NF. State any assumptions you make about the data shown in this table. staffNo
dentistName
patientNo
patientName
Appointment date and time
SurgeryNo
S1011
Tony Smith
P100
Gillian White
12-Aug-03 10.00
S10
S1011
Tony Smith
P105
Jill Bell
13-Aug-03 12.00
S15
S1024
Helen Pearson
P108
Ian MacKay
12-Sep-03 10.00
S10
S1024
Helen Pearson
P108
Ian MacKay
14-Sep-03 10.00
S10
S1032
Robin Plevin
P105
Jill Bell
14-Oct-03 16.30
S15
S1032
Robin Plevin
P110
John Walker
15-Oct-03 18.00
S13
Note: The answer should be in relations format, and you do not need to create a new table for the normalized relations. The table has been given to identify functional dependencies, prime and non-prime attribute types only. Problem 3 Chapter 6, 6.2E Problem 4. Chapter 6, 6.4E Problem 5. Chapter 6, 6.5E
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help