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)
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
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.