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