Teaching Responsibility

LJMU Schools involved in Delivery:

LJMU Partner Taught

Learning Methods

Online
Practical

Module Offerings

4503SDLBHG-JAN-PAR

Aims

To introduce the fundamentals of manipulating and presenting data. To manipulate and present data using spreadsheet and database based applications. To evaluate the advantages and disadvantages of spreadsheet and database based applications.

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 Dev. Manipulating & Presenting Data Pivot Tables & Charts Limitations Logical Data Modelling Entities, Attributes & Keys Relationships (Cardinality & Optionality) Physical Data Modelling Tables Columns Data Types Keys Nullability Functional Dependency & Normalisation 1NF - 2NF - 3NF Database Dev. Designers & Query-By-Example
Additional Information:The module imparts upon students the ability to model data in various differing scenarios. Students are initially required to manipulate and present data in spreadsheet based applications. The students are then required to solve problems using a data modelling methodology (e.g. entity relationship models / normalisation), ultimately leading towards the construction of database based applications.

Assessments

Artefacts