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 | Databases and Information Systems | ||
Code | CSCK542 | ||
Coordinator |
Mr K Dures Computer Science K.Dures@liverpool.ac.uk |
||
Year | CATS Level | Semester | CATS Value |
Session 2020-21 | Level 7 FHEQ | Whole Session | 15 |
Aims |
|
1. To provide a critical understanding of the design and realisation of database systems. |
Learning Outcomes |
|
(M1) A deep and critical insight into database systems and computer information systems. |
|
(M2) A comprehensive ability to implement a functioning database using current tools and structures, and employing current design practices. |
|
(M3) Demonstrate a critical understanding of database querying via analysis of results. |
|
(M4) Integrate appropriate security and backup in planning database maintenance and administration. |
|
(S1) Communication skills in electronic and written form. |
|
(S2) Self-direction and originality in tackling and solving problems. |
|
(S3) An ability to act autonomously and professionally when planning and implementing solutions to computer science problems. |
|
(S4) Experience of working in development teams, respecting others, co-operating, negotiating/persuading, awareness of independence with others. |
Syllabus |
|
Week 1: Evolution and Fundamentals of Database Systems Week 2: The Relational model Week 3: Analysis and Design of Database Systems Week 4: Transaction Management Week 5: Query Languages Week 6: Database connectivity Week 7: Web technology and DBs Week 8: Alternative Database Paradigms |
Teaching and Learning Strategies |
|
The mode of delivery is by online learning, facilitated by a Virtual Learning Environment (VLE). This mode of study enables students to pursue modules via home study while continuing in employment. Module delivery involves the establishment of a virtual classroom in which a relatively small group of students (usually 10-25) work under the direction of a faculty member. Module delivery proceeds via a series of eight one-week online sessions, each of which comprises an online lecture, supported by other eLearning activities, posted electronically to a public folder in the virtual classroom. The eLearning activities will include lecture casts, live seminar sessions, self-assessment activities, reading materials and other multimedia resources. Communication within the virtual classroom is asynchronous, preserving the requirement that students are able to pursue the course in their own time, within the weekly time-frame of each seminar. An important element of the module provision is act ive learning through collaborative, cohort-based, learning using discussion fora where the students engage in assessed discussions facilitated by the faculty member responsible for the module. This in turn encourages both confidence and global citizenship (given the international nature of the online student body). |
Teaching Schedule |
Lectures | Seminars | Tutorials | Lab Practicals | Fieldwork Placement | Other | TOTAL | |
Study Hours |
24 |
40 |
64 | ||||
Timetable (if known) | |||||||
Private Study | 86 | ||||||
TOTAL HOURS | 150 |
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 |
Programming: Practical database and information systems exercise resulting in a demonstrable system and supporting analysis in the form of a brief report (500 words) | 12 hours | 30 | ||||
Group Presentation: Database and information systemsâ group project resulting in a demonstrable system and group video report (10 minutes) describing and analysing the approach taken and the system | 12 hours | 30 | ||||
Discussion Question 1: Participate actively in an online discussion to critically discuss experiences and opinions within the cohort regarding the nature of database and information systems. | 1000-1500 words | 20 | ||||
Discussion Question 2: Actively participate in online discussion on a module-specific topic, contributing original thought and understanding of key areas. | 1000-1500 words | 20 |
Recommended Texts |
|
Reading lists are managed at readinglists.liverpool.ac.uk. Click here to access the reading lists for this module. |