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
Taught: Semester 1 View Timetable
Year running 2018/19
This module is not approved as an Elective
Module summaryThis 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.
ObjectivesOn 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.
- 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
- Query optimisation and implementation of relational operations.
- Embedding SQL within application programs
- Non-relational approaches and semi-structured data
|Delivery type||Number||Length hours||Student hours|
|Class tests, exams and assessment||1||2.00||2.00|
|Private study hours||122.00|
|Total Contact hours||28.00|
|Total hours (100hr per 10 credits)||150.00|
Methods of assessment
|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
|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 listThe reading list is available from the Library website
Last 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.SPT8