CS258-15 Database Systems

Academic year
22/23
Department
Computer Science
Level
Undergraduate Level 2
Module leader
Andrew Hague
Credit value
15
Module duration
10 weeks
Assessment
Multiple
Study location
University of Warwick main campus, Coventry
Introductory description

This module studies Data Base Management Systems (DBMSs): the science and technology for organising and retrieving large amounts of structures data efficiently. It presents in depth the Relational Model and the declarative language SQL and explains how it can be used to define and interrogate databases. It also shows how to access databases from procedural programs (such as Java or C++). It discusses the formal underpinnings of Relational Databases, and Relational Algebra and Relational Calculus and how to optimally define the Database using relations/tables. Finally, it also discusses issues pertaining to security and object relation mapping.

Module aims

This module studies Data Base Management Systems (DBMSs): the science and technology for organising and retrieving large amounts of structures data efficiently. It presents in depth the Relational Model and the declarative language SQL and explains how it can be used to define and interrogate databases. It also shows how to access databases from procedural programs (such as Java or C++). It discusses the formal underpinnings of Relational Databases, and Relational Algebra and Relational Calculus and how to optimally define the Database using relations/tables. Finally, it also discusses issues pertaining to security and object relation mapping.

Outline syllabus

This is an indicative module outline only to give an indication of the sort of topics that may be covered. Actual sessions held may differ.

Learning outcomes

By the end of the module, students should be able to:

Indicative reading list

Please see Talis Aspire link for the most up to date list.

View reading list on Talis Aspire

Subject specific skills

Understanding of:

Transferable skills

Include:

Study time

Type Required
Lectures 30 sessions of 1 hour (20%)
Seminars 8 sessions of 1 hour (5%)
Private study 112 hours (75%)
Total 150 hours
Private study description

Private study consists of:

Costs

No further costs have been identified for this module.

You do not need to pass all assessment components to pass the module.

Students can register for this module without taking any assessment.

Assessment group D3
Weighting Study time
Unsupervised practical Assignment 30%

Unsupervised practical assignment. This assignment is worth more than 3 CATS and is not, therefore, eligible for self-certification.

In-person Examination 70%

CS258 Exam


  • Answerbook Pink (12 page)
Assessment group R2
Weighting Study time
On-campus Examination - Resit 100%

CS258 resit examination


  • Answerbook Pink (12 page)
Feedback on assessment

Individual written feedback on each assignment.

Past exam papers for CS258

Courses

This module is Core for:

  • UCSA-G500 Undergraduate Computer Science
    • Year 2 of G500 Computer Science
    • Year 2 of G500 Computer Science
  • UCSA-G503 Undergraduate Computer Science MEng
    • Year 2 of G500 Computer Science
    • Year 2 of G503 Computer Science MEng
    • Year 2 of G503 Computer Science MEng
  • Year 2 of UCSA-I1N1 Undergraduate Computer Science with Business Studies
  • USTA-G302 Undergraduate Data Science
    • Year 2 of G302 Data Science
    • Year 2 of G302 Data Science
  • Year 2 of USTA-G304 Undergraduate Data Science (MSci)
  • Year 2 of USTA-G305 Undergraduate Data Science (MSci) (with Intercalated Year)

This module is Optional for:

  • Year 2 of UCSA-G406 Undergraduate Computer Systems Engineering
  • Year 2 of UCSA-G408 Undergraduate Computer Systems Engineering

This module is Option list B for:

  • UCSA-G4G1 Undergraduate Discrete Mathematics
    • Year 2 of G4G1 Discrete Mathematics
    • Year 2 of G4G1 Discrete Mathematics
  • Year 2 of UCSA-G4G3 Undergraduate Discrete Mathematics