Databases

Code:

EIC0023

Acronym:

BDAD

Keywords
Classification	Keyword
OFICIAL	Information Systems

Instance: 2011/2012 - 2S

Active?	Yes
Web Page:	https://moodle.fe.up.pt/1112/course/view.php?id=2998
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	168	Syllabus since 2009/2010	2	-	6	56	162

Teaching language

Portuguese

Objectives

1- BACKGROUND
Information Systems (IS) is a key topic in informatics engineering. Databases are the data repository that is required in any IS. The database course is a key course in the area of IS.
The main objective of this course unit is to prepare students to design and develop database systems that meet the users' needs according to the organizational management goals.
2- SPECIFIC AIMS
This is an introductory course on databases. It is focused on the relational paradigm. It covers the design (UML model), construction (SQL data definition language), querying (SQL data manipulation language and PL/SQL) and management (optimization, access control and concurrency policies).
3- PREVIOUS KNOWLEDGE
Basic knowledge on procedimental programming languages and on algebra.
4- PERCENT DISTRIBUTION
Scientific component:50%
Technological component:50%
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. UML class diagram
2. The Entity-Relationship model
3. Relational model and normalization
4. SQL Data Definition Language and Integrity constraints
5. Relational Algebra
6. SQL Data Manipulation Language
7. View and indexes
8. Query optimization
9. SQL and the client-server architecture: the PL/SQL language
10. Access control
11. Transactions, concurrency and recovery
12. Data Warehousing

Mandatory literature

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

Complementary Bibliography

Raghu Ramakrishnan, Johannes Gehrke; Database management systems. ISBN: 0-07-116898-2
Ralph Kimball, Margy Ross; The data warehouse toolkit. ISBN: 0-471-20024-7

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 11g

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	48,00
Learning the applications used	Trabalho laboratorial	20,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	60
Study for final exam	Estudo autónomo	32
	Total:	92,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 marks (in 20) in the distributed evaluation to be admitted to the final exam. The distributed evaluation will consist of 3 tests.

Students who qualified for the final exam in the previous edition of the course unit, will keep the previous mark, except if they participate in any component of the distributed evaluation.

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 marks (in 20) in the final exam.

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

Special assessment (TE, DA, ...)

Students in special circumstances, who opt out of the distributed evaluation, will be assessed through a special exam. In these cases, the final classification is the classification obtained in the exam. The referred students should inform the professor about their intention. If they do not, they will be evaluated through the general rules for admission to exams. In this case the final grade is obtained as usual.

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.

The classification obtained will contribute 100% for the final classification. The distributes evaluation is, consequently, ignored.