Databases

Code:

EIC0023

Acronym:

BDAD

Keywords
Classification	Keyword
OFICIAL	Information Systems

Instance: 2009/2010 - 1S

Active?	Yes
Web Page:	http://moodle.fe.up.pt/0910/course/view.php?id=532
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	122	Syllabus since 2009/2010	3	-	6	56	162

Teaching language

Portuguese

Objectives

1. BACKGROUND
Database systems are fundamental in very many application domains, from online services to enterprise information systems. Thus, informatics engineers should have excellent skills in database modeling, querying and management.

2. SPECIFIC AIMS
The main objective of this course unit is to prepare students to design and develop database systems that meet the users' needs and organizational management goals.

3. PREVIOUS KNOWLEDGE
The course does not assume any prior knowledge of database technologies or other specific topics, however reasonable programming skills and basic knowledge of computer science theory will make the course more accessible.

4. PERCENTUAL DISTRIBUTION
Scientific component: 70%
Technological component: 30%

5. LEARNING OUTCOMES
Upon completion of this unit students should be able to:
- map the UML class model into the relational model
- use relational algebra to query databases
- design a relational database in the normalized form
- query relational databases in SQL and using a procedural language
- access a database through user interfaces
- use transactions and concurrency that ensure data integrity of a database
- explain the main features of a database management system

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 along with application examples.

Practical classes take place in a computer lab, using a database management system available in the market (Oracle, MySQL). During the classes practical exercises will be performed using an example database, and small developments will be carried out.

Software

Oracle 10G
Oracle SQL Developer

keywords

Physical sciences > Computer science > Database management

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Description	Type	Time (hours)	Weight (%)	End date
Attendance (estimated)	Participação presencial	52,00
Preparing for the final exam	Exame	35,00
Final exam	Exame	3,00
	Total:	-	0,00

Amount of time allocated to each course unit

Description	Type	Time (hours)	End date
Individual study	Estudo autónomo	60
Preparing for the exercises subject to evaluation	Estudo autónomo	12
	Total:	72,00

Eligibility for exams

To be eligible for the final exam, students cannot be absent in more than the allowed number of classes. Presence in class will be registered.

It is necessary to obtain a minimum of 6 marks (in 20) in the distributed evaluation to be admitted to the final exam. The distributed evaluation will consist of 4 exercises to be solved in the practical classes.

Students who qualified for the final exam in the previous edition of the course unit, may opt for the previous mark, but they should inform the professor at the beginning of term.

Calculation formula of final grade

Final mark = 0,6*Exam + 0,4*Distributed evaluation

To pass it is mandatory to have a minimum of 8 marks (in 20) in the final exam.

The distributed evaluation component consists of the average marks of the exercises, excluding the exercise with the lowest mark.

Special assessment (TE, DA, ...)

Students in special circumstances, who opt out of the distributed evaluation, will be assessed through a special exam.

Students belonging to student committees are subject to the general evaluation rules.

Classification improvement

It is possible to improve the final exam mark through a second exam of similar difficulty.

Improvement of the distributed evaluation mark can be performed in the next edition of this course unit.