Value: 15%Due Date: 04-May-2019Return Date: 28-May-2019Submission method options: Alternative submission method
back to top
To keep track of patients and clinician, etc., a private hospital uses the table structure shown in Table 1 Patient Report

a. Given that information, draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies. (5 Marks)

b. Modify the dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and attributes as necessary. (5 Marks)

c.Draw the Crow’s Foot ERD. (5 Marks)


For guidance on how to normalise database relations from a dependency diagram, watch this very short YouTube video: https://www.youtube.com/watch?v=vkUyuLLgmwQ

Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema is NOT acceptable.

back to top

This assessment task will assess the following learning outcome/s:

  • be able to apply normalisation techniques to optimise a database design.