BTEC NATIONAL Cert / Dip for IT Practitioners
Unit 13 Database Management Systems
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 ....... 
Unit 13 - DBMS Course Notes and Resources
NOTES Lesson Notes - Full Week by Week handouts
   
Full week by week lesson material - Includes Databases refresher course - (that you need to undertake this if you did not undertake BTEC First unit 7) and full set of course notes, handouts, presentations and exercises
   
  Student Contract - Essential Requirements and Resources List 2007/08
   
ASSESSMENT Unit 13.1 - Assessment - Database Types ( P1 , D2 )
  Unit 13.2 - Assessment - Normalisation ( P2,P3, M1,M2 )
  Unit 13.3 - Assessment - SQL ( P4, P5, M3 )
   
Distinction only Unit 13.4 - Assessment - Evaluation ( D1 )
   
  Unit 13 - Assessment - Case Study (2007/08)
  Unit 13 - Assessment - Marking Grid
   
  Edexcel IVA Assessment ( Official Edexcel IVA Learner Instructions)
   
HELP IVA Template - SQL Template - Suggested Headings to use
  IVA Template - Evaluation Template - Suggested Headings to use
   
IVA HELP - Notes - 01 -Databases and Models
IVA HELP - Notes - 02 - Types of Data Model
IVA HELP - Notes - 04 - Relational Data Model - (Click Here for Powerpoint version )
IVA HELP - Notes - 05 -Network Data Model- (Click Here for Powerpoint version )
IVA HELP - Notes - 06 - Object Oriented Model- (Click Here for Powerpoint version )
IVA HELP - Link - Data Dependency Diagrams
IVA HELP - Notes - MORE HELP and IVA related NOTES ( remember to log in to CBCT )
   
  Data Mining
  Normalisation
  SQL
  ddl
  dml
  QBE
  relationships
   
Message Board Get help with your work, Provide a Solution, Talk to other students
   
Unit 13 - DBMS Course Syllabus
   
Part 1 Normalised Relational Databases
   
  Normalisation: First, Second and Third Normal Form
  Integrity constraints: domain, entity, referential integrity, operational constraints
   
Part 2 SQL Scripts
   
  Structure of SQL: DML, DDL (and DCL) and SQL statements in each group
  Database administrator (DBA): makes use of DDL and DCL
  DML statements: database users and applications developers
  Use of DML statements including keywords: select, from, where, group by, having, order by
   
Part 3 Database Management System Software
   
  DBMS: general function and features it possesses for the organisation and retrieval of data in a database
  Types of DBMS: suitability of different types to handle particular data models (hierarchical or tree, simple plex and complex plex
  RDBMS: restricted to simple plex, thereby requiring normalisation (1NF) to resolve complex relationships into one-to-many
   
Part 4 Concept of data warehousing and data mining
   
  Data warehousing: architecture (two level and three level)
  The user interface: tools used to query and analyse, the role of metadata
  Data mining: function and purpose
  Techniques: case-based reasoning, rule discovery, signal processing, neural nets and fractals
  Applications: analysis, targeting, forecasting