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 | DATABASE DEVELOPMENT | ||
Code | COMP207 | ||
Coordinator |
Dr R Ibsen-Jensen Computer Science R.Ibsen-Jensen@liverpool.ac.uk |
||
Year | CATS Level | Semester | CATS Value |
Session 2020-21 | Level 5 FHEQ | First Semester | 15 |
Aims |
|
To introduce students to |
Learning Outcomes |
|
(LO1) Demonstrate an understanding of basic and advanced SQL topics; |
|
(LO2) At the end of this module the student will be able to identify and apply the principles underpinning transaction management within DBMS and the main security issues involved in securing transaction; |
|
(LO3) Illustrate the issues related to Web technologies as a semi-structured data representation formalism; |
|
(LO4) Interpret the main concepts and security aspects in data warehousing, and the concepts of data mining and commercial considerations involved in adopting the paradigm. |
|
(S1) Problem Solving - Numeracy and computational skills |
|
(S2) Problem solving – Analysing facts and situations and applying creative thinking to develop appropriate solutions. |
Syllabus |
|
Basic and advanced SQL topics (5 lectures): SELECT, INSERT, DELETE, indexes and materialised view; |
Teaching and Learning Strategies |
|
Teaching Method 1 - Lecture Teaching Method 2 - Tutorial Teaching Method 3 - Laboratory Work Due to Covid-19, in 2020/21, one or more of the following delivery methods will be implemented based on the current local conditions. (b) Fully online delivery and assessment (c) Standard on-campus delivery with minimal social distancing |
Teaching Schedule |
Lectures | Seminars | Tutorials | Lab Practicals | Fieldwork Placement | Other | TOTAL | |
Study Hours |
30 |
5 |
5 |
40 | |||
Timetable (if known) | |||||||
Private Study | 110 | ||||||
TOTAL HOURS | 150 |
Assessment |
||||||
EXAM | Duration | Timing (Semester) |
% of final mark |
Resit/resubmission opportunity |
Penalty for late submission |
Notes |
(207) Written Exam There is a resit opportunity. Standard UoL penalty applies for late submission. This is an anonymous assessment. Assessment Schedule (When) :Semester 1 | 120 minutes. | 70 | ||||
CONTINUOUS | Duration | Timing (Semester) |
% of final mark |
Resit/resubmission opportunity |
Penalty for late submission |
Notes |
(207.2) Assessment 2 There is a resit opportunity. Standard UoL penalty applies for late submission. This is not an anonymous assessment. Assessment Schedule (When) :1 | 25 hours for all CA | 15 | ||||
(207.1) Assessment 1 There is a resit opportunity. Standard UoL penalty applies for late submission. This is not an anonymous assessment. Assessment Schedule (When) :1 | 25 hours for all CA | 15 |
Recommended Texts |
|
Reading lists are managed at readinglists.liverpool.ac.uk. Click here to access the reading lists for this module. |