Database and Web Applications Laboratory

Code:

L.EIC023

Acronym:

LBAW

Keywords
Classification	Keyword
OFICIAL	Informatics Engineering and Computing

Instance: 2023/2024 - 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	383	Syllabus	3	-	6	52	162

Teaching language

Portuguese
Obs.: Suitable for English-speaking students.

Objectives

The LBAW curricular unit aims to consolidate the subjects exposed in the curricular units of databases and web languages ​​and technologies. This curricular unit offers a practical perspective on two central areas of computer engineering.

This course unit is intended to provide students with the ability to design and develop information systems accessible through the web and supported by database management systems.

Learning outcomes and competences

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

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

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, modelling, implementation and documentation;


• Deepening of concepts and development of web application architecture. Use of client- and server-based programming languages ​​and web frameworks;


• Relational database design using data modeling languages ​​(UML), the SQL language, the use of performance and search indexes, and procedural extensions to the SQL language;


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


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

Mandatory literature

Ramakrishnan, Raghu; Database management systems. ISBN: 0-07-116898-2

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
Michal Zalewski; The tangled Web. ISBN: 978-1-59327-388-0
Nielsen, Jakob; Designing web usability. ISBN: 1-56205-810-X

Teaching methods and learning activities

Theoretical classes will be used to present the work scripts, to discuss representative examples, to analyze the evaluations carried out and to present brief introductions to the technologies and concepts to be used.

The practical classes will be used for the laboratory development of the project, in groups, with the teacher 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 without final exam

Assessment Components

Designation	Weight (%)
Teste	20,00
Trabalho laboratorial	80,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

There are two conditions for obtaining frequency. The student:

• (1) cannot exceed the limit number of absences (25% of the number of practical classes); and
• (2) must score 50% or more in the project.

Calculation formula of final grade

The grade is calculated using the formula:

Grade: 20% NI + 80% NP

where:

NP = 10% ER + 25% EBD + 25% EAP + 40% PA

Caption:

• NI – Individual test grade
• NP – Practical work grade
• ER – Requirements Specification
• EBD – Database Specification
• EAP – Architecture Specification and Vertical Prototype
• PA – Product and Presentation

The practical work is evaluated during the laboratory classes and through the delivery of the planned components.

Theoretical concepts are assessed by an individual test with multiple choice questions.

Approval in the curricular unit is subject to obtaining 40% in the individual test and 50% in each of the components of the practical assessment.

Obtaining approval in the project requires the participation of each student in all phases of the project, namely in the selection of technologies, in identifying and characterizing the problem, in designing and implementing the solution, in writing the final report, and in the final presentation.

It should be noted that a student, due to having a smaller participation in an assessment component, may have a different classification in that component than the group to which he belongs.

The final classification of the practical component (NP) may vary from element to element of the same group, in more or less 3 values, based on the opinion of the professors and on the self-assessment and hetero-assessment to be carried out internally in each group.

The final individual classification depends on the classification obtained in the individual test, and cannot exceed up to 5 values of the individual classification obtained in the test.

Examinations or Special Assignments

There are no special works or tests.

Special assessment (TE, DA, ...)

The practical assessment carried out in laboratory classes during the semester of operation of the curricular unit is required for all students, regardless of the enrollment regime and the need to obtain a frequency assessment.

Student workers and equivalents released from class attendance must, at intervals to be agreed with the teachers, present the progress of their work, as well as present them, simultaneously with ordinary students, and carry out the theoretical and practical individual assessments.

Given the laboratory nature of the curricular unit, it is not possible to carry out an assessment in a single moment and, therefore, the assessment of practical work cannot be replaced by an exam.

Classification improvement

The individual test can be improved in the same occurrence of the curricular unit.

The project is not subject to improvement. The improvement of this component can be achieved through the development of a new project in a new enrollment to the curricular unit.