Store Location Equipment Rental(/hr) Duration Surcharge Manager Budget 1 CB Bike
ID: 3593667 • Letter: S
Question
Store Location Equipment Rental(/hr) Duration Surcharge Manager Budget
1 CB Bike 45 2 .05 Luke 45,0000
1 CB Scooter 130 2.5 .05 Luke 45,0000
2 CC Scooter 130 3 .10 Phillip 50,0000
3 SA Bike 45 2.5 .05 Phillip 45,0000
3 SA Jeep 250 4 .10 Phillip 45,000
3 SA Motorcycle 175 .5 .02 Phillip 45,000
4 CB Jeep 250 .5 Kristy 55,000
4 CB Roller Skates 15 2.5 .05 Kristy 55,000
4 CB Scooter 130 2.5 .05 Kristy 55,000
5 PB Van 250 Paul 55,000
5 PB Stroller 3 .10 Paul 55,000
5 PB Bike 45 2 .05 Paul 55,000
1. What are the semantically obvious functional dependencies?
2. Based on the list of functional dependencies you created in 1.1, define minimal cover (Fc) for the set
in the format Fc: {fd1, fd2,...fdi}
3. Identify any candidate keys.
Explanation / Answer
1. Following could be only obvious functional dependency since all other attributes are not dependent on any other attribute.And there is no particular attribute which makes a record unique in its own sense.
Rental->Equipment
2. Since there is only one functional dependency only that will be included in the minimal cover
Fc:{Rental->Equipment}
3. There are no candidate keys.All entities are weak entities.Had there been any store id that could have been a candidate key but in the given table there is no candidate key.