Module and Programme Catalogue

Search site

Find information on

2018/19 Taught Postgraduate Module Catalogue

COMP5112M Data Management

15 creditsClass Size: 65

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

Taught: Semester 1 (Sep to Jan) View Timetable

Year running 2018/19

This module is not approved as an Elective

Module summary

This module covers the principles of the design and implementation of database management systems, including the theory of relational databases and E-R modeling; and the use of SQL to create and manipulate data in a database.

Objectives

On completion of this module, students should be able to:
- Identify the main functions of a database management system (DBMS)
- Describe the architecture of a relational database system
- Produce a relational schema from an entity-relationship conceptual model. - Explain the distinction between procedural and declarative queries and the meaning and significance of relational completeness.
- Express simple queries using relational algebra and relational calculus. - Determine functional dependencies and use inference rules to generate functional dependencies.
- Use SQL to create, maintain and manipulate data in a relational database. - Use transactions to structure manipulation of data.
- Embed simple SQL within an application program
- Determine what normal form a table is in, and explain the advantages and disadvantages of normalization.
- Explain the importance of information systems not based on the relational model.

Syllabus

- History of, motivation for, and functions of database systems
- The relational data model
- Mapping conceptual schemas to relational schemas.
- Foundations of procedural and declarative query languages:
relational algebra, relational calculus, relational completeness, connections with other logical formalisms including 1st order logic.
- Superkeys, Candidate keys, Primary Keys, Foreign Keys.
- Functional dependencies, Armstrong's axioms and other inference rules
- Normal forms: 1NF, 2NF, 3NF, BCNF
- SQL including data definition, queries, triggers, and integrity constraints - Relational database design including applications of normalization
- Transactions
- Query optimisation and implementation of relational operations.
- Embedding SQL within application programs
- Non-relational approaches and semi-structured data

Teaching methods

Delivery typeNumberLength hoursStudent hours
Practical Demonstration61.006.00
Class tests, exams and assessment12.002.00
Lecture201.0020.00
Private study hours122.00
Total Contact hours28.00
Total hours (100hr per 10 credits)150.00

Methods of assessment


Coursework
Assessment typeNotes% of formal assessment
ReportModeling and Design20.00
AssignmentLab based - Implementation20.00
Total percentage (Assessment Coursework)40.00

Normally resits will be assessed by the same methodology as the first attempt, unless otherwise stated


Exams
Exam typeExam duration% of formal assessment
Open Book exam2 hr 00 mins60.00
Total percentage (Assessment Exams)60.00

This module is re-assessed by exam only

Reading list

The reading list is available from the Library website

Last updated: 04/10/2018

Disclaimer

Browse Other Catalogues

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

© Copyright Leeds 2019