Module overview
Aims and Objectives
Learning Outcomes
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
Subject Specific Intellectual and Research Skills
Having successfully completed this module you will be able to:
- Identify issues arising from concurrent or distributed processing and select appropriate approaches to mitigate those isues
- Demonstrate how a DBMS processes, optimises and executes a query
- 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 issues involved in developing database management software
- The variety of available DBMS types and the circumstances in which they are appropriate
Syllabus
Learning and Teaching
Type | Hours |
---|---|
Completion of assessment task | 37.5 |
Follow-up work | 18 |
Preparation for scheduled sessions | 18 |
Lecture | 36 |
Revision | 10 |
Wider reading or practice | 30.5 |
Total study time | 150 |
Resources & Reading list
Textbooks
Garcia-Molina, H., Ullman, J.D. and Widom J. (2009). Database Systems: The Complete Book. Pearson.
Elmasri, R. and Navathe, S.B., (2004). Fundamentals of Database Systems. Addison Wesley.
Assessment
Summative
This is how we’ll formally assess what you have learned in this module.
Method | Percentage contribution |
---|---|
Continuous Assessment | 25% |
Final Assessment | 75% |
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