Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.7.
Questions:
p/s : the first column first row (highlighted) is 1
a) Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.7.
b) How many different data sources are likely to be used by the file you examined in problem a?
c) Given your findings in Problems a and b, how would a relational
d) Given your answer to Problem c, how many tables would you use to substantially eliminate the data redundancy problems? What table structures would you recommend?
e) Given your answers to problem d, show the table contents for each table.
f) Identify the types of relationships (1:1, 1:M, or M:N) between the tables you defined in problems d and e.
g) Create a relational schema for Problem f.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
