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

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

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 General Management Questions!