Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Icdt 88 2nd International Conference On Database Theory Bruges Belgium August 31 September 2 1988 Proceedings Lncs 326

Authors: Marc Gyssens ,Jan Paredaens ,Dirk Van Gucht

1st Edition

3540501711, 978-3540501718

More Books

Students also viewed these Databases questions

Question

what all do frequency tables display?

Answered: 1 week ago