Module Aims: - To develop an extensive up to date knowledge and understanding of database technologies in modern business environments. - To develop an understanding across a broad range of database technologies and applications appropriate to varying business contexts. - To develop a practical understanding of advanced database concepts. - To develop the students’ critical thinking ability, critical self-reflection and synthesizing skills in approaching the use of database techniques in the modern business environment.
Review of Database Concepts
Relational database ModelData Modelling & NormalisationEntity Relationship Modelling
Enhanced Entity Relationship Modelling
EER Concepts, UML Diagramming and Notation, Specialisation and Generalisation
Object Oriented Databases
OO ConceptsCharacteristics of the OO Data ModelComparison of OODM with other data ModelsOO DBMS Features and conceptsObject Oriented Vs Relational Advantages and Disadvantages
Object Relational Mapping
Object Relational Mapping systems. Hibernate, Doctrine. Scaffolding of code using ORM. Database First V. Code First approaches to systems implementation.
OLAP and Data Warehousing
Data Warehousing ConceptsData Warehouse ArchitectureData Warehouse Data FlowsOnline Analytical Processing & Data MiningData Mining - Star Schemas for data modelling Data Warehousing Implementation.
Not only SQL Databases
Approaches to very large scale data storage and search. BigTable, Hadoop, MongoDB, JSON.
XML
XML, XML Theory, XML DTDS and Schemas, XML apis. XML support within traditional RDBMS
SQL Review
Data Definition Language.Data Manipulation Language.Data Control Language.SELECT, INSERT, CREATE, UPDATE and DELETE statements.
Advanced SQL
Complex JoinsInner & Outer JoinsSub-queries
4GL Techniques 1
Stored ProceduresIF, THEN, ELSE ConstructsLoops,VariablesParameters.
4GL Techniques 2
Triggers & Cursors
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Formal Examination | 50 |
| Other Assessment(s) | 50 |