Database Laboratory

Code:

EIC0030

Acronym:

LBDA

Keywords
Classification	Keyword
OFICIAL	Information Systems

Instance: 2007/2008 - 2S

Active?	Yes
Web Page:	http://www.fe.up.pt/~jlopes/teach/2007-08/LBDA/
Responsible unit:	Informatics Section
Course/CS Responsible:	Master 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
LEIC	0	Plano de estudos de transição para 2006/07	3	7	7	-
MIEIC	92	Syllabus since 2006/2007	3	-	7	-

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.