Introduction
Year: 3º
Semester: 2º
Credits: 7
ECTS: 7
Hours/Week: 2h lectures, 3h labs
Lectures:
João Correia Lopes (JCL)
Aims
Give the students the competences to design and develop information repositories in the Web using Object-relational database management systems and scripting languages.
Contents
- Phases in the project of a database.
- Requirement analysis using UML.
- Obtaining the Conceptual Scheme using UML.
- Obtaining the Relational Logic Scheme.
- Validation of the Relational Scheme based on functional dependencies.
- Tuning the Relational Scheme and denormalisation.
- Obtaining the Physical Scheme and establishing of indices.
- Construction of questions in SQL.
- Establishing additional integrity rules and triggers.
- Identification of transactions.
- Using the PhP language and associated libraries.
- Constructing Web forms using JavaScript, CSS, XHTML.
- Verifying the usability and accessibility of the Web interfaces.
Main Bibliography
- R. Ramakrishnan, J. Gehrke, Database Management Systems, McGRAW-Hill International Editions, 3rd Edition, 2002, ISBN=0-07-246563-8
Other Bibliography
- Jeffrey D. Ullman, Jennifer Widom, A First Course in Database Systems, Prentice-Hall, 2nd Edition, 2001, ISBN=0-13-035300-0
- Alberto Rodrigues da Silva, Carlos Videira, UML — Metodologias e Ferramentas CASE, 2ª Edição, Volume 1, Maio 2005, Centro Atlântico Editora, ISBN: 989-615-009-5
- Jakob Nielsen, Designing Web Usability: The Practice of Simplicity, New Riders Publishing, Indianapolis, 2000, ISBN=1-56205-810-X
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.
Software
- PostgreSQL
- PHP
- Smarty Library
- PEAR-DB Library
- Visio or Dia
Evaluation Type
Distributed evaluation without final exam.
Evaluation Components
| Description | Type | Time (hours) | Conclusion date |
|---|---|---|---|
| Teaching classes (estimated) | Classes | 70 | — |
| Report on Information Specification (REI) | Work | 18 | 10/03/2008 |
| Report on Database Specification (REBD) | Work | 27 | 07/04/2008 |
| Report on Architecture and Vertical Prototype (RA&P) | Work | 36 | 28/04/2008 |
| Product and Demonstration (P&A) | Work | 36 | 02/06/2008 |
| Individual Performance (DI) | Work | 0 | — |
| Total | 187 | — |
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% DISpecial 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.