Question: QUESTION: Submit an access file for this. Use the normalization procedure in order to reduce this dataset to a set of relations that are well
QUESTION: Submit an access file for this. Use the normalization procedure in order to reduce this dataset to a set of relations that are well formed. Make sure to mark primary keys and foreign keys.

Chapter 2 The Relational Model 129 FIGURE 2-34 Sample Data for Garden Glory Property Name Property Type Street Eastlake Building Office 123 Eastlake Elm St Apts Apartment 4 East Elm Jeferson Hill Office 42 West 7th St Eastlake Building Office 123 Eastlake Eastlake Building Office 123 Eastlake Elm St Apts Apartment 4 East Elm Eastlake Building Office 123 Eastlake City Seattle Lynnwood Bellevue Seattle Seattle Lynnwood Seattle ZIP 98119 98223 98040 98119 98119 98223 98119 ServiceDate 5/5/2016 5/8/2016 5/8/2016 5/10/2016 5/12/2016 5/15/2016 5/19/2016 Description Lawn Mow Lawn Mow Garden Service Lawn Mow Lawn Mow Lawn Mow Lawn Mow Amount $ 42.50 $ 123.50 $ 53.00 $ 42.50 $ 42.50 $ 123.50 $ 42 50
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
