F27WX Web Design and Databases (GA)

Dr Santiago Chumbe

Course co-ordinator(s): Dr Santiago Chumbe (Edinburgh).

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.

Detailed Information

Course Description: Link to Official Course Descriptor.

Pre-requisites: none.

Location: Edinburgh.

Semester: AY.

Syllabus:

  • Introduction to web development.
  • Information architecture.
  • Web design and usability.
  • Fundamentals of Mark-up and CSS.
  • Introduction to database systems.
  • Databases and Information Systems.
  • Modelling of data/entity-relationship modelling.
  • The relational data model.
  • The Structured Query Language (SQL).
  • Web-based database applications including the use of PHP.

Learning Outcomes: Subject Mastery

  • To explain fundamental web design concepts including usability.
  • To implement a simple web site which satisfies current standards and uses a database.
  • To describe the use of CSS and mark-up within a web site and the advantage this gives the developer.
  • To describe the need for standard XHTML and how this aids cross browser compatibility.
  • To have knowledge and understanding of data analysis and structuring techniques.
  • To design database structures as a relational data model.
  • To implement and query a designed database structure through a web site.

Learning Outcomes: Personal Abilities

  • To analyse complex information and organise it in a structured way for a web site.
  • To understand stakeholders’ requirements and address them.
  • To design a web site that is easy and cost efficient to manage.
  • To analyse data sources and represent them in an efficient structured form.
  • Problem solving (PDP).
  • Paired work (PDP).
  • Time management (PDP).
  • To be able to relate learned knowledge to a work-based environment
  • Reflection, constructive criticism and learning from peers (PDP).

Assessment Methods: Due to covid, assessment methods for Academic Year 2020-21 may vary from those noted on the official course descriptor. Please see the Computer Science Course Weightings and the Maths Course Weightings for 2020-21 Semester 1 assessment methods.

SCQF Level: 7.

Credits: 15.