Computer Science, Prifysgol Cymru Aberystwyth University of Wales

CSM7210 - Introduction to Database Systems Design

Brief Description

Aims, Objectives, Syllabus, Booklist

Further Details

Number of lectures

20

Number of seminars/tutorials

0

Number of practicals

4 x 1 hour

Coordinator

Dr. Edel Sherratt

Other staff involved

Not yet known

Pre-requisites

CSM0110

Co-requisites

None

Incompatibilities

This module is not available to undergraduate students

Assessment

Assessed coursework - 50%
Written exam - 50%

Timing

This module is offered only in Semester 1

• design and validate a database from a given enterprise description;
• implement a database design using Oracle;
• describe and use the facilities of a modern database system.

Relational Modelling - 8 Lectures

Entities and relationships. Connection traps. The design of relations. Transformation of E-R model into Relational Schema. Data normalisation. Validating a design.

Implementing a database using Oracle - 3 Lectures

Underlying file structures - 2 Lectures

Advanced SQL - 4 Lectures

Views and Indexes. Integrity constraints in Oracle. Built-in functions. Nested Queries and subqueries. Null values and the outer join. The role of the data dictionary. The data dictionary in ORACLE.

Interfaces and Tools - 3 Lectures

The Forms environment. SQL in applications programs. The Report Writer.

Students are likely to need ready access to the following

F.D. Rolland. Relational Database Management with ORACLE. Addison-Wesley, 1989.

A manual on the software system used in the course. To be advised.

S. Stanczyk. Theory and Practice of Relational Databases. Pitman, 1990.

J.G. Hughes. Database Technology, A Software Engineering Approach. Prentice-Hall, 1988.

C.J. Date. An Introduction to Database Systems. Addison-Wesley, 5th. edition, 1990.

Version 1.5

Nigel Hardy Departmental Advisor