This module is inactive in the selected year. The information shown below is for the academic year that the module was last running in, prior to the year selected.
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 type | Number | Length hours | Student hours |
| Practical Demonstration | 6 | 1.00 | 6.00 |
| Class tests, exams and assessment | 1 | 2.00 | 2.00 |
| Lecture | 20 | 1.00 | 20.00 |
| Private study hours | 122.00 | ||
| Total Contact hours | 28.00 | ||
| Total hours (100hr per 10 credits) | 150.00 | ||
Methods of assessment
Coursework
| Assessment type | Notes | % of formal assessment |
| Report | Modeling and Design | 20.00 |
| Assignment | Lab based - Implementation | 20.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 type | Exam duration | % of formal assessment |
| Open Book exam | 2 hr 00 mins | 60.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 websiteLast updated: 04/10/2018
Browse Other Catalogues
- Undergraduate module catalogue
- Taught Postgraduate module catalogue
- Undergraduate programme catalogue
- Taught Postgraduate programme catalogue
Errors, omissions, failed links etc should be notified to the Catalogue Team.PROD