Store Location Equipment Rental(/hr) Duration Surcharge Manager Budget 1 CB Bike

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.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.