Question 3 3 Marks
Relational model and Normalisation
An incorrect relation NursingSkill has been shown below. The primary key of the relation is (NurseId, SkillId). Examine the relation and answer the questions that follow.
Note: A nurse can have many skills. A nurse is identified by NurseId and a skill is identified by SkillId
|Blood sample collection
Customer (CustomerID, CustomerName)
Order (OrderID, Amount, Date, CustomerID)
Foreign key (CustomerID) references Customer