Value: 15% Due Date: 04-May-2019 Return Date: 28-May-2019 Submission method options: Alternative submission method Task back to top To keep track of patients and clinician, etc., a private hospital...

Value:15%Due Date:04-May-2019Return Date:28-May-2019Submission method options:Alternative submission method

Task

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)

NOTE

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.

Rationale

back to top

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

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