list all functional dependencies by using the relation and the description below

Question

list all functional dependencies by using the relation and the description below:

PRODUCTS[MatchID, ProductID, ProductType, Description, Price, Alcoholic, VendorID, VendorName, Quantity, SeniorDiscount]

Products sold at the World Cup have an identification number which identifies their product type and description, senior discount eligibility and alcoholic nature. Vendors in stadiums are identified by an ID which informs their name. The matchID and vendorID should inform the quantity of products sold during the game. Each product has a set price in each match.

Explanation / Answer

Below ar eyour dependencies

ProductID <- ProductType

ProductID <- Description

ProductID <- SeniorDiscount

ProductID <- Alcoholic

Note: - Above can also be represented as

ProductID <- ProductType, Description, SeniorDiscount, Alcoholic

Other dependencies are: -

VendorID< -  VendorName

MatchID,VendorID <- Quantity

ProductID, MatchID <- Price

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.