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 ConceptsDatabase ApproachHistory of Database Systems and ApproachesRelationshipsDatabase Models - Hierarchical, Network, Relational, Object Oriented
Database Management Systems
Data Independence, Integrity and RedundancyData Definition Language, Data Manipulation LanguageData DictionariesData UsersDatabase Administrator
Database Analysis
Requirements CollectionData Analysis and DesignData Representation
Database Design - Entity Relationship Modelling
Entitiy Relationship ModellingConceptual Data Model, Logical Data Model, Physical Data ModelNormalisationIdentifiersSimple and Complex RelationshipsParticipation ConditionsTransformation of Conceptual Model into Relational ModelDatabase SchemasConstructing a Data Dictionary
Client Server Databases
C/S TheoryC/S versus stand alone databasesPerformance Issues2-Tier..N-Tier Architectures
Database Integrity
Database Transactions – ACID PropertiesLost UpdatesLockingTransaction Logs
Data Warehousing
Data Warehousing Theory – Reintroducing redundancyExtract Transform and Load processes3-Dimensional DataProjections, Hot-Keys, Data Cubes
Database Programming
Limitations of SQLEmbedded SQL4GLS
SQL
Advantages of SQLSyntax of SQL StatementsRelational DatabasesKey, Attribute and Check ConstraintsDatabase Creation using DDL and DML StatementsData Retrieval using simple and complex queriesSQL Create, Select, Update, Delete StatementJoinsOrder By QueriesGroup By Queries with Aggregate Functions
Database Tables, Forms, Macros and Reports
Tables FormsMacrosReports
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Other Assessment(s) | 50 |
| Formal Examination | 50 |