Teaching Responsibility

LJMU Schools involved in Delivery:

LJMU Partner Taught

Learning Methods

Lecture

Module Offerings

4542NCCG-JAN-PAR
4542NCCG-SEP-PAR
4542NCCG-SEP_NS-PAR

Aims

The aim of this module is to give students opportunities to develop an understanding of the concepts and issues relating to database design and development, as well as to provide the practical skills to translate that understanding into the design and creation of complex databases.

Module Content

Outline Syllabus:The role of database systems Determining user and system requirements. Design tools and techniques for a relational database system. Logical design for relational databases Data integrity, data validation, data security and data controls. Overview of object-oriented databases and their design tools Software development options for developing the relational database system. Implementation of a physical data model based on the logical model. Data stores, internal storage and external storage. Implementation of security elements in databases. Relational database validation Data manipulation using appropriate query tools. Database maintenance and data manipulation System reports using report writing tools Testing against designs and user and system requirements. Functional and system testing Technical and user documentation.

Assessments

Competency
Report