CSC-20002 - Database Systems
Coordinator: Thomas Neligwa Room: CR006 Tel: +44 1782 7 33476
Lecture Time: See Timetable...
Level: Level 5
Credits: 15
Study Hours: 150
School Office: 01782 733075

Programme/Approved Electives for 2023/24

None

Available as a Free Standing Elective

No

Co-requisites

None

Prerequisites

Successful completion of CSC-10029 Fundamentals of Computing or equivalent, and CSC-10024 Programming I or equivalent.


Barred Combinations

None

Description for 2023/24

This module introduces students to databases and database management systems by providing theoretical knowledge and practical experience in data modelling, database design, implementation and administration.
The module develops the following Keele Graduate attributes:
2. An appreciation of the development and value of your chosen subjects of study, awareness of their contexts, the links between them, and awareness of the provisional and dynamic nature of knowledge.
3. Information literacy: the ability to locate, evaluate and synthesise large amounts of frequently conflicting information, ideas and data.
4. The ability creatively to solve problems using a range of different approaches and techniques, and to determine which techniques are appropriate for the issue at hand.
6. The ability to communicate clearly and effectively in written and verbal forms for different purposes and to a variety of audiences.
7. The knowledge, skills, self-confidence and self-awareness actively to pursue your future goals.

Aims
To introduce students to databases and database management systems by providing theoretical knowledge and practical experience in data modelling, database design, implementation and administration.

Intended Learning Outcomes

describe and advise upon the benefits and characteristics of database models and database management systems (DBMS) and the importance of data independence, and comment upon the level of data independence offered by a particular DBMS: 2
determine whether a given relational database is well designed (ie. meets BCNF criteria) and transform a schema into BCNF: 2
create and query a relational database using command level SQL: 1
describe and advise upon the important aspects of a database implementation, operation and maintenance (including storage structures, recovery, concurrency and security mechanisms): 1,2
use data modelling techniques for the design of databases: 1,2
design and build a small database system with a web interface: 1
show awareness and knowledge of other types of database interfaces: 2
identify the important characteristics of the relational model for the purposes of developing relational databases: 1,2

Study hours

20 hours lectures
20 hours practical work (labs)
5 hours tutorials/workshops
103 hours Independent study/coursework
2 hour Examination

School Rules

None

Description of Module Assessment

1: Coursework weighted 40%
Practical assessment of database development
Design and implementation of a small database.

2: Open Book Examination weighted 60%
Online open-book exam
The exam will cover all topics addressed in the lectures. This exam will have short-answer questions focusing on theoretical as well as problem-solving skills learned in the module. The exam will have three questions and candidates are asked to attempt all three questions. The paper will be released on the KLE as a Word document on the morning of the Exam and should be completed within 24 hours. Students should answer each question using Word, clearly labelling each question as they provide their answers. Answers should be as accurate and concise as possible. Although students have been given a significant amount of time to complete this exam paper, we expect most students to complete the exam in about 2 hours. International students will be asked to notify the School if they need an extension due to different time zones.