Teaching Responsibility
LJMU Schools involved in Delivery:
LJMU Partner Taught
Learning Methods
Lecture
Practical
Tutorial
Module Offerings
4605TECYPC-JAN-PAR
Aims
To provide the student with a thorough grounding in the design, build and querying of databases.
Learning Outcomes
1.
Discuss the relationships and apply normalization when constructing databases
2.
Construct SQL statements
3.
Design forms by using Microsoft Access both with and without wizards
4.
Create queries in both native Access and SQL syntax
5.
Produce meaningful reports in various formats and demonstrate how to link to other applications
Module Content
Outline Syllabus:Introduction to Databases Management System
Database Administrative Tasks and Multi-user Environment
Normalization
Data Modelling
Database Application (MS Access)
Structured Query Language (SQL) and Set Theory
Additional Information:This module prepares the students with the essential skills of database development such as data modelling and normalization. Students will also be provided with the knowledge and skills to create a simple database application through the use of MS Access. A hands-on approach will give the students a chance to try out different approaches and methods for creating database. The students should be able to transfer the skills learnt in this module to other modules on their degree including their final year project.