Data

Row Class Pid# Professo Office# Sid # Student Name Test# 1 raw Test# 1 extra % Test# 1 extra credit s Test# 1 Total 1 1 AC 10 5 55 2 Guss 22 2 2 Bob B 60 10 6 66 2 Gauss 22 2 3 Cal T 70 10 77 3 Jay 33 4 2 4 Dan P 80 10 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. Find and Correct data entry errors: Based on the corrected version, answer the following: 1. Based on this storage of the data, find the drawbacks or problems causing difficulties: 2. Correct the file to avoid drawbacks or problems by redrawing the original into tables with records: 3. Give the schema for each table; and represent the revised version above in an ER diagram. 4. Chen's notation and Crow's Foot 1 5. UML class diagram and Object-Oriented data model