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 concept of data modelling
- The relational model of data
- The role of database systems in information management
Syllabus
Learning and Teaching
Teaching and learning methods
| Type | Hours |
|---|---|
| Revision | 8 |
| Specialist Laboratory | 20 |
| Lecture | 36 |
| Preparation for scheduled sessions | 10 |
| Completion of assessment task | 38 |
| Follow-up work | 18 |
| Wider reading or practice | 20 |
| Total study time | 150 |
Resources & Reading list
Textbooks
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.
H.J. Garcia-Molina et al (2009). Database systems : the complete book. Pearson Prentice Hall.
C.J. Date (2004). An Introduction to Database Systems. Addison-Wesley.
T.M. Connolly and C.E. Begg. 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 |
|---|---|
| Coursework | 30% |
| Laboratory | 30% |
| Examination | 40% |
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% |