BCA20 - Database Management System and Programming Assignment 2 – Normalization -o0oName: ________________________________________Section: BCA20 _________
INSTRUCTION: SUBMIT YOUR ASSIGNMENT ON MONDAY, DEC. 13, 2010. WRITE YOUR ANSWER IN A 1 WHOLE SHEET OF YELLOW PAPER.
Below is hospital data on staff rotation. Assume that the staff can change wards in one week. The charge nurse is unique from the regular regular staff. Normalize the table below into rd its 3 normal form. Show all your solutions.