CS3101 Databases

Academic year

2023 to 2024 Semester 2

Further information on which modules are specific to your programme.

Key module information

SCOTCAT credits

15

The Scottish Credit Accumulation and Transfer (SCOTCAT) system allows credits gained in Scotland to be transferred between institutions. The number of credits associated with a module gives an indication of the amount of learning effort required by the learner. European Credit Transfer System (ECTS) credits are half the value of SCOTCAT credits.

SCQF level

SCQF level 9

The Scottish Credit and Qualifications Framework (SCQF) provides an indication of the complexity of award qualifications and associated learning and operates on an ascending numeric scale from Levels 1-12 with SCQF Level 10 equating to a Scottish undergraduate Honours degree.

Planned timetable

To be arranged.

This information is given as indicative. Timetable may change at short notice depending on room availability.

Module Staff

TBC Module coordinator(s): Honours Coordinator - Computer Science (hons-coord-cs@st-andrews.ac.uk)

This information is given as indicative. Staff involved in a module may change at short notice depending on availability and circumstances.

Module description

This module introduces data models and modeling techniques, relational design and normalisation. It also examines a range of issues in database implementation, including indexing, query processing, transactions and recovery.

Relationship to other modules

Pre-requisites

BEFORE TAKING THIS MODULE YOU MUST PASS CS2002 AND ( PASS CS2101 OR PASS CS2001 )

Assessment pattern

3-hour Examination = 40%, Coursework = 60%

Re-assessment

3-hour Examination = 40%, Coursework = 60%

Learning and teaching methods and delivery

Weekly contact

2 lectures (x 11 weeks) and fortnightly tutorial.

Scheduled learning hours

28

The number of compulsory student:staff contact hours over the period of the module.

Guided independent study hours

122

The number of hours that students are expected to invest in independent study over the period of the module.