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