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