Question: Please do not copy and paste the answer from the other person who answered this question because it is wrong. 3. A discount store company

Please do not copy and paste the answer from the other person who answered this question because it is wrong.
3. A discount store company wants to build a database to maintain data about its stores, its credit card customers and the amount of money each credit card customer has spent in each store each year. This is accomplished by recording cash register sales when credit cards are used for payment. Each store has one safe with a single combination for its combination lock. (10\%) Fields: Custcredit (Customer credit card number) Custname Custcity Custstate Storeno (Store number) Storemgr (Store manager name) Storeph (Store phone number) Safeser (Safe serial number) Safecombo (Safe lock combination) Year Amount (Amount spent in a store) Functional dependencies: Custcred Custname, Custcity, Custstate Storeno Storemgr, Storeph, safeser, Safecombo Safeser Safecombo Custcred, Storeno, Year Amount For each of the following relations, indicate the normal form for that relation. If the relation is not in third normal form (3NF), decompose it into 3NF relations. Only fields are shown, not relation names. Primary key fields are underlined. Be sure to both indicate the current normal form and to decompose it if necessary. A. Storene Storemgr, Storeph, Safeser, Safecombo B. Custcred, Custname, Custcity, Custsate c. Custcred, Storeno, Custname, Storemgr D. Custcred Storeno, Year, Custname, Amount E. Storene, Storemgr, Storeph, Safeser
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
