Skip to navigation | Skip to main content | Skip to footer
Menu
Menu

COMP23111: Fundamentals of Databases (2010-2011)

This is an archived syllabus from 2010-2011

Fundamentals of Databases
Level: 2
Credit rating: 10
Pre-requisites: COMP10081 and COMP10092, COMP20341 desirable
Co-requisites: No Co-requisites
Duration: 11 weeks
Lectures: 13 in total, 1 per week + Introductory Lecture
Lecturers: Sandra Sampaio
Course lecturer: Sandra Sampaio

Additional staff: view all staff
Timetable
SemesterEventLocationDayTimeGroup
Sem 1 Lecture SCHUSTER MOSELEY Tue 15:00 - 16:00 -
Sem 1 B Examples LF15 Thu 10:00 - 11:00 H
Sem 1 B Examples IT407 Fri 11:00 - 12:00 G
Sem 1 B Examples LF15 Thu 11:00 - 12:00 I
Sem 1 A w3+ Lab G23 Thu 09:00 - 11:00 H
Sem 1 A w3+ Lab G23 Fri 11:00 - 13:00 G
Sem 1 A w3+ Lab G23 Thu 11:00 - 13:00 I
Assessment Breakdown
Exam: 70%
Coursework: 0%
Lab: 30%

Themes to which this unit belongs
  • Enterprise Information Systems

Aims

The aim of the course is to provide students with an overview of database management system architectures and environments, an understanding of basic database design and implementation techniques, and practical experience of designing and building a relational database.

Programme outcomeUnit learning outcomesAssessment
A5Be able to discuss/explain the importance of data, and the difference between file management and databases.
  • Lab assessment
  • Examination
A5Be able to discuss/explain the design of database management system architectures and environments (in particular the Ansi-Sparc model).
  • Examination
  • Lab assessment
A5 C2 D1Be able to discuss/explain the principles of database design.
  • Lab assessment
  • Examination
A5 B1 B3 C2 D3 D5Be able to discuss, explain and apply conceptual design methodologies, in particular conceptual design using Extended Entity Relationship modelling.
  • Examination
  • Lab assessment
A5 B1 B3 C2 D3 D5Be able to discuss, explain and apply the relational model and mappings from conceptual designs, in particular normalisation.
  • Lab assessment
  • Examination
A5Be able to discuss/explain physical and performance related design considerations.
  • Lab assessment
  • Examination
A5Be able to discuss/explain transaction processing.
  • Examination
  • Lab assessment
A5 B1 B3 C2 D3 D5Be able to discuss, explain and apply SQL and the Oracle DBMS.
  • Examination
  • Lab assessment

Syllabus

General Introduction


Importance of data to an organisation, file management vs databases, what is a database, requirements of a database and database management system. (1)

Architectures


Ansi-Sparc model of databases, components of a database management system, schemas, levels of abstraction and mappings, role of the data dictionary, client-server systems, PC based systems, database servers; distributed systems. (2)

General Database Design


Design framework, mappings between abstractions, integrity, compromises, data vs functional design, non-functional considerations e.g. performance, volumes, user interface etc, security. (4)

Conceptual design


Requirement for conceptual design, Extended Entity Relationship model, object-oriented design, UML (6)

Logical design


The relational model, normalisation, relational algebra, SQL, the Oracle DBMS, mapping conceptual design to relational, integrity, views, embedded SQL, PL/SQL, triggers. (5)

Physical design


Clustering, indexes, performance considerations. (3)

Transactions


Concurrency techniques (locking, 2-phase locking, serialisability), recovery (rollback and commit, 2-phase commit), Transaction Processing Management Systems. (3)