Database and Web Applications Laboratory

Code:

L.EIC023

Acronym:

LBAW

Keywords
Classification	Keyword
OFICIAL	Informatics Engineering and Computing

Instance: 2024/2025 - 1S

Active?	Yes
Responsible unit:	Department of Informatics Engineering
Course/CS Responsible:	Bachelor in Informatics and Computing Engineering

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
L.EIC	354	Syllabus	3	-	6	52	162

Teaching language

Portuguese
Obs.: Suitable for English-speaking students.

Objectives

The LBAW course aims to consolidate the subjects covered in the Database and the Web Languages and Technologies courses. This course offers a practical perspective on two central areas of informatics engineering.

The goal of this course is to equip students with the ability to design and develop information systems based on web technologies and supported by relational database management systems.

Learning outcomes and competences

Upon completing this course, the student should be able to design and implement an information system based on web technologies and supported by a relational database management system. In particular, the student should be able to:

1. Specify the requirements;
2. Design the information architecture, user interfaces, and navigation flows;
3. Design the conceptual data model;
4. Obtain and validate the relational database's logical schema;
5. Obtain the physical database schema and optimize the relational logical schema;
6. Design and implement queries for database access in SQL;
7. Design and implement mechanisms to maintain data integrity;
8. Design and specify the web resources to support user interaction and business logic;
9. Implement the system's web components using server- and client-side web technologies;
10. Ensure that user interfaces comply with accessibility and web usability standards and best practices.

Working method

Presencial

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

Databases: data modeling in UML, Relational Model, SQL language.

Web Languages ​​and Technologies: HTTP protocol, REST paradigm, HTML, CSS and JavaScript languages.

Program

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


• Design of a relational database using data modeling languages (UML), SQL language, performance and search indexing, transactions, and procedural extensions to SQL;


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


• Design of a web application using programming languages and web frameworks, focused on the server side; deepening concepts related to the architecture of web applications;


• User interaction design: information architecture, web usability, and accessibility.

Mandatory literature

Ramakrishnan, Raghu; Database management systems. ISBN: 0-07-116898-2
Michal Zalewski; The tangled Web. ISBN: 978-1-59327-388-0

Complementary Bibliography

Jeffrey D. Ullman, Jennifer Widom; A First course in database systems. ISBN: 978-0-13-600-637-4
Russ Miles and Kim Hamilton; Learning UML 2.0. ISBN: 978-0-596-00982-3
Nielsen, Jakob; Designing web usability. ISBN: 1-56205-810-X

Teaching methods and learning activities

The theoretical classes will be used to present the work guidelines, discuss representative examples, analyze completed evaluations, and provide brief introductions to the technologies and concepts to be used.

The practical laboratory classes will be used for project development in groups, with the instructor acting as a consultant. In each practical class, the components produced by the group are evaluated and discussed.

Software

Laravel
Git
PostgreSQL
Docker
PHP

keywords

Physical sciences > Computer science > Informatics

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Designation	Weight (%)
Trabalho laboratorial	80,00
Exame	20,00
Total:	100,00

Amount of time allocated to each course unit

Designation	Time (hours)
Elaboração de projeto	110,00
Frequência das aulas	52,00
Total:	162,00

Eligibility for exams

The conditions for obtaining course attendance are as follows:

1. not exceeding the maximum number of absences in practical classes (25% of the total number of practical classes in the semester);
2. registering in a work group within the defined period;
3. participating in each of the four components of the project;
4. participating in the final presentation and defense of the project.

Participation in the project development (point 3) is assessed through the evidence produced by the student (code and documentation), the evaluation by instructors during practical classes, and self-assessment and peer evaluation conducted within the group.

Calculation formula of final grade

The final grade will be calculated using the following formula:

Final Grade = 20% Exam + 80% Project

where:

Project Grade = 10% ER + 25% EBD + 25% EAP + 40% PA

Project Components:

• ER – Requirements Specification
• EBD – Database Specification
• EAP – Architecture Specification and Vertical Prototype
• PA – Product and Presentation

The practical work is assessed during laboratory sessions and through the submission of the required components.

Theoretical concepts are assessed through an individual exam with multiple-choice questions.

Passing the course is conditional on obtaining 40% on the exam and 50% in each of the practical evaluation components.

Approval of the project requires each student to participate in all phases of the project, including the selection of technologies, the identification and characterization of the problem, the design and implementation of the solution, the writing of the final report, and the final presentation.

It is important to note that a student may receive a different grade from their group for a specific evaluation component if they have had less participation in that component.

The final grade for the practical component (Project Grade) may vary by up to 3 points for each member of the same group, based on the instructors' opinion and the self-assessment and peer evaluation conducted within the group.

The individual final grade depends on the exam grade and cannot exceed more than 5 points above the individual's exam grade.

Special assessment (TE, DA, ...)

The practical assessment carried out in the laboratory classes during the semester is required for all students, regardless of their enrollment status or the need to obtain course attendance evaluation.

Working students and equivalent groups exempt from attending classes must periodically present their work progress to the instructors, as agreed upon, and must present their work alongside regular students, as well as complete the theoretical and practical individual assessments as scheduled.

Given the laboratory nature of the course, it is not possible to perform an assessment in a single instance; therefore, the practical work evaluation cannot be replaced by an exam.

Classification improvement

It is not possible to improve the grade obtained for the project.

It is possible to improve the exam grade while maintaining the project grade from the previous enrollment.