Answered step by step
Verified Expert Solution
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 rows to indicate true.
a StoreNum
StoreNameOpenDte,CloseDte,Leased,FuelYN,FuelType,City,State,Zip,MarketNum
MarketName,MarketMgr
b MarketNumMarketName City State,StoreNum
cStoreNum FyelYNFuelType
d StoreNumStoreName OpenDte,CloseDte,Leased,FuelYN.Zip
e ZipCity State
f MarketNumMarketNameZip
g MarketNumMarketNameMarketMgr
h StoreNumStoreName QpenDte CloseDte,Leased.FuelYN
iZiputeasedStoreNum.
jQpenDte CloseDteLeased StoreNameFueIYN
Assume a STORE entity can be derived from the above listing. List any determinants that may be candidate keys for STORE. Restrict your answer to the rows you highlighted in #
Are there any determinants you highlighted in # that are not a candidate key of the STORE entity? If so list those functional dependencyies in standard functional dependency notation.
Based on what you determined in question # 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.
Based on your answers to # which candidate key you identified in # would make the better primary key for STORE? List your reasoning, including the functional dependency from # that most convinces you of why this determinant would make a good primary key.
For each entity identified in question # use standard entityrelation 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 attributes in As notation. List any assumptions.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started