Databases (991G5)
Databases
Module 991G5
Module details for 2024/25.
15 credits
FHEQ Level 7 (Masters)
Module Outline
This module provides an introduction to the concepts of Database Software, Database Design, Management, and Programming. You will master the design and implementation of relational databases using SQL. You will also develop skills in executing SQL queries to retrieve and manipulate data efficiently. The program emphasizes understanding and applying normalization techniques to relational databases to eliminate data redundancy and avoid common database anomalies. Security via permission rights and indexes for tuning database queries are addressed. You will also learn how to write stored procedures and triggers using procedural SQL and how use Java Database Connectivity libraries (JDBC) to access databases in Java programs.
Indicative Content
• Conceptual Database Design
• Entity-Relationship approach
• Logical Database Design
• Physical Database Design
• Retrive and manipulate data via SQL queries
• Normalize relational databases, understand what normal forms there are, and how this eliminates certain anomalies based on redundancy
Module learning outcomes
Demonstrate knowledge and critical understanding of established principles for data modelling, management and security in the context of relational databases.
Demonstrate the ability to apply underlying database concepts outside the context in which they were first studied. This includes the design of a database from a specification, and writing SQL code to set up, maintain and query a database.
Demonstrate an understanding of the limits of the Entity-Relationship Model and the Relational Model, and an appreciation of alternative database models.
| Type | Timing | Weighting |
|---|---|---|
| Coursework | 100.00% | |
| Coursework components. Weighted as shown below. | ||
| Test | VACATION Week 8 (2 hours) | 100.00% |
Timing
Submission deadlines may vary for different types of assignment/groups of students.
Weighting
Coursework components (if listed) total 100% of the overall coursework weighting value.
Dr Peter Wijeratne
Assess convenor
/profiles/596509
Please note that the University will use all reasonable endeavours to deliver courses and modules in accordance with the descriptions set out here. However, the University keeps its courses and modules under review with the aim of enhancing quality. Some changes may therefore be made to the form or content of courses or modules shown as part of the normal process of curriculum management.
The University reserves the right to make changes to the contents or methods of delivery of, or to discontinue, merge or combine modules, if such action is reasonably considered necessary by the University. If there are not sufficient student numbers to make a module viable, the University reserves the right to cancel such a module. If the University withdraws or discontinues a module, it will use its reasonable endeavours to provide a suitable alternative module.