Databases

Code:

EIC0023

Acronym:

BDAD

Keywords
Classification	Keyword
OFICIAL	Information Systems

Instance: 2008/2009 - 1S

Active?	Yes
Responsible unit:	Department of Informatics Engineering
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
MIEIC	110	Syllabus since 2006/2007	3	-	6	56	162

Teaching language

Portuguese

Objectives

The subject main goal is to prepare the student to design and develop database systems that meet the user needs and the organizational management objectives.

Program

1. Review the relational data model
2. Mapping UML to the relational model
3. Relational algebra as a query language
4. Query language SQL
5. Building applications and using procedural languages (PL/SQL, PHP)
6. Interface development
7. Access control
8. Object-relational data model
9. SQL3 extensions
10. Transactions, concurrency
11. Internal model: storing structures, indices.

Mandatory literature

Ullman, Jeffrey D; A First Course in Database Systems. ISBN: 0-13-861337-0

Complementary Bibliography

Silberschatz, Abraham; Database system concepts. ISBN: 0-07-228363-7
Garcia-Molina, Hector; Database system implementation. ISBN: 0-13-040264-8

Teaching methods and learning activities

Theoretical lectures are used to present the subject topics e for application examples.

Practical classes take place in computer labs, using a database management system available in the market (Oracle, MySQL). During the classes practical exercices against an example database will be performed, as well as small developments.

Software

Oracle SQL Developer
Oracle 10G

keywords

Physical sciences > Computer science > Database management

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Description	Type	Time (hours)	Weight (%)	End date
Subject Classes	Participação presencial	52,00
Final exam	Exame	3,00
Relational algebra exercise	Exame	1,00		2008-10-06
SQL exercise	Exame	1,00		2008-10-20
Normalization exercise	Exame	1,00		2008-11-03
PL/SQL in the Web exercise	Exame	1,00		2008-11-17
Concurrency and indexes exercise	Exame	1,00		2008-12-08
	Total:	-	0,00

Amount of time allocated to each course unit

Description	Type	Time (hours)	End date
Self study	Estudo autónomo	52
	Total:	52,00

Eligibility for exams

A minimum of 6/20 in the distributed assessment is required. Such assessment is essentially determined by the marks of 5 exercises to be performed in class, every other week.

Calculation formula of final grade

Mark = 0,6 Exam + 0,4 Distributed evaluation

Special assessment (TE, DA, ...)

Follows the general rules.

Classification improvement

It is possible to improve the final exam classification through a second chance exam.