Database Laboratory
Keywords |
Classification |
Keyword |
OFICIAL |
Information Systems |
Instance: 2007/2008 - 2S
Cycles of Study/Courses
Teaching language
Portuguese
Objectives
Give the students the competences to design and develop information repositories in the Web using Object-relational database management systems.
Program
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.
Mandatory literature
R. Ramakrishnan, J. Gehrke; Database Management Systems, McGRAW-Hill International Editions, 2002. ISBN: 0-07-246563-8
Complementary Bibliography
Alberto Rodrigues da Silva, Carlos Videira; UML — Metodologias e Ferramentas CASE, Centro Atlântico Editora, 2005. ISBN: 989-615-009-5
Nielsen, Jakob;
Designing web usability. ISBN: 1-56205-810-X
Jeffrey D. Ullman, Jennifer Widom; A First Course in Database Systems, Prentice-Hall, 2001. ISBN: 0-13-035300-0
Teaching methods and learning activities
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
PHP
PostgreSQL
keywords
Technological sciences > Technology > Computer technology > Software technology
Physical sciences > Computer science > Database management
Technological sciences > Technology > Internet technology
Evaluation Type
Distributed evaluation without final exam
Assessment Components
Description |
Type |
Time (hours) |
Weight (%) |
End date |
Subject Classes |
Participação presencial |
70,00 |
|
|
Report on Information Specification (REI) |
Trabalho escrito |
18,00 |
|
2008-03-10 |
Report on Database Specification (REBD) |
Trabalho escrito |
27,00 |
|
2008-04-07 |
Report on Architecture and Vertical Prototype (RA&P) |
Trabalho escrito |
36,00 |
|
2008-04-28 |
Product and Demonstration (P&A) |
Trabalho escrito |
36,00 |
|
2008-06-02 |
Individual Performance (DI) |
Trabalho escrito |
0,00 |
|
2008-06-02 |
|
Total: |
- |
0,00 |
|
Eligibility for exams
Minimum required to pass this course: 40% in each practical assignment.
Calculation formula of final grade
10% REI + 15% REBD + 15% RA + 50% P&A + 10% DI
Examinations or Special Assignments
There are no special works or tests.
Special assessment (TE, DA, ...)
All students have the same evaluation.
Classification improvement
Students may improve the mark in the subject's next edition.