9948

/in /by

Normalisation
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)

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 deadlines

Order 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)

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.