undefined

Row Class Sid# Pid# Professor Office# Student Name Test#1 raw Test#1 extra % Test#1 extra credits Test#1 Total 1 1 AIC 10 5 55 2 Gauss 22 2 1 2 Bob B 60 10 6 66 2 Gauss 22 3 2 3 Cal T 70 10 77 3 Jay 33 2 4 Dan P 80 10 8 3 Jay 33 5 3 5 Ed P 10 3 Jay 33 6 3 3 Cal T 10 99 3 Jay 34 The table is from a file has a record of all student's information including name, Id, scores and their assigned professor for each class. 1. Based on records in the table above, give an example of each of the following, respectively: (a) both data duplicate and data redundant: (b) data duplicate but not data redundant: (c) data redundant but not data duplicate: (d) not data redundant nor data duplicate: 2. give an example for each of 1:1, 1:M, and M:N relationships: Row Class Sid# Pid# Professor Office# Student Name Test#1 raw Test#1 extra % Test#1 extra credits Test#1 Total 1 1 AIC 10 5 55 2 Gauss 22 2 1 2 Bob B 60 10 6 66 2 Gauss 22 3 2 3 Cal T 70 10 77 3 Jay 33 2 4 Dan P 80 10 8 3 Jay 33 5 3 5 Ed P 10 3 Jay 33 6 3 3 Cal T 10 99 3 Jay 34 The table is from a file has a record of all student's information including name, Id, scores and their assigned professor for each class. 1. Based on records in the table above, give an example of each of the following, respectively: (a) both data duplicate and data redundant: (b) data duplicate but not data redundant: (c) data redundant but not data duplicate: (d) not data redundant nor data duplicate: 2. give an example for each of 1:1, 1:M, and M:N relationships