If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Normalisation

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-15-09, 20:05
Selectlife Selectlife is offline
Registered User
 
Join Date: Aug 2009
Posts: 1
Normalisation

I have been given a task to normalise a set of attributes, I have started with 0 normal form (the attributes) and have attempted to normalise them.

Quite frankly im useless when it comes to normalising and I was hoping someone could have a look at my attempt and explain to me where I went wrong .

P.S The attributes are based on a risk assessment form. Basically a database is needed to store information about possible risks and it stores the following info

Assessor (The person assessing the risk)
Date of assessment.
The Hazzard (the risk and details of it)

RA ID: Risk assesment Id

If you would like to me upload the orginal form (The one I used to get un-normalised attributes) then I can do so.
Attached Files
File Type: doc Normalisation table 2.doc (42.6 KB, 72 views)

Last edited by Selectlife; 08-15-09 at 21:12.
Reply With Quote
  #2 (permalink)  
Old 08-26-09, 18:35
Derek Asirvadem Derek Asirvadem is offline
Registered User
 
Join Date: Mar 2009
Location: Sydney, Australia
Posts: 258
Good question.

Yes, upload the original form.

Also upload any fixed lists that you expect to use, such as what you expect the user will see in drop-down list boxes, etc. Eg:
- Nature of Hazard
- Risk Rating

Also, what is "Physical Risk" and "Safe System Risk", provide data examples.
__________________
Regards
Derek Asirvadem (Formerly DerekA)
Information Architect / Senior Sybase DBA
Copyright © 2009 Software Gems Pty Ltd

I answer questions from the Original Poster only. If you have a genuine question, as the moderators have requested, start a new thread.

http://www.softwaregems.com.au

Last edited by Derek Asirvadem; 08-26-09 at 18:51.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On