Database Laboratory

Code:

EIC0030

Acronym:

LBDA

Keywords
Classification	Keyword
OFICIAL	Information Systems

Instance: 2006/2007 - 2S

Active?	Yes
Web Page:	http://www.fe.up.pt/~jlopes/teach/2006-07/LBD/
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	99	Syllabus since 2006/2007	3	-	7	-
		Plano de estudos de transição para 2006/07	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

Extended Entity-Relationship Model and Conceptual Schema.
Relational Model and Logical Schema.
Relational Algebra.
Normalisation theory.
Database tuning and Physical Schema.
SQL.
Integrity constraints and triggers.
PHP and related libraries.

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

Lectures include theoretical presentation of the course subjects and examples. Practical classes will be used to develop the project in group.

Software

PostgreSQL
PHP

keywords

Physical sciences > Computer science > Database management
Technological sciences > Technology > Internet technology
Technological sciences > Technology > Computer technology > Software technology

Evaluation Type

Distributed evaluation without final exam

Assessment Components

Description	Type	Time (hours)	Weight (%)	End date
Subject Classes	Participação presencial
Relatório de especificação da informação	Trabalho escrito
Relatório de especificação da base de dados	Trabalho escrito
Relatório de arquitectura	Trabalho escrito
Produto e apresentação	Trabalho escrito
Desempenho individual	Trabalho escrito
	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 evlauation.

Classification improvement

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