hi all. was just wondering if anyone would be able to normalise the following data. i have given it a go after reading through the normalisation guide (http://bytes.com/forum/thread585228.html) but want to compare with an expert to see how i went.
the exact same question has been in a few past exams that i have to sit in a couple days, so it would really help me get some marks.
would really appreciate any help, thanks!
heres the question..
A system is needed that will assist in the identification of individual patients. The following is a list of the data items that are required.
Provide a data normalised structure, indicating relationships that would support this data requirement. The system must allow for the concepts of multiple names for individuals. If you require additional fields to improve the control or quality of the data, you should add them to the list.
Marks will be allocated on the logic of the normalised data structures (10 marks), the appropriateness of the relationships indicated (10 marks) the workability of the solution offered. (5 marks)
Family Name
Given name
Title
Preferred name
Date of Birth
Sex
Person’s Unique ID
UR Number
ID of the organisation that issued the UR number (eg GP clinic,
hospital)
Address line 1
Address line 2
Address line 3
Suburb
Postcode
State
Type of Address (mailing, business, residential, temporary)
Electronic communication type (eg: email, fax, phone)
Electronic communication denominator (email address, phone
number)
Electronic communication use (preferred form of electronic
communication)