Task 1. Grade Report

GRADE REPORT

Student Id	Student Name	Campus Address	Major	Course Id	Course Title	Instructor Name	Office	Classroom Location	Grade
101	Bill Milatur	208 Yocum	ISYS	ISYS 4283	Database	Nolan	217D	WCOB 220	B
102	Tom Morrow	802 Yocum	MGMT	ISYS 3293	Analysis	Sykes	212	WCOB 227	A
103	Sharon Cash	301 Gregson	ACCT	WCOB 4213	ERP I	Bristow	219	WCOB 220	A
103	Sharon Cash	301 Gregson	ACCT	ISYS 3393	App Dev	Shipp	322	WCOB 221	B
104	Stan Doff	223 Pomfret	ISYS	ISYS 4283	Database	Nolan	217D	WCOB 220	C
104	Stan Doff	223 Pomfret	ISYS	WCOB 4213	ERP I	Bristow	219	WCOB 220	B
105	Crystal Ball	706 Humphreys	TLOG	WCOB 5223	ERP II	Bristow	219	WCOB 210	A
105	Crystal Ball	706 Humphreys	TLOG	ISYS 5233	ERP III	Freeze	218	WCOB 224	A

The grade report assists administrators in evaluating the performance of multiple students across multiple classes.

1. What normal form is this report currently in? Explain.
2. Draw this table out into a relational model (as we have been doing in class) and identify the primary key(s) and thepartial dependencies that is, are there any fields that are dependent on part, but not all of the primary key. Identify any transitive dependencies that is, are there any fields dependent on other fields that are not part of the key.
3. Now break your tables out into 3NF so that all of your dependencies have been resolved. Using Erwin, model your relational diagram into an ERD (like we did with the in-class example)

4. Combine the 3NF models you created in Parts 1 & 2 to produce a more comprehensive model to meet the needs of the college. Be sure that each entity is only accounted for once, and that relationships are represented accurately.

Please answer in details with diagram