BTEC Nat for IT Practitioners - Unit 13 Database Management Systems
Visited times
Remember the Policy adopted by your tutors is quite simple .... If a document relating to your course of study has been published on THIS WEBSITE, then we ASSUME YOU HAVE READ IT. This means that YOU CANNOT claim to NOT know about any topic that is covered on this website which relates to your course of study.. YOU have already SIGNED an agreement under the college LEARNER CODE OF CONDUCT that clearly states YOU are solely responsible for YOUR OWN LEARNING (with the support of your tutors). So make sure that you download , print and work through ALL the support notes and documents from this website that relate to you and your course. If you do this then your grades will improve dramatically .......kind regards .... Paul Bolger ...... 
Unit13 - Course Notes and Resources
   
Part 1 Normalised Relational Databases
   
 Normalisation:
 
  • First Normal Form
 
  • Second Normal Form
 
  • Third Normal Form
   
Integrity constraints:
 
  • domain
 
  • entity
 
  • referential integrity
 
  • operational constraints
   
Powerpoint:  
 
 
 
   
Worksheets: