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 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
Get step-by-step solutions from verified subject matter experts
