J. Correia Lopes


User Tools

Site Tools


LBAW 2017/2018

Master in Informatics and Computing Engineering
Database and Web Applications Laboratory
Instance: 2017/2018

Database and Web Applications Laboratory (Laboratório de Bases de Dados e Aplicações Web)

In this course, the students will learn how to design and develop web-based information systems backed by database management systems.

"Students are responsible for anything that transpires during a class. Therefore if you're not in a class, you should get notes from someone else (not the instructor)". David Maier

General Information

Assessment Details

Course Materials


Week Date Lecture (B002) Practical Assessment
1 05/02/2018 Introduction to Course. Project presentation. Actors and user stories. [Class] Working groups and project themes. Project presentation (A1). [Class]
2 12/02/2018 Actors and User stories (A2). [Class] A1
3 19/02/2018 Basics of Visual Design. [Class] User Interfaces Design (A3). [Class] A2
4 26/02/2018 Web Interaction Design. [Class] Implementation of the user interfaces (A3). [Class]
5 05/03/2018 Conceptual Data Model. Database specification. Relational Schema. Relational Schema validation. [Class] Conceptual Data Model (A4). [Class] A3
6 12/03/2018 Database tuning. Physical Schema. Indexes. PostgreSQL. [Class] Relational Schema, validation and schema refinement (A5). [Class] A4
7 19/03/2018 Integrity and security. Triggers. Transactions. User-defined functions. Frameworks Web. Laravel. [Class] Integrity constraints. Indexes, triggers and user functions. Database with data (A6). [Class] A5
8 26/03/2018 Easter Holidays. [Break]
9 02/04/2018 High-level architecture. Privileges. Web resources specification (A7). [Class] A6
10 09/04/2018 Web applications: history, architectural models and server-side web technologies. [Class] Vertical prototype (A8). [Class] A7
11 16/04/2018 Client web technologies and concepts: HTML5 APIs, Performance,​ Usability and Accessibility. [Class] Main accesses to the database (SQL). Transactions (A9). Product development (A10). [Class] A8, Minitest
12 23/04/2018 Information Retrieval. [Class] Product development (A10). [Class] A9
13 30/04/2018 Invited talk: Standardising Internal Development - Ricardo Canastro, Blip. [Class] Product development (A10). [Class]
14 07/05/2018 Queima das fitas. [Break]
15 14/05/2018 Invited talk: O ciclo de vida da infraestrutura do SIGARRA - Gil Silva, UPDigital. [Class] Product development (A10). [Class]
16 21/05/2018 Invited talk: A Plataforma TOConline, Software as a Service na Cloudware - Vitor Pinho e Eurico Inocêncio, Cloudware. [Class] Product development (A10). [Class]
17 28/05/2018 Product delivery (A10). Presentation and discussion (A11). [Schedule]

Recent changes

J. Correia Lopes, Sérgio Nunes

teach/lbaw/index.txt · Last modified: 18/06/2018 10:16 by Correia Lopes