By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,205 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

help normalising this data please?

P: 3
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 ( 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
Preferred name
Date of Birth
Personís Unique ID
UR Number
ID of the organisation that issued the UR number (eg GP clinic,
Address line 1
Address line 2
Address line 3
Type of Address (mailing, business, residential, temporary)
Electronic communication type (eg: email, fax, phone)
Electronic communication denominator (email address, phone
Electronic communication use (preferred form of electronic
Nov 14 '08 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 2.5K+
P: 2,545
Hi ngo88. I do understand how helpful it would be to get pointers about proper normalisation - but we cannot help you with what at least you have honestly and openly posted is some form of coursework question.

If you have something specific that you need help on then please post a question seeking assistance and we will do our best to help you. You need to show some effort yourself too.

Please read our Posting Guidelines and in particular our FAQ entry for Homework Questions.

I will close this thread to prevent misguided attempts to help you with your coursework; you may not realise that all academic institutions view attempted plagiarism very seriously indeed, and you could be subject to serious penalties by your home institution if you are suspected of dishonest conduct in your assessment.

Nov 16 '08 #2

Expert Mod 15k+
P: 31,494
I can't reply to a reported problem, but there is no reason to delete this thread.
Sep 14 '09 #3

This discussion thread is closed

Replies have been disabled for this discussion.