: Dynamite Database - BCNF Normalization (25 points) Youre designing a database

Question

: Dynamite Database - BCNF Normalization (25 points) Youre designing a database for an online gaming service named Dynamite. The database should hold customer information, game information and sales. Consider the game sales relation with a sch ema and functional dependencies as follows: R(saleID, saletime, gameTitle, gamePublisher, publisherCutPercent, quantity, price, customerID, address, creditCardNo) gameTitle-price gameTitle gamePublisher . gamePublisher publisherCutPercent customerID address customerID-credit CardNo saleIDsaleTime, gameTitle, quahtity, price, customerlD (a) (10 points) What are the key(s) of the relation? (b) (5 points) Which of these functional dependencies violate BCNF? (c) (10 points) Decompose the relation to obtain a lossless decomposition of R that are in BCNF. Make sure it is clear what the keys are for each relation.

Explanation / Answer

a) saleID is the key of this relation. because saleID can identify each row of this relation uniquely..

b) for a relation to be in BCNF it should satisfy the following conditions,

here only saleID is the super key.

the following functional dependencies violates BCNF rule.

gameTitle -> price

gameTitle -> gamePublisher

gamePublisher -> publisherCutPercent

customerID -> address

customerID -> creditCardNo

c) the following are the relations in BCNF, underlined attributes are the keys of each relation.

( gameTitle , price ,gamePublisher )

( gamePublisher , publisherCutPercent )

( customerID , address ,creditCardNo )

( saleID , saleTime,gameTitle,quantity,price,customerID )

****************************END**************PLS GIVE ME UPVOTE*************************

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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