Module overview
Aims and Objectives
Learning Outcomes
Subject Specific Intellectual and Research Skills
Having successfully completed this module you will be able to:
- Define, normalise and query databases
- Structure data and documents using markup languages
- Use the UNIX command line effectively and construct shell scripts using data manipulation tools
Knowledge and Understanding
Having successfully completed this module, you will be able to demonstrate knowledge and understanding of:
- The structure and facilities of the Unix system and its application to system tasks
- The relational model of data
- The role of database systems in information management
- The concept of data modelling
Syllabus
Learning and Teaching
Teaching and learning methods
| Type | Hours |
|---|---|
| Specialist Laboratory | 20 |
| Wider reading or practice | 20 |
| Preparation for scheduled sessions | 10 |
| Lecture | 36 |
| Revision | 8 |
| Follow-up work | 18 |
| Completion of assessment task | 38 |
| Total study time | 150 |
Resources & Reading list
Textbooks
H.J. Garcia-Molina et al (2009). Database systems : the complete book. Pearson Prentice Hall.
T.M. Connolly and C.E. Begg. Database systems. Addison-Wesley.
R. Elmasri and S. Navathe (2007). Fundamentals of database systems. Pearson/Addison Wesley.
Mike Joy, Stephen Jarvis and Michael Luck (2002). Introducing Unix and Linux. Palgrave Macmillan.
C.J. Date (2004). An Introduction to Database Systems. Addison-Wesley.
Assessment
Assessment strategy
This module is assessed by a combination of coursework, assessed laboratories and a final assessment in the form of a computer aided examination.Summative
This is how we’ll formally assess what you have learned in this module.
| Method | Percentage contribution |
|---|---|
| Laboratory | 30% |
| Examination | 40% |
| Coursework | 30% |
Referral
This is how we’ll assess you if you don’t meet the criteria to pass this module.
| Method | Percentage contribution |
|---|---|
| Examination | 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 |
|---|---|
| Examination | 100% |