$2-$ Consider the following relation, Does this violate $2$ NF $?).$ If yes, make the

necessary changes to correct it$.$ You can just write your modification here.

There is no need to create a new diagram.

a$-$ Relation: Course $($CourseID$,$ CourseName, InstructorName, DepartmentID,

DepartmentName$)$

A composite primary key using both CourseID and DepartmentID. Every

course is uniquely tied to a specific department.

b$.$ If the following relation violates $2$ NF $,$ fix it by listing only the relations and

the attributes that depend on the primary key. You may ignore a couple of

attributes for now.

Relation: Order $($OrderID$,$ ProductID, ProductName, Quantity, CustomerID,

CustomerName, CustomerAddress$)$