Question

Scenario: PCC needs to track grades received by students taking courses. So far, we have this 1NF relation, with sample data shown. Normalize to 2NF.

GRADES: # GNumber, # CRN, Department, CourseNumber, CourseTitle, GradeOption, Grade, LastAttendDate, Credits

GNumber	CRN	Dept	CourseNum	CourseTitle	GradeOpt	Grade	LastAttendDate	Credits
G03535555	20880	CIS	125D	Database Application Development	P/NP	P		4
G03780005	20880	CIS	125D	Database Application Development	A-F	F	5/01/2019	4
G03675983	21347	CIS	122	Software Design	A-F	B		4
G03535555	21347	CIS	122	Software Design	A-F	A		4
G03780005	21347	CIS	122	Software Design	P/NP	NP	5/03/2019	4
G03780005	21768	MTH	20	Fundamentals of Mathematics	A-F	B		4

Explain your reasoning here (not what you did but why you did it). Describe the process you used to reach your relation(s).

Your 2NF relation or relations go here.

Answer 1

Primary key for the given relation is {GNumber, CRN}

The Functional Dependency possible on the given relation is :

CRN -> Dept, CourseNum, CourseTitle, Credits

CourseNum -> CourseTitle

The Functional Dependency :

CRN -> Dept, CourseNum, CourseTitle, Credits is a partial FD violating 2NF.

When the value of CRN repeats, value of Dept CourseNum, CourseTitle and Credits also repeats. This introduces redundancy in the given relation.

To remove this redundancy, we need to take closure of this partial FD and decompose it into a separate relation.

Thus take closure of CRN

CRN + = { CRN, Dept, CourseTitle, CourseNum, Credits}

Therefore the 2NF relation is:

(CRN, Dept, CourseNum, CourseTitle, Credits)

(GNumber, CRN, GradeOpt, Grade, LastAttendDate)

If you have any questions comment down. Please don't simply downvote and leave. If you are satisfied with answer, please? upvote thanks