Module and Programme Catalogue

Search site

Find information on

2020/21 Undergraduate Module Catalogue

COMP1121 Databases

10 creditsClass Size: 400

Module manager: K.McEvoy@leeds.ac.uk
Email: Dr Kevin McEvoy

Taught: Semester 2 View Timetable

Year running 2020/21

This module is not approved as a discovery module

Module summary

Databases are a common component of many computer systems, storing and retrieving data about the state of a system. This module covers the principles of the design, architecture, implementation of database systems and the role of database management systems. In order to understand the design of database system an understanding of relational theory is required as well as the tools and techniques for decomposing systems and modelling them in an appropriate manner.This module introduces the tools for manipulating data in databases and design principles that ensure data security and integrity.

Objectives

This module provides a foundation in the design and implementation of databases with an emphasis on relational database systems.

Learning outcomes
On successful completion of this module a student will have demonstrated the ability to:

- describe the purpose and architecture of database management systems.
- use appropriate tools to manipulate database systems.
- design and implement a database using appropriate tools.
- apply relational modelling techniques to real world situations.
- apply normalisation and explain the advantages and disadvantages of normalisation.
- describe the ethical, legal and security related issues concerning the implementation and administration of databases and their management systems.


Syllabus

This module covers the following 3 topic areas

- Database management systems : purpose of a database management system, architecture of a database management system, administration of a database management system, ACID principles and concurrency.
- Ethical issues regarding the use of databases in society.
- Relational databases : relational algebra, relational calculus, table design (including identifying functional dependencies, primary keys, foreign keys, selection of appropriate data type) and normal forms.
- Querying Languages : declarative querying languages, comparison of alternative approaches, manipulating databases using querying languages.

Teaching methods

Due to COVID-19, teaching and assessment activities are being kept under review - see module enrolment pages for information

Delivery typeNumberLength hoursStudent hours
Class tests, exams and assessment12.002.00
Lecture221.0022.00
Practical41.004.00
Private study hours72.00
Total Contact hours28.00
Total hours (100hr per 10 credits)100.00

Opportunities for Formative Feedback

Coursework and labs.

Methods of assessment

Due to COVID-19, teaching and assessment activities are being kept under review - see module enrolment pages for information


Coursework
Assessment typeNotes% of formal assessment
In-course AssessmentCoursework - Ethics10.00
In-course AssessmentCoursework -SQL Coursework20.00
In-course AssessmentCoursework - ER Modelling Coursework30.00
Total percentage (Assessment Coursework)60.00

This module will be reassessed by an online time-constrained assessment.


Exams
Exam typeExam duration% of formal assessment
Online Time-Limited assessment48 hr 40.00
Total percentage (Assessment Exams)40.00

This module will be reassessed by an online time-constrained assessment.

Reading list

The reading list is available from the Library website

Last updated: 17/09/2020 15:45:03

Disclaimer

Browse Other Catalogues

Errors, omissions, failed links etc should be notified to the Catalogue Team.PROD

© Copyright Leeds 2019