Course image COMS501_S2_A_21: Web Application Development
Business School
Module Code: COMS501
Academic year: 21
Semester: S2
Occurrence: A
Level: L5
Location: BR

This module is an introductory module for students with little or no knowledge of websites. It aims to introduce students to the principles of HTML, CSS, PHP and effective design, providing opportunity for practical work, which will involve analysing and improving a current web site. 


Course image COMS404_S1_A_21: Database Systems
Business School
Module Code: COMS404
Academic year: 21
Semester: S1
Occurrence: A
Level: L4
Location: BO

The module focuses on the relational databases. It introduces database software, design, creation, management and programming. It starts with conceptual entity-relationship design, followed by logical database design and physical database creation.

Students will learn:

·       to design and implement a relational database via a number of interfaces such as the bash terminalphpMyAdmin and mySQL Workbench.

·       to implement the principles of ‘CRUD’ (Create Retrieve, Update, Delete) via Structured Query Language (SQL).

·       the concept of normalisation, what ‘normal forms’ are, and how this reduces or eliminates redundancy and duplication.

·       to write stored procedures, transactions and triggers and how to access databases via various third party application and programs.

User permissions will be covered as will some performance tuning via query monitoring and optimisation.