Keele Badge

CSC-20061 - Module Specification
School of Computing and Mathematics
Faculty of Natural Sciences

For academic year: 2022/23 Last Updated: 19 January 2023

CSC-20061 - Databases
Coordinator: Vishwash Batra Tel: +44 1782 7 33114
Lecture Time: See Timetable...
Level: Level 5
Credits: 15
Study Hours: 150
School Office: 01782 733075

Programme/Approved Electives for 2022/23

None

Available as a Free Standing Elective

No

Co-requisites

None

Prerequisites

None

Barred Combinations

None

Description for 2022/23


Aims
To introduce learners 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: 1
determine whether a given relational database is well designed (ie. meets BCNF criteria) and transform a schema into BCNF: 1
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: 1
use data modelling techniques for the design of databases: 1
show awareness and knowledge of other types of database interfaces: 1
distinguish the important characteristics of the relational model for the purposes of developing relational databases: 1

Study hours

16 hours practical work (supported online and in block release)
6 hours tutorials/workshops (supported online and in block release)
16 hours online lectures
112 hours Independent study/coursework

School Rules

None

Description of Module Assessment

1: Coursework weighted 100%
Practical assessment of database development
Design and implementation of a small database based on a relevant case study. Along with the database, schema and code. Learners will submit a technical report describing the features implemented, evaluating the design choices made and commenting on areas such as data independence. The technical report is approximately 2000 words.

Please note that for the 2022/23 Academic Year programmes may be adapted to operate in accordance with a flexible, digital approach. This means that there may be some changes made to how modules are delivered and assessed. The latest information will be provided to you by your School in module handbooks. We endeavour to give you as much notice as possible of any changes and details about the circumstance in which changes are made to programmes can be found in the Student Agreement, available at: https://www.keele.ac.uk/student-terms-and-conditions/

Last Updated: 19 January 2023