Module Details |
The information contained in this module specification was correct at the time of publication but may be subject to change, either during the session because of unforeseen circumstances, or following review of the module at the end of the session. Queries about the module should be directed to the member of staff with responsibility for the module. |
Title | APPLIED DATABASE MANAGEMENT | ||
Code | COMP283 | ||
Coordinator |
Dr SA Scanlon Computer Science Shagufta.Scanlon@liverpool.ac.uk |
||
Year | CATS Level | Semester | CATS Value |
Session 2019-20 | Level 5 FHEQ | Second Semester | 7.5 |
Aims |
|
To utilise Relational Algebra to develop efficient Database Query Language code. To provide practical experience of designing relational databases. To provide the skills to manage and maintain a database system using commercial Database Management Systems such as Microsoft SQL Server. To introduce the skills required to maintain data integrity and durability across database systems. |
Learning Outcomes |
|
(LO1) At the end of the module the student should be able to: design and structure an efficient scalable database system. |
|
(LO2) Implement and configure a database system. |
|
(LO3) Maintain a secure and durable database. |
|
(LO4) Describe, illustrate and explain the concept of linked databases and data migration techniques. |
|
(S1) Learning Skills: Demonstrate typical database system design tasks. |
|
(S2) Employability Skills: Demonstrate the ability to develop sensible plans for disaster recovery and business continuity. |
Syllabus |
|
Introduction to Relational Algebra and Database Management Systems (2 Lectures, 2 Practicals) Introduction to Design and Implementation of Relational Databases (3 Lectures, 3 Practicals) Database Administration Concepts (4 Lectures, 4 Practicals) Introduction to Inter-database connectivity and data warehousing (2 Lectures, 1 Practical) |
Teaching and Learning Strategies |
|
Teaching Method 1 - Lecture Teaching Method 2 - Laboratory Work |
Teaching Schedule |
Lectures | Seminars | Tutorials | Lab Practicals | Fieldwork Placement | Other | TOTAL | |
Study Hours |
10 |
10 |
20 | ||||
Timetable (if known) | |||||||
Private Study | 55 | ||||||
TOTAL HOURS | 75 |
Assessment |
||||||
EXAM | Duration | Timing (Semester) |
% of final mark |
Resit/resubmission opportunity |
Penalty for late submission |
Notes |
CONTINUOUS | Duration | Timing (Semester) |
% of final mark |
Resit/resubmission opportunity |
Penalty for late submission |
Notes |
Assessment 2 There is a resit opportunity. Standard UoL penalty applies for late submission. This is not an anonymous assessment. Assessment Schedule (When) :Semester 2 | 30 hours expected fo | 35 | ||||
Assessment 1 There is a resit opportunity. Standard UoL penalty applies for late submission. This is not an anonymous assessment. Assessment Schedule (When) :Semester 2 | 30 hours expected fo | 30 | ||||
Assessment 3 Standard UoL penalty applies for late submission. This is not an anonymous assessment. Assessment Schedule (When) :Semester 2 | 30 hours expected fo | 35 |
Recommended Texts |
|
Reading lists are managed at readinglists.liverpool.ac.uk. Click here to access the reading lists for this module. |