The aim of this module is to introduce the student to Web and Database Architecture, Design and Technologies. The module includes client side web languages and server side web languages. The student will learn how model, design and implement a database as well as integrate both server and client sides with the database.
Web Architectures
Client server model - Limitations of client server architectures - 3 Tier and N Tier architectures - Scalability - Peer-to-peer models
Client Side Programming
HTML 5 - CSS - JavaScript - jQuery
Server Side Programming
Overview: CGI, Perl, ASP, JSP, PHP Web server language support - data-types and data processing Web browser languages. Introduction to PHP scripting
Data Serialization Formats
XML - JSON, JSON Syntax, JSON encoding/decoding - YAML
Overview of Database Systems
File based systems - What is a database - Types of Database Systems: Hierarchical, Object Oriented, Relational, Network - Database Management Systems (DBMS) - Embedded Databases - Emerging trends: Managing Data in the Cloud, Databases for Mobile Systems
Data Modelling
A logical view of data: entities/attributes, Relations and their characteristics, Entity relationship modelling, Connectivity and cardinality, Relationship strength and participation, Weak entities - Development of an ER diagram -Table normalisation 1NF, 2NF, 3NF BCNF, Higher level normal forms, De-normalization.
Relational Database Design
Implementing the data model - Stages in Database Design - Introduction to DBMS: MySQL, Postgres, Access, SQLite - Relational Algebra - Introduction to SQL: Data manipulation commands, Queries, Partial listing and logical operators, Advanced data management commands
Database Connectivity
Server side connectivity ODBC, ADODB, JDBC MySQL, SQL Server Inserting data into a database Capturing and displaying data from a database
The module will be delivered through a series of lectures and lab sessions with student self-directed learning including assessment activities.
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Formal Examination | 50 |
| Other Assessment(s) | 50 |