CSC2513 : Database Systems

Semester 2 Credit Value: 20
ECTS Credits: 10.0


To introduce the fundamentals of database system design and use.

The module introduces the fundamentals of database systems. You will understand and be able to apply the relational data model and be proficient in manipulating database systems. Among the topics covered are: Principles of data models and multi-level architectures; relational data model; user requirements; database conceptual design; SQL standard; database logical and physical design; database procedures; database management.

Outline Of Syllabus

Information Management – database systems
- Motivation for database systems
- Components of database systems
- DBMS functions
- Database architecture and data independence
- Use of a declarative query language
- Query processing and optimization
Information Management – data modeling
- Data modeling
- Conceptual models (such as entity-relationship)
- Relational data model
Information Management – indexing
- The massive impact of indexes on query performance
- The basic structure of an index;
- Keeping a buffer of data in memory;
- Creating indexes with SQL;
Information Management – relational databases
- Mapping conceptual schema to a relational schema
- Entity and referential integrity
- Relational algebra
Information Management – query languages
- Overview of database languages
- SQL (data definition, query formulation, update sublanguage, constraints, integrity)
- Embedding non-procedural queries in a procedural language
- Stored procedures
Information Management – relational database design
- Database design
- Functional dependency
- Decomposition of a schema; lossless-join and dependency-preservation properties of a decomposition
- Candidate keys, superkeys, and closure of a set of attributes
- Normal forms (1NF, 2NF, 3NF, BCNF)
- Transaction management in database systems

Teaching Methods

Teaching Activities
Category Activity Number Length Student Hours Comment
Guided Independent StudyAssessment preparation and completion480:3024:00Revision for end of semester exam & exam duration.
Guided Independent StudyAssessment preparation and completion441:0044:00Lecture follow-up
Scheduled Learning And Teaching ActivitiesLecture441:0044:00Lectures
Scheduled Learning And Teaching ActivitiesPractical111:0011:00Practicals
Guided Independent StudyProject work111:0011:00Coursework
Guided Independent StudyIndependent study332:0066:00Background reading
Teaching Rationale And Relationship

Lectures will be used to introduce the learning material and for demonstrating the key concepts by example. Students are expected to follow-up lectures within a few days by re-reading and annotating lecture notes to aid deep learning.

This is a very practical subject, and it is important that the learning materials are supported by hands-on opportunities provided by practical classes. Students are expected to spend time on coursework outside timetabled practical classes.

Students aiming for 1st class marks are expected to widen their knowledge beyond the content of lecture notes through background reading.

Students should set aside sufficient time to revise for the end of semester exam.

Assessment Methods

The format of resits will be determined by the Board of Examiners

Description Length Semester When Set Percentage Comment
Written Examination1202A70N/A
Other Assessment
Description Semester When Set Percentage Comment
Case study2M30Extended coursework - application case study. 2000 words max.
Assessment Rationale And Relationship

In the written examination the questions will assess fundamental knowledge and understanding of theory and application of database design and usage.
The coursework exercise develops knowledge and competence with the various modelling techniques and other skills acquired during the course.

N.B. This module has both “Exam Assessment” and “Other Assessment” (e.g. coursework). If the total mark for either assessment falls below 35%, the maximum mark returned for the module will normally be 35%.

Reading Lists