Index: Contents | Bibliography | Evaluation

The Institutional page »


Credits: 7
Hours/Week: 2h lectures, 3h labs
Lectures: João Correia Lopes (JCL)


Give the students the competences to design and develop information repositories in the Web using Object-relational database management systems and scripting languages.


  1. Phases in the project of a database.
  2. Requirement analysis using UML.
  3. Obtaining the Conceptual Scheme using UML.
  4. Obtaining the Relational Logic Scheme.
  5. Validation of the Relational Scheme based on functional dependencies.
  6. Tuning the Relational Scheme and denormalisation.
  7. Obtaining the Physical Scheme and establishing of indices.
  8. Construction of questions in SQL.
  9. Establishing additional integrity rules and triggers.
  10. Identification of transactions.
  11. Using the PhP language and associated libraries.
  12. Constructing Web forms using JavaScript, CSS, XHTML.
  13. Verifying the usability and accessibility of the Web interfaces.

Main Bibliography

Other Bibliography

Teaching Procedures

The lectures will be used for the presentation of case studies and for its discussion. The laboratory classes will be used for the development of a group project.


Evaluation Type

Distributed evaluation without final exam.

Evaluation Components

DescriptionTypeTime (hours)Conclusion date
Teaching classes (estimated)Classes70
Report on Information Specification (REI)Work1810/03/2008
Report on Database Specification (REBD)Work2707/04/2008
Report on Architecture and Vertical Prototype (RA&P)Work3628/04/2008
Product and Demonstration (P&A)Work3602/06/2008
Individual Performance (DI)Work0

Frequency Attainment

Minimum required to pass this course: 40% in each practical assignment.

Final Classification

Classification = 10% REI + 20% REBD + 20% RA&P + 40% P&A + 10% DI

Special Works and Tests

There are no special works or tests.

Special Evaluation (Working Students, etc)

All students have the same evaluation.

Classification Improvement

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