Warning: Illegal string offset 'html' in /home/hsn/public_html/forum/cache/skin_cache/cacheid_1/skin_topic.php on line 909

Warning: Cannot modify header information - headers already sent by (output started at /home/hsn/public_html/forum/cache/skin_cache/cacheid_1/skin_topic.php:909) in /home/hsn/public_html/forum/admin/sources/classes/output/formats/html/htmlOutput.php on line 114

Warning: Cannot modify header information - headers already sent by (output started at /home/hsn/public_html/forum/cache/skin_cache/cacheid_1/skin_topic.php:909) in /home/hsn/public_html/forum/admin/sources/classes/output/formats/html/htmlOutput.php on line 127

Warning: Cannot modify header information - headers already sent by (output started at /home/hsn/public_html/forum/cache/skin_cache/cacheid_1/skin_topic.php:909) in /home/hsn/public_html/forum/admin/sources/classes/output/formats/html/htmlOutput.php on line 136

Warning: Cannot modify header information - headers already sent by (output started at /home/hsn/public_html/forum/cache/skin_cache/cacheid_1/skin_topic.php:909) in /home/hsn/public_html/forum/admin/sources/classes/output/formats/html/htmlOutput.php on line 137

Warning: Cannot modify header information - headers already sent by (output started at /home/hsn/public_html/forum/cache/skin_cache/cacheid_1/skin_topic.php:909) in /home/hsn/public_html/forum/admin/sources/classes/output/formats/html/htmlOutput.php on line 141
UNF to 3NF - HSN forum

Jump to content


UNF to 3NF


11 replies to this topic

#1 Coolman

    Newbie

  • Members
  • Pip
  • 7 posts
  • Location:Glasgow

Posted 31 May 2006 - 09:25 PM

Well I have been doing my revision and the only thing I'm slightly bamboozled at is the process of getting from UNF to 3NF. Could anybody tell me any tips or anything that is handy on working it out before the exam tomorrow ?

#2 kingding

    Showing Improvement

  • Members
  • PipPip
  • 37 posts
  • Location:Aberdeen
  • Gender:Male

Posted 31 May 2006 - 09:38 PM

what exactly do you need help with ?


#3 Coolman

    Newbie

  • Members
  • Pip
  • 7 posts
  • Location:Glasgow

Posted 31 May 2006 - 09:43 PM

well after you get to 2nf how exactly do you know how to get to 3nf and how do you know when to carry over the foreign key's to the new table.

#4 Tiger

    Good Effort

  • Members
  • PipPipPip
  • 61 posts
  • Gender:Female

Posted 31 May 2006 - 09:52 PM

QUOTE(Coolman @ May 31 2006, 10:43 PM) View Post

well after you get to 2nf how exactly do you know how to get to 3nf and how do you know when to carry over the foreign key's to the new table.


I dont i used to be really good at normalisation but did one write now n i dont know what's wrong with it.
I chose a different primary key az shown in the answers. Its the 2006 specimen paper. I chose leader to be the primary key rather than activites. Could anyone tell me what to do?

#5 kingding

    Showing Improvement

  • Members
  • PipPip
  • 37 posts
  • Location:Aberdeen
  • Gender:Male

Posted 31 May 2006 - 09:54 PM

Rite:
to get to 1NF, identify repeating groups and put these in a seperate entity, with the primary key of the intitial entity, therebye creating a link.

to get to 2NF, identify any partial dependencies. Look at the attribute/field that the other fields are dependent on, and take these fields AND the attribute (that is part of the key) to another entity. The key will be the attribute that the other attributes are dependent on. This will be related to the previous entity. The occurence of the (key) attribute in the previous entity will be a foreign key(*).

to get to 3NF, do the same as this but with the attribute that others are dependent on, not part of the primary key.

basically, when in 2NF and 3NF, and when splitting attributes into other entities, the initial entity is where the foriegn key will be, and is the "many" side of the relationship.
dunno if that helps wink.gif

tiger, what was the question that you were talking about in the specimen paper??


#6 Tiger

    Good Effort

  • Members
  • PipPipPip
  • 61 posts
  • Gender:Female

Posted 31 May 2006 - 09:57 PM

QUOTE(kingding @ May 31 2006, 10:54 PM) View Post

tiger, what was the question that you were talking about in the specimen paper??


Question 16

#7 kingding

    Showing Improvement

  • Members
  • PipPip
  • 37 posts
  • Location:Aberdeen
  • Gender:Male

Posted 31 May 2006 - 09:58 PM

can you send me the link to the answers
cheers


#8 Tiger

    Good Effort

  • Members
  • PipPipPip
  • 61 posts
  • Gender:Female

Posted 31 May 2006 - 10:00 PM

QUOTE(kingding @ May 31 2006, 10:58 PM) View Post

can you send me the link to the answers
cheers


http://www.sqa.org.uk/files_ccc/InfoSys_H_SQP.pdf

#9 Coolman

    Newbie

  • Members
  • Pip
  • 7 posts
  • Location:Glasgow

Posted 31 May 2006 - 10:14 PM

thnx kingding biggrin.gif

#10 kingding

    Showing Improvement

  • Members
  • PipPip
  • 37 posts
  • Location:Aberdeen
  • Gender:Male

Posted 31 May 2006 - 10:15 PM

rite so;
to get into 1st normal form, you have to take out the attributes from activity downwards, with member no. as a foreign key. The primary key in the other entity is a compound/concatenated key with activity and member no. (which is also a foreign key). Activity is there because each activity is specific and the evening, venue, and leader are dependent on it.
to get into second normal form, you need to locate partial dependencies, by looking for attributes that are only dependent on part of a compound/concatenated key. Since there is a compound key in the new entity, there will only be a dependency in that one. It can be seen that leader, leader number, cost, and venue are dependent on activity. Take this out, form a new entity, and leave a foreign key in the second entity.
to get into third normal form, locate transitive, non key dependencies, and take them out and put them into another entity. Leader telephone is dependent on leader, and so create a new entity with these in it. In the entity with activity, put the foreign key for leader name.

#11 shaunaaa

    Newbie

  • Members
  • Pip
  • 1 posts
  • Gender:Female

Posted 27 November 2008 - 11:55 PM

UNF

1) Write down all the attributes in a vertical list
2) Select primary key
3) Indent repeating group


1NF

1) Put repeating group into new relation/entity/table
2) Select a primary key for your new table
3) Identify any foreign keysforeign key: a key that is a primary key in another table


2NF
Hint: Check each part of this seperately for the different tables

1) If there is a compound primary key, then seperate the attributes of the table that are only dependant on PART of the primary key.
2) There attributes should be put into a new table.
3) Select a primary key for your new table.
4) Identify any foreign keys.


3NF
Hint: Check each part of this seperately for the different tables

1) If there are any attributes that are dependant of other attributes that are NOT primary keys, then remove these to a new table.
2) Select a primary key for your new table. You may have to create a surrogate key. surrogate key:a key that is specifically made up to be uniquely identify a record, aka be a primary key.
3) Identify any foreign keys.

#12 megan deenna

    Newbie

  • Members
  • Pip
  • 1 posts
  • Gender:Female

Posted 30 January 2009 - 09:35 AM

QUOTE (Coolman @ May 31 2006, 09:25 PM) <{POST_SNAPBACK}>
Well I have been doing my revision and the only thing I'm slightly bamboozled at is the process of getting from UNF to 3NF. Could anybody tell me any tips or anything that is handy on working it out before the exam tomorrow ?



yeah same!!





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users