Go to:
You are here: Start > EBE0235

Database and Web Applications Laboratory

Code: EBE0235     Acronym: LBDAW

Classification Keyword
OFICIAL Biomedical Engineering

Instance: 2020/2021 - 2S Ícone do Moodle

Active? Yes
Web Page: https://web.fe.up.pt/~jlopes/doku.php/teach/lbaw/index
Responsible unit: Department of Informatics Engineering
Course/CS Responsible: Master in Bioengineering

Cycles of Study/Courses

Acronym No. of Students Study Plan Curricular Years Credits UCN Credits ECTS Contact hours Total Time
MIB 2 Syllabus 4 - 6 70 162

Teaching Staff - Responsibilities

Teacher Responsibility
Sérgio Sobral Nunes
João António Correia Lopes

Teaching - Hours

Lectures: 2,00
Laboratory Practice: 3,00
Type Teacher Classes Hour
Lectures Totals 1 2,00
Sérgio Sobral Nunes 1,00
João António Correia Lopes 1,00
Laboratory Practice Totals 1 3,00
Sérgio Sobral Nunes 3,00

Teaching language

Obs.: Suitable for English-speaking students.



The unit aims at revisit the learning outcome of the previous courses in databases and web languages ​and technologies, providing a practical perspective on these core areas​ of computer engineering.


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

Learning outcomes and competences

After completing this course, the student will be able to:

  1. Specify the requirements of the information system;

  2. Obtain the conceptual model of the information system's data;

  3. Obtain and validate the logical relational database schema of the system's database;

  4. Obtain the physical schema of the database and tune the logical relational schema;

  5. Design and implement queries to access the database using SQL;

  6. Design and implement mechanisms for maintaining the integrity of the data;

  7. Specify the web interfaces and business logic of the information system;

  8. Implement the web components of the system using web-based, server-based and client-based technologies;

  9. Ensure that the web interfaces are in accordance with accessibility and usabil

Working method


Pre-requirements (prior knowledge) and co-requirements (common knowledge)

  • Databases: data modeling with UML, relational model, SQL language.

  • Web languages ​​and technologies: HTTP protocol, HTML, CSS and JavaScript languages.


  • Development of a web application supported by a database: requirements gathering, design, modelling, implementation and documentation.

  • General notions on the architecture of web applications using client scripting languages and server languages.

  • Use of frameworks and API for data access.

  • Design of relational databases using data modelling languages (UML), the SQL language and procedural extensions to SQL.

  • Identification and maintenance of business rules: on the interface, on the business logic and in the database (triggers); define transactions.

  • General notions of usability and Web Design.

Mandatory literature

Raghu Ramakrishnan; Database Management Systems. ISBN: 0-07-115508-2

Complementary Bibliography

Jeffrey D. Ullman; A First course in database systems. ISBN: 978-0-13-600-637-4
Scott W. Ambler; The object primer. ISBN: 978-0-521-54018-6
Michal Zalewski; The tangled Web. ISBN: 978-1-59327-388-0
Jakob Nielsen; Designing web usability. ISBN: 1-56205-810-X

Teaching methods and learning activities

The lectures will be used for presentation of the scripts of the work and representative examples and their discussion, analysis of assessments and brief introductions to the technologies they use. The practical classes will be used for laboratory project development as a group project with the teacher as a consultant.




Physical sciences > Computer science > Informatics

Evaluation Type

Distributed evaluation without final exam

Assessment Components

Designation Weight (%)
Participação presencial 80,00
Teste 20,00
Total: 100,00

Amount of time allocated to each course unit

Designation Time (hours)
Elaboração de projeto 122,00
Frequência das aulas 70,00
Total: 192,00

Eligibility for exams

The practical work will be assessed during the laboratory classes, through the delivery of the artefacts.

The theoretical concepts are evaluated using an individual questionnaire with multiple choice questions.

The approval for the course is conditional on the student obtaining 40% in the individual response questionnaire and 50% in each of the components of the practical assessment.

A student that does not participate in an evaluation component may have an assessment to that component different from the group to which he belongs.

Given the laboratory nature of the course and the work in teams, it is not possible to make an overall evaluation based on a single moment and therefore the practical work can not be replaced by a single exam.

Calculation formula of final grade

Classification = 20% NI + 80% NP

Being NP = 20% ER + 20% EBD + 20% EAP + 40% PA

NI - Individual multiple choice questionnaire
NP - Practical work
ER - Requirements Specification
EBD - Database Specification
EAP - Architecture Specification and Vertical Prototype
PA - Product and Presentation

The final classification of the practical component (NP) can vary from element to element in the same group, plus or minus 2 values​​, based on the opinion of the teachers and the self-assessment performed by each group.

Examinations or Special Assignments

There are no special works or tests.

Special assessment (TE, DA, ...)

The project evaluation, conducted in a group, is the same for all students regardless of the enrolment regime.

Students exempted from classes must agree to conduct regular meetings with teachers to keep up with the practical work. Regarding the final presentation and the individual assessments, the rules are the same as for the regular students.

Classification improvement

Students may improve the mark in the course's next edition.


Changes due to the COVID-19 pandemic

The mini-test scheduled for the week of 27/April was rescheduled for the period from 15/Jun to 24/Jul. The in-person model will be maintained with the test being done using Moodle.

The minimum grade for each component was changed from 50% to 40% (8 points).

The mini-test score obtained in the previous year (occurrence 18/19) can be used in this edition.
Recommend this page Top
Copyright 1996-2023 © Faculdade de Engenharia da Universidade do Porto  I Terms and Conditions  I Accessibility  I Index A-Z  I Guest Book
Page generated on: 2023-11-30 at 02:45:02 | Acceptable Use Policy | Data Protection Policy | Complaint Portal