Module overview
Aims and Objectives
Learning Outcomes
Subject Specific Intellectual and Research Skills
Having successfully completed this module you will be able to:
- Demonstrate how a DBMS processes, optimises and executes a query
- Identify issues arising from concurrent or distributed processing and select appropriate approaches to mitigate those isues
- Choose appropriate approaches for data storage and access
Knowledge and Understanding
Having successfully completed this module, you will be able to demonstrate knowledge and understanding of:
- The internals of a database management system
- The variety of available DBMS types and the circumstances in which they are appropriate
- The issues involved in developing database management software
Subject Specific Practical Skills
Having successfully completed this module you will be able to:
- Select an appropriate DBMS for an application
- Implement components of a DBMS
Syllabus
Learning and Teaching
Type | Hours |
---|---|
Wider reading or practice | 30.5 |
Follow-up work | 18 |
Completion of assessment task | 37.5 |
Revision | 10 |
Lecture | 36 |
Preparation for scheduled sessions | 18 |
Total study time | 150 |
Resources & Reading list
Textbooks
Elmasri, R. and Navathe, S.B., (2004). Fundamentals of Database Systems. Addison Wesley.
Garcia-Molina, H., Ullman, J.D. and Widom J. (2009). Database Systems: The Complete Book. Pearson.
Assessment
Summative
This is how we’ll formally assess what you have learned in this module.
Method | Percentage contribution |
---|---|
Final Assessment | 75% |
Continuous Assessment | 25% |
Referral
This is how we’ll assess you if you don’t meet the criteria to pass this module.
Method | Percentage contribution |
---|---|
Set Task | 100% |
Repeat
An internal repeat is where you take all of your modules again, including any you passed. An external repeat is where you only re-take the modules you failed.
Method | Percentage contribution |
---|---|
Set Task | 100% |
Repeat Information
Repeat type: Internal & External