Question: table [ [ StoreNum , StoreName,OpenDte,CloseDte,Leased,FuelYN,Fuell pe , City,State,Zp , MarketNum,MarketName,MarkettMgr ] , [ 3 2 7 7 5 , SIRUS - 1 1
tableStoreNumStoreName,OpenDte,CloseDte,Leased,FuelYN,Fuell peCity,State,ZpMarketNum,MarketName,MarkettMgrSIRUS STORE,LEASED,YReg,PremDie,LAKELAND,TAMPA MARKET,KIBRUDEGEFUSIRUSSTORE,LEASED,Reg,Prem,Die,Eth,PANORAMA CITY,CENIRAL LOS ANGELES,ZAHID MEHMOODSIRUSSTORE,LEASED,YReg,PremEth,GIBSONTON,TAMPA MARKET,KIBRUDEGEFUCHEVRONSX,LEASED,Reg,PremDie,DALLAS,TXLONESTAR,SALON PRABHAKARSIRUS STORE,LEASED,YReg,PremDie, Eth,AURORA,WEST DENVER,MOHAMMAD HOSSAINSIRIUS STORE,LEASED,NALOS ANGELES,INLAND VAUEY,ZAHID KHANSIRUSSTORE,OWNED,YReg,Prem,Die,GREFNWOOD,SCCBMART,ZULFIQARALSIRUSSTORE,LEASED,Reg.Prem,ITTLETON,WEST DENVER,MOHAMMADHOSSAINCINEJOE,LEASED,NAWEST MIFFUN,PAWEST ACQASSET MGMTOMAR MARTINEZSIRUSSTORE,LEASED,YReg,PremDie,Eth,GRFENWOOD,SCCBMART,ZULFIQARAL
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 MarketNum MarketName City, State, StoreNum
cStoreNum FuelYNFuelType
d StoreNumStoreName OpenDte, CloseDte Leased, FuelYN,Zip
e ZipCity State
f MarketNum MarketName Zip
g MarketNum MarketName MarketMgr
h StoreNumStoreName OpenDte, CloseDte, Leased,FuelYN
iZipLeasedStoreNum
jOpenDte CloseDte Leased StoreNameFuelYN
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
