F27WD - Web Design and Databases

Course leader(s):

Jeevani Goonetillake (Edinburgh, January)
David Robb (Edinburgh, January)
Md Azher Uddin (Dubai, January)
To be announced (Dubai, January)

Aims

To develop knowledge and understanding of fundamental web design concepts and combine these with database structuring and querying techniques applying this knowledge by implementing an easy-to-use website.

Syllabus

1. Web Design Overview and client-side scripting (1.1 Information Architecture, 1.2 User eXperience UX, 1.3 User Interface UI, 1.4 HTML, 1.5 CSS, 1.6 JavaScript)

2. Database Management System (2.1 Introduction to DBMS, 2.2 Conceptual Database Design with Entity Relationship Modelling., 2.3 Relational Model & Logical Database Design, 2.4 Physical Database Design, 2.5 SQL for Data Manipulation)

3. Server-side scripting (3.1 PHP, 3.2 Using PHP to interact with databases)

Learning outcomes

By the end of the course, students should be able to do the following:

design well-structured web pages to organize and format content
apply styling techniques to enhance the presentation and user experience of web pages
formulate interactive and engaging web interfaces using a scripting language
differentiate and apply data analysis and structuring techniques
construct database structures as a relational data model.
demonstrate database management techniques, including inserting, querying, and updating data
design server-side scripts for integrating databases into web applications
plan and construct web projects by collaborating with team members to gain practical experience

Further details

Curriculum explorer: Click here

SCQF Level: 7

Credits: 15