Question: table [ [ StoreNum , StoreName,OpenDte,CloseDte,Leased,FuelYN,Fuell pe , City,State,Zp , MarketNum,MarketName,MarkettMgr ] , [ 3 2 7 7 5 , SIRUS - 1 1

\table[[StoreNum,StoreName,OpenDte,CloseDte,Leased,FuelYN,Fuell pe,City,State,Zp,MarketNum,MarketName,MarkettMgr],[32775,SIRUS-11 STORE,1223?2032,,LEASED,Y,Reg,PremDie,LAKELAND,FL,33805,701551,TAMPA MARKET,KIBRUDEGEFU],[36696,SIRUS-11STORE,129?2034,,LEASED,Y,Reg,Prem,Die,Eth,PANORAMA CITY,CA,91402,702136,CENIRAL LOS ANGELES,ZAHID MEHMOOD],[32972,SIRUS-11STORE,1015?2033,,LEASED,Y,Reg,PremEth,GIBSONTON,FL,33534,701551,TAMPA MARKET,KIBRUDEGEFU],[59513,CHEVRONSX,926?2033,513?2034,LEASED,Y,Reg,PremDie,DALLAS,TX,75247,700378,LONESTAR,SALON PRABHAKAR],[36861,SIRUS-11 STORE,6212023,,LEASED,Y,Reg,PremDie, Eth,AURORA,CO,80012,701610,WEST DENVER,MOHAMMAD HOSSAIN],[36495,SIRIUS-11 STORE,925?2033,,LEASED,N,NA,LOS ANGELES,CA,90063,702175,INLAND VAUEY,ZAHID KHAN],[36847,SIRUS-11STORE,410?2023,,OWNED,Y,Reg,Prem,Die,GREFNWOOD,SC,29649,702706,CBMART,ZULFIQARAL],[32695,SIRUS-11STORE,528?2032,64?2034,LEASED,Y,Reg.Prem,ITTLETON,CO,80127,701610,WEST DENVER,MOHAMMADHOSSAIN],[61221,CINEJOE,122?2033,123?2033,LEASED,N,NA,WEST MIFFUN,PA,15122,702790,WEST ACQASSET MGMT,OMAR MARTINEZ],[36862,SIRUS-11STORE,410?2023,,LEASED,Y,Reg,PremDie,Eth,GRFENWOOD,SC,29649,702706,CBMART,ZULFIQARAL]]
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 FuelYN)-->(FuelType)
d. StoreNum-(StoreName OpenDte, CloseDte Leased, FuelYN,Zip)
e. Zip-->(City, State)
f. MarketNum (MarketName Zip)
g. MarketNum (MarketName MarketMgr)
h. StoreNum-->(StoreName OpenDte, CloseDte, Leased,FuelYN)
i.(ZipLeased)-->StoreNum
j.(OpenDte CloseDte Leased StoreName)-->FuelYN
 \table[[StoreNum,StoreName,OpenDte,CloseDte,Leased,FuelYN,Fuell pe,City,State,Zp,MarketNum,MarketName,MarkettMgr],[32775,SIRUS-11 STORE,1223?2032,,LEASED,Y,Reg,PremDie,LAKELAND,FL,33805,701551,TAMPA MARKET,KIBRUDEGEFU],[36696,SIRUS-11STORE,129?2034,,LEASED,Y,Reg,Prem,Die,Eth,PANORAMA CITY,CA,91402,702136,CENIRAL LOS ANGELES,ZAHID MEHMOOD],[32972,SIRUS-11STORE,1015?2033,,LEASED,Y,Reg,PremEth,GIBSONTON,FL,33534,701551,TAMPA MARKET,KIBRUDEGEFU],[59513,CHEVRONSX,926?2033,513?2034,LEASED,Y,Reg,PremDie,DALLAS,TX,75247,700378,LONESTAR,SALON PRABHAKAR],[36861,SIRUS-11 STORE,6212023,,LEASED,Y,Reg,PremDie,

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!