Module Overview

Databases for Business

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

Module Code

INTB H3021

ECTS Credits


*Curricular information is subject to change

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


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 Examination50