Teaching Responsibility

LJMU Schools involved in Delivery:

LJMU Partner Taught

Learning Methods

Lecture
Practical

Module Offerings

4604YCOM-JAN-PAR

Aims

To introduce the fundamentals of data manipulation and presentation. To model and manipulate data using spreadsheet and database based applications. To evaluate the advantages and disadvantages of spreadsheet and database based development models.

Learning Outcomes

1.
Construct spreadsheet based applications from a given set of requirements.
2.
Create logical and physical entity relationship models from a given set of requirements.
3.
Construct database based applications from logical and physical entity relationship models.

Module Content

Outline Syllabus:Data Domains, Models & Abstraction Spreadsheet Modelling Design, Manipulation & Reporting Limitations Logical Data Modelling Entities Relationships, Cardinality & Optionality Physical Data Modelling Tables Attributes Relationships Functional Dependency & Normalisation 1NF - 2NF - 3NF Database Modelling Designers & Query-By-Example
Additional Information:This module delivers to students the ability to model and manipulate data in various differing scenarios. Student will be required to construct and manipulate data in spreadsheet based applications, then to model data using various data modelling techniques leading towards the construction and manipulation of database based applications.

Assessments

Report