Course Details in 2018/19 Session

Module Title	LM Fundamentals: Databases
School	Computer Science
Department	Computer Science
Module Code	06 30379
Module Lead	Priya Manimaran
Level	Masters Level
Credits	10
Semester	Semester 2
Pre-requisites
Co-requisites
Restrictions	None
Exclusions
Description	The module will explore some of the fundamentals of databases. Topics will include: relational theory, relational algebra, query languages, data design. The necessary mathematical background will be developed alongside its application in databases. Students will be introduced to an existing database system.
Learning Outcomes	By the end of the module students should be able to: Use SQL to create, modify and query databases. Analyse a real-world scenario and perform a conceptual database design for it. Take a conceptual data design model and translate it into the relational model Use an existing database system Apply relational algebra and the mathematical theory of relations to describe databases, queries, and consistency conditions.
Assessment	30379-01 : Examination : Exam (Centrally Timetabled) - Written Unseen (80%) 30379-02 : Continuous Assessment : Coursework (20%)
Assessment Methods & Exceptions	Assessment: 1.5 hour examination (80%), continuous assessment (20%)
Other	Duplicate of Birmingham-based module 21923
Reading List