Login

Welcome, Guest. Please login or register.

July 26, 2025, 01:20:22 am

Author Topic: Normalisation  (Read 1285 times)  Share 

0 Members and 1 Guest are viewing this topic.

brooklynboy93

  • Victorian
  • Adventurer
  • *
  • Posts: 5
  • Respect: 0
  • School: Wesley College
Normalisation
« on: November 12, 2011, 08:47:07 pm »
0
Hi Guys,

Are the stages of normalisation are examinable- as in having to fill in tables to ensure they meet a specific form 1NF, 2NF or 3NF?

Or would it more just be the benefits of normalisation towards ensuring data integrity?

Cheers!!!


MJRomeo81

  • Part of the furniture
  • *****
  • Posts: 1231
  • Princeps
  • Respect: +167
Re: Normalisation
« Reply #1 on: November 12, 2011, 09:09:59 pm »
+1
They are examinable in many ways. They can get us to look at a series of tables and then explain the normalisation that needs to take place, or as you said ask us about the benefits of normalisation.

There could even be a MC question saying something like "The difference between 1NF and 2NF is:" and then they try and trick us through wording.

In the sample VCAA uploaded in March, there was a question where we had a choice to explain one of the follwing 1NF, 2NF, 3NF.
Currently working in the IT Industry as an Oracle DBA (State Government)

Murphy was an optimist

Bachelor of Information Technology @ La Trobe (Melbourne) - Completed 2014
WAM: 91.96
The key, the whole key, and nothing but the key, so help me Codd.

Subjects I tutored during my time at LTU:
CSE2DBF (Database Fundamentals)
CSE1IS (Information Systems)
CSE2DES (System Design Engineering)

Quote
“If I had an hour to solve a problem I'd spend 55 minutes defining the problem and 5 minutes thinking about solutions.”
― Albert Einstein

abzzzz

  • Victorian
  • Forum Obsessive
  • ***
  • Posts: 302
  • Respect: +15
  • School: aia
  • School Grad Year: 2011
Re: Normalisation
« Reply #2 on: November 12, 2011, 09:24:27 pm »
0
Can someone be kind enough to explainn them XD
B4i√U,RU/18QTπ

MJRomeo81

  • Part of the furniture
  • *****
  • Posts: 1231
  • Princeps
  • Respect: +167
Re: Normalisation
« Reply #3 on: November 12, 2011, 09:37:51 pm »
+1
1NF ensures that only one piece of data is within a field. For example  there might be a field called "Address" and it stores your address, suburb and postcode. This is not achieving 1NF. To meet 1NF, we create more fields for the person's suburb, postcode, etc. Only ONE raw item of data is within each field. Doing so makes lookups more powerful and efficient (unless you want to parse text and rip your hair out).

2NF:
 •   Removes subsets of data that apply to multiple rows in a table and places them in separate tables
•   Creates relationships between these tables and their predecessors using foreign keys
•   Eg. storing names once in a table

Usually this happens we have a whole lot of data in one table but it really needs to go in two or more tables.

3NF:
Everything in the table must be dependant on the primary key. If it isn't it needs to be in a separate table.

These powerpoints go into much greater detail than I have:
http://vceit.com/slideshows/Database-Normalisation.ppt
http://vceit.com/slideshows/database-normalisation-forms.ppt
http://vceit.com/slideshows/database-normalisation-example.ppt
Currently working in the IT Industry as an Oracle DBA (State Government)

Murphy was an optimist

Bachelor of Information Technology @ La Trobe (Melbourne) - Completed 2014
WAM: 91.96
The key, the whole key, and nothing but the key, so help me Codd.

Subjects I tutored during my time at LTU:
CSE2DBF (Database Fundamentals)
CSE1IS (Information Systems)
CSE2DES (System Design Engineering)

Quote
“If I had an hour to solve a problem I'd spend 55 minutes defining the problem and 5 minutes thinking about solutions.”
― Albert Einstein

brooklynboy93

  • Victorian
  • Adventurer
  • *
  • Posts: 5
  • Respect: 0
  • School: Wesley College
Re: Normalisation
« Reply #4 on: November 12, 2011, 09:39:47 pm »
0
What MJ said & its also on page 104 of the textbook.