Question: Assuming that all functional dependencies are apparent in this data, which of the following are true? Highlight the answer row ( s ) to indicate

Assuming that all functional dependencies are apparent in this data, which of the following
are true? Highlight the answer row(s) to indicate true.
a. StoreNum-->
(StoreName,OpenDte,CloseDte,Leased,FuelYN,FuelType,City,State,Zip,MarketNum
,MarketName,MarketMgr)
b. MarketNum-->(MarketName City State,StoreNum)
c.(StoreNum, FyelYN)-->(FuelType)
d. StoreNum-->(StoreName OpenDte,CloseDte,Leased,FuelYN.Zip)
e. Zip-->(City, State)
f. MarketNum-->(MarketName,Zip)
g. MarketNum-->(MarketName.MarketMgr)
h. StoreNum-->(StoreName QpenDte CloseDte,Leased.FuelYN)
i.(Ziputeased)-->StoreNum.
j.(QpenDte, CloseDteLeased StoreName)-->FueIYN
2. Assume a STORE entity can be derived from the above listing. List any determinant(s) that may be candidate keys for STORE. Restrict your answer to the row(s) you highlighted in #1.
3. Are there any determinants you highlighted in #1 that are not a candidate key of the STORE entity? If so, list those functional dependency(ies), in standard functional dependency notation.
4. Based on what you determined in question #3, along with considering future growth and the rules of normalization, is it necessary to split the STORE entity into multiple entities? If so, list all entities (themes) you would propose.
5. Based on your answers to #4, which candidate key you identified in #2 would make the better primary key for STORE? List your reasoning, including the functional dependency from #1 that most convinces you of why this determinant would make a good primary key.
6. For each entity identified in question #4, use standard entity/relation notation to identify the attributes of each entity. Identify all primary and foreign keys. Hint: If any attribute in an entity (Entity A) is part of a primary key for A and also serves as a foreign key to another entity (Entity B), you would both underline and italicize the attribute(s) in As notation. List any assumptions.
 Assuming that all functional dependencies are apparent in this data, which

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!