CS2DB16-Databases

Module Provider: School of Mathematical, Physical and Computational Sciences
Number of credits: 10 [5 ECTS credits]
Level:5
Terms in which taught: Autumn / Summer term module
Pre-requisites: SE1PR11 Programming SE1FA15 Fundamentals and Applications of Computing
Non-modular pre-requisites:
Co-requisites:
Modules excluded:
Module version for: 2016/7

Module Convenor: Dr Frederic Stahl

Email: f.t.stahl@reading.ac.uk

Summary module description:
This module covers an introduction to databases.

Aims:
To provide students with the underlying principles and practical experience of the design and implement scalable, secure databases.

Assessable learning outcomes:
The student will be able to:
• carry out the analysis of a simple problem susceptible to solution using database technology;
• produce a well-structured design in terms of the structural elements of a relational database;
• design and implement a database application to solve the problem posed;
• use the SQL language, including DDL, an in-database procedural language such as PL/SQL, and database triggers;
• describe RDBMS features such as transaction management, locking and consistent backups;
• describe SQL optimisation issues.

Additional outcomes:
Practical experience in design and implementation of a relational database.

Outline content:
Knowledge of basic principles of the relational database model, relations, attributes, keys, Entity-Relationship and Relational Modelling, Normalisation, the SQL language.
Data storage structures
Transactions and locking
Procedural and object-oriented languages used with RDBMSs, PL/SQL

Brief description of teaching and learning methods:
The theoretical part of the course will be delivered via lectures. For practicals in the first half of the term, students will use the Oracle PostgreSQL to learn the basics of SQL. Later in the term, practicals will be used for students to undertake their own assignments. A practical task will be set requiring the student to exercise the analytical, design and development skills to create a usable and useful software system.

Contact hours:
  Autumn Spring Summer
Lectures 19 1
Practicals classes and workshops 10
Guided independent study 70
       
Total hours by term 99.00 1.00
       
Total hours for module 100.00

Summative Assessment Methods:
Method Percentage
Written exam 50
Set exercise 50

Other information on summative assessment:

Formative assessment methods:

Penalties for late submission:
The Module Convenor will apply the following penalties for work submitted late, in accordance with the University policy.

  • where the piece of work is submitted up to one calendar week after the original deadline (or any formally agreed extension to the deadline): 10% of the total marks available for the piece of work will be deducted from the mark for each working day (or part thereof) following the deadline up to a total of five working days;
  • where the piece of work is submitted more than five working days after the original deadline (or any formally agreed extension to the deadline): a mark of zero will be recorded.

  • The University policy statement on penalties for late submission can be found at: http://www.reading.ac.uk/web/FILES/qualitysupport/penaltiesforlatesubmission.pdf
    You are strongly advised to ensure that coursework is submitted by the relevant deadline. You should note that it is advisable to submit work in an unfinished state rather than to fail to submit any work.

    Length of examination:
    One 90-mins examination paper in May/June.

    Requirements for a pass:
    A mark of 40% overall

    Reassessment arrangements:
    Examination only.
    One 90-mins examination paper in August/September.

    Additional Costs (specified where applicable):
    1) Required text books:
    2) Specialist equipment or materials:
    3) Specialist clothing, footwear or headgear:
    4) Printing and binding:
    5) Computers and devices with a particular specification:
    6) Travel, accommodation and subsistence:

    Last updated: 4 January 2017

    Things to do now