Question: Section 1. Functional Dependency 1. The following table shows a complete list of stores that own by a company. There are 6 attributes that specify

 Section 1. Functional Dependency 1. The following table shows a complete

Section 1. Functional Dependency 1. The following table shows a complete list of stores that own by a company. There are 6 attributes that specify the information related to each store. And each attribute has different values that are not NULL. List all the nontrivial functional dependencies (only need to include 2 attributes, e.g. Store Type->Location) that satisfies the relation shown in the table Store Type Location Employee BusinessEstablished Annual Income Hours 12 24 12 10 15 15 Year 2000 1999 2000 2000 1999 2000 (million dollars) 3 10 8 8 8 8 Restaurant Restaurant Clothing Supermarket Seattle Clothing Chicago 50 Supermarket Seattle 100 Chicago 40 Seattle40 90 Seattle 20

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!