LCSCI7228 Database Management Systems Course Descriptor

Course Summary

This course prepares students to be sophisticated users of relational and non-relational database management systems. The course gives a critical understanding of: (i) how information is logically organised in a database (i.e. the relational model) as well as how information is physically organised on storage media (e.g. computer disks); (iii) logical operations on the data (i.e. relational algebra) and how they can be combined to create well-formed queries over the data; and (iv) how database systems ensure atomicity, consistency, isolation, and durability of user transactions when multiple users query or modify data concurrently. There is a particular focus on sustainable development. Finally, the course’s group assignment provides students with practical experience on building database applications.

Course Aims

The aims of the course are:

• Develop a critical understanding of the design and implementation of database systems and their usage in real-world applications.
• Gain hands-on experience by developing a complete database application from the ground up, applying conceptual knowledge to solve a practical problem.

Learning Outcomes

On successful completion of the course, students will be able to:

Knowledge and Understanding

Subject Specific Skills

Transferable and Professional Skills

Teaching and Learning

This course has a dedicated Virtual Learning Environment (VLE) page with a syllabus and range of additional resources (e.g. readings, question prompts, tasks, assignment briefs, discussion boards) to orientate and engage you in your studies.

The scheduled teaching and learning activities for this course are:

Lectures/Labs: Contact hours are typically a mix of weekly lectures and lab sessions, totalling up to 50 scheduled hours:

• Version 1: All sessions in the same sized group, or
• Version 2: most of the sessions in larger groups; some of the sessions in smaller groups

Faculty hold regular ‘office hours’, which are opportunities for students to drop in or sign up to explore ideas, raise questions, or seek targeted guidance or feedback, individually or in small groups.

Students are to attend and participate in all the scheduled teaching and learning activities for this course and to manage their directed learning and independent study.

Indicative total learning hours for this course: 150

Employability Skills

• Communication skills 
• Programming skills
• Team-based project skills

Assessment

Formative

Students will be formatively assessed during the course by means of set assignments. These do not count towards the end of year results but will provide students with developmental feedback. Set assignments will also amplify problem-solving skills useful for the set exercises and develop software components that form part of the students’ projects.

Summative

Assessment will be in two forms:

The examination will consist of a number of questions from which the student will have the choice of answering a specified number. The project and the examination will be assessed in accordance with the assessment aims set out in the Programme Specification.

Feedback

Students will receive formal feedback in a variety of ways: written (including via email correspondence); oral (within one-to-one tutorials or on an ad hoc basis) and indirectly through discussion during group tutorials.

Feedback on examinations is provided through generic internal examiners’ reports and are made available to the student on the VLE. For all other summative assessment methods, feedback is made available to the student either via email, the VLE or another appropriate method.

Indicative Reading

Note: Comprehensive and current reading lists for courses are produced annually in the Course Syllabus or other documentation provided to students; the indicative reading list provided below is used as part of the approval/modification process only.

Books

• Ramez Elmasri and Shamkant Navathe. 2016. Fundamentals of Database Systems, 7th edition (7th. ed.). Pearson Publications, USA

Journals

• E. F. Codd. 1970. A relational model of data for large shared data banks. Commun. ACM 13, 6 (June 1970), 377–387. DOI: https://doi.org/10.1145/362384.362685
• Donald D. Chamberlin and Raymond F. Boyce. 1974. SEQUEL: A structured English query language. In Proceedings of the 1974 ACM SIGFIDET (now SIGMOD) workshop on Data description, access and control (SIGFIDET ’74). Association for Computing Machinery, New York, NY, USA, 249–264. DOI: https://doi.org/10.1145/800296.811515
• Christof Strauch. NoSQL Databases (e-book)

Indicative Topics

Students will study the following topics: 

• Conceptual understanding of database usage and design
• Relational data model and relational algebra
• ER diagrams and normalisation
• SQL
• Indexing
• Transactions
• Code implementation
• User interface skills
• Collaborative design skills
• non-relational databases