Databases - What problem would you encounter if you wanted to produce a listing by city?

Please see the attached file.

Question 1
What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure?

Question 2:
What data redundancies do you detect, and how could these redundancies lead to anomalies?

Question 3:
Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.5.

Question 4:
Looking at the EMP_NAME and EMP_PHONE contents in Figure P1.5, what change(s) would you recommend?

Question 5:
Identify the different data sources in the file you examined in Problem No: 1.

Question 6:
Given your answer to problem 6, what new files should you create to help eliminate the data redundancies found in the file shown in Figure P1.5?

Question 7:
Given the file structure shown in Figure P1.9, what problem(s) might you encounter if building KOM were deleted?

Question 8:
Identify each relationship type and write all the relationships.

Question 9:

Draw the basic Crow’s Foot ERD for DealCo.

Attached file(s):

questions-BM.doc  View File