Course Information Undergraduate prospectus

Database Engineering

Course summary

Course code: COMP1639
Level: 6
Credits: 15
School: Architecture, Computing and Hums
Department: Computing and Information Sys.
Course Coordinator(s): Andrew Wicks

Specification

Aims

The aims of this course are to introduce database concepts and the use of relational database systems. This module by contrast emphasises implementation issues of relational database systems, and provides an insight into some of the recent developments in database technology.

Learning outcomes

On completing this course successfully you will be able to:
A. Critically evaluate the concepts and tools of the relational database management system.
B. Investigate and analyse the data requirements for a database system design.
C. Manipulate data and database objects through the use of SQL.
D. Design and build a database management system that satisfies relational theory and provides users with business queries, business forms, and business reports.

Indicative content

Basic relational database concepts; Use normalisation to design database tables; Reporting and querying data; Restricting, sorting, and grouping data; Understanding Oracle database functions; Transactional processing; Creating database objects; Server side coding: stored procedures and functions, database triggers; Error processing and troubleshooting; Main concepts of building user interface using APEX.

Teaching and learning activity

Each week there will be a 2 hour lecture and a 1 hour practical session. In the lecture students will be introduced to the issues affecting the design, development and management of the database. In the lab sessions students will learn how to design and develop a database driven application.

Learning Time (1 credit = 10 hours)

Scheduled contact hours:

Note: include in scheduled time: project supervision, demonstrations, practical classes and workshops, supervised time in studio or workshop, scheduled lab work , fieldwork, external visits.
Lectures 22;
seminars 0;
supervised practical sessions 11;
tutorials 11;
formative assessment 0;
other scheduled time 0.
Guided independent study:
Note: include in guided independent study preparation for scheduled sessions, follow up work, wider reading or practice, revision.
Independent coursework 36;
Independent laboratory work 70;
other non-scheduled time 0;
Placements & year abroad:
Work placements 0;
Work based learning 0;
Year abroad 0;
Other placement 0;
Total hours (Should be equal to credit x 10) 150.

Assessment

Practical coursework: 50% weighting. Pass mark 40%.
Practical exercise to develop an enterprise database to a given specification

Exam: 50% weighting. Pass mark 40%.
n/a
Formal exam assessing the theoretical aspects of database engineering.