ashleh
Member
Registered: 23rd Dec 08
Location: Nottingham
User status: Offline
|
Does anybody understand it and can give me advice in terms of first, second and third normal form? I'm really struggling to find anything that I actually understand  .
|
John
Member
Registered: 30th Jun 03
User status: Offline
|
It's probably in the database course notes.
|
ashleh
Member
Registered: 23rd Dec 08
Location: Nottingham
User status: Offline
|
quote:
Originally posted by John
It's probably in the database course notes.
Actually not implementing it into a database. Been given a list of attributes and need to demonstrate 1NF, 2NF, 3NF so we can draw up an ERD.
|
Aaron
Member
Registered: 9th Aug 04
Location: Cottingham, East Riding
User status: Offline
|
I did this last Semester on my Degree. What a nightmare, i only JUST passed the module lol
I still dont understand it
|
Jez_B
Member
Registered: 8th Nov 06
Location: Towcester, Northants
User status: Offline
|
It's not easy. I find it easier if you list all attributes (on paper in pencil), then you identifiy PK's, FK's, which then inforces referential integrity, you also need to ensure you have no redundant data. Im not sure what characteristics are at what stage, but aslong as you get to 3NF your ok.
3NF, includes tables (normally a link table too), referential integrity (PK's,FK's), and ensures redundant data isnt an issue.
I haven't done it in a year or so, well actually from a list of attributes to 3NF, so this is purely from memory.
[Edited on 05-03-2010 by Jez_B]
|
