Databases

Code:

EIC0023

Acronym:

BDAD

Keywords
Classification	Keyword
OFICIAL	Information Systems

Instance: 2010/2011 - 1S

Active?	Yes
Web Page:	http://moodle.fe.up.pt/1011/course/view.php?id=234
E-learning page:	http://moodle.fe.up.pt/
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	114	Syllabus since 2009/2010	3	-	6	56	162

Teaching language

Suitable for English-speaking students

Objectives

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

Upon completion of this unit students should be able to:
- design the UML class model
- map the UML class model into the relational model
- design a relational database in the Boyce-Codd normalized form
- implement a database using the SQL data definition language
- use relational algebra to query databases
- query relational databases using the SQL data manipulation language and a procedural language
- optimize queries using indexes
- guarantee an adequate access control
- use transactions and concurrency that ensure data integrity of a database
- explain the main features of a database management system
- explain how can we access a database in a client-server architecture
- explain the main characteristics of Data Warehouses

Program

1. UML class model
2. Entity/Relationship (E/R) model
3. relational model (RM), normalization and mapping UML and E/R to RM
4. SQL data definition language
5. Relational algebra as a query language
6. Data manipulation language SQL
7. Views and indexes
8. Access control
9. SQL in a server environment: the PL/SQL procedural language
10. Transactions, concurrency control and crash recovery
11. Data Warehouses

Mandatory literature

Jeffrey D. Ullman, Jennifer Widom; A First course in database systems. ISBN: 978-0-13-600-637-4

Complementary Bibliography

Raghu Ramakrishnan, Johannes Gehrke; Database management systems. ISBN: 0-07-116898-2

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 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
Attendance (estimated)	Participação presencial	56,00
Learning how to use the given database application	Trabalho laboratorial	16,00
Final exam	Exame	3,00
	Total:	-	0,00

Amount of time allocated to each course unit

Description	Type	Time (hours)	End date
Study along lectures period	Estudo autónomo	55
Study for the final exam	Estudo autónomo	32
	Total:	87,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 7,0 marks (in 20) in the distributed evaluation to be admitted to the final exam. The distributed evaluation will consist of 3 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,7*Exam + 0,3*Distributed evaluation

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

The distributed evaluation component consists of the average marks of the exercises.

Examinations or Special Assignments

The dates for the distributed evaluation (3 exercises) are:
1. October 11th-14th;
2. November 15th-18th;
3. December 13th-16th;
during the practical lectures.

Special assessment (TE, DA, ...)

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

Students in special circumstances that intend to discard the distributed evaluation should inform the the lecturers in the beginning of the semester. If they do not do it, they will be evaluated according to the "admission to exams" rules but without absence control.

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

Classification improvement

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

Observations

Optional teaching language: English.