: 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