Module Aims:The main aims of this module are to provide learners with:- An understanding of database models- An appreciation of the advantages of good database design- An awareness of the importance of accurate requirements documentation- The ability to design and implement relational databases- The skills to create databases, formulate queries and generate reports using both Structured Query Language and Microsoft Access
General Introduction to Database Systems
Basic Concepts Database Approach History of Database Systems and Approaches Relationships Database Models - Hierarchical, Network, Relational, Object Oriented
Database Management Systems
Data Independence, Integrity and Redundancy Data Definition Language, Data Manipulation Language Data Dictionaries Data Users Database Administrator
Database Analysis
Requirements Collection Data Analysis and Design Data Representation
Database Design - Entity Relationship Modelling
Entitiy Relationship Modelling Conceptual Data Model, Logical Data Model, Physical Data Model Normalisation Identifiers Simple and Complex Relationships Participation Conditions Transformation of Conceptual Model into Relational Model Database Schemas Constructing a Data Dictionary
Client Server Databases
C/S Theory C/S versus stand alone databases Performance Issues 2-Tier..N-Tier Architectures
Database Integrity
Database Transactions – ACID Properties Lost Updates Locking Transaction Logs
Data Warehousing
Data Warehousing Theory – Reintroducing redundancy Extract Transform and Load processes 3-Dimensional Data Projections, Hot-Keys, Data Cubes
Database Programming
Limitations of SQL. SQL used in combination with 3GL programming languages. 4GLS.
SQL
Advantages of SQL Syntax of SQL Statements Relational Databases Key, Attribute and Check Constraints Database Creation using DDL and DML Statements Data Retrieval using simple and complex queries SQL Create, Select, Update, Delete Statement Joins Order By Queries Group By Queries with Aggregate Functions
Database Tables, Forms, Macros and Reports
Database Tables, User Interfaces, Forms, Reports
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Other Assessment(s) | 50 |
| Formal Examination | 50 |