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

Current postgraduate taught students

COMP67340: Database Systems (2007-2008)

This is an archived syllabus from 2007-2008

Database Systems
Level: 6
Credit rating: 15
Pre-requisites: No Pre-requisites
Co-requisites: No Co-requisites
Lecturers: John Keane, Goran Nenadic
Course lecturers: John Keane

Goran Nenadic

Additional staff: view all staff
Timetable
SemesterEventLocationDayTimeGroup
Sem 2 w19-23,25,29-32 Lecture 2.15 Wed 09:00 - 13:00 -
Assessment Breakdown
Exam: 80%
Coursework: 20%
Lab: 0%

Aims

Students should learn about the role of databases in organisations and gain practical experience of designing and implementing a simple database according to the relational model. The underpinnings of relational technology (relational model, relational algebra and database design theory) will be studied together with the analysis of its limitations which led to the development of Object Oriented and Object Relational approaches to databases. An understanding of current and likely future developments in database technology should also be gained.

Learning Outcomes


A student completing this course unit should:
understand the role, importance and impact of information management and be able to use data management techniques to address business issues (A,B).
understand data modelling techniques, including ER modelling language (A, B).
understand the principles of the relational data model and relational algebra (A).
be familiar with database design and implementation, including development of database schemas (conceptual and logical) (B, C).
learn SQL and understand the mappings from SQL to relational algebra, and be able to use both as query languages (A, C).
learn basic principles of object-oriented and object-relational database management systems (A).
understand database technology trends (A).
be familiar with DBMS and DB design software (C, D)
develop report writing skills and work effectively as a team member (D).

Assessment of Learning Outcomes


Learning outcomes (1)-(5) are assessed by examination and coursework; learning outcomes (6)-(7) are assessed by examination; learning outcomes (8)-(9) are assessed by coursework.

Contribution to programme learning


A1, A2, B2, B3, C1, C2, D1, D3, D5.

Syllabus

Introduction to databases and information management in organisations.
Database design using the ER model;
Relational model and mapping ER to relational; Relational algebra and views;
Database manipulation, retrieval and programming;
Structured Query Language (SQL);
Database design techniques and normalisation;
Transaction processing, distribution, concurrency and recovery;
Objects and DBMS technology, object- and object-relational databases;
DBMS technology trends.

Reading List

Core Text
Title: Database Systems: A Practical Approach to Design, Implementation, and Management
Author: T. Connolly, C. Begg
ISBN:
Publisher: 4th Edition, Pearson Education (Addison Wesley),
Edition:
Year: 2005


Core Text
Title: Fundamentals of database systems (5th edition)
Author: Elmasri, Ramez and Shamkanth B. Navathe
ISBN: 032141506X
Publisher: Pearson
Edition: 5th
Year: 2007


Core Text
Title: Database System Concepts, 4th ed
Author: Sliberschatz, A., Korth, H.F., Sudarshan, S.
ISBN:
Publisher: McGraw Hill
Edition:
Year: 2002


Title: Database System Concepts
Author: Silberschatz, A., Kroth, H.F., Sudarshan, S.
ISBN:
Publisher: 5th Edition, McGraw Hill
Edition:
Year: 2005


Title: Data Management: Databases and Organisations
Author: Watson
ISBN: 0-471-41845-5
Publisher: 3rd Edition, Wiley
Edition:
Year: 2002


Title: Database systems: the complete book (2nd edition)
Author: Garcia-Molina, Hector and Jeffrey D. Ullman and Jennifer Widom
ISBN: 9780131354289
Publisher: Pearson
Edition: 2nd
Year: 2009


Title: Fundamentals of database systems (5th edition)
Author: Elmasri, Ramez and Shamkanth B. Navathe
ISBN: 032141506X
Publisher: Pearson
Edition: 5th
Year: 2007


Supplementary Text
Title: Data Management: Databases and Organisations
Author: Watson
ISBN: 0-471-41845-5
Publisher: 3rd Edition, Wiley
Edition:
Year: 2002


Supplementary Text
Title: Database systems: the complete book (2nd edition)
Author: Garcia-Molina, Hector and Jeffrey D. Ullman and Jennifer Widom
ISBN: 9780131354289
Publisher: Pearson
Edition: 2nd
Year: 2009