Databases

Code:

EIC0023

Acronym:

BDAD

Keywords
Classification	Keyword
OFICIAL	Information Systems

Instance: 2015/2016 - 2S

Active?	Yes
E-learning page:	https://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

Suitable for English-speaking students

Objectives

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.

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).

PERCENT DISTRIBUTION

Scientific component:50% Technological component:50% 

Learning outcomes and competences

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

Working method

Presencial

Pre-requirements (prior knowledge) and co-requirements (common knowledge)

PRE REQUISITES

Basic knowledge on procedimental programming languages and on algebra.

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

SQLite

keywords

Physical sciences > Computer science > Database management

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Designation	Weight (%)
Exame	70,00
Participação presencial	0,00
Trabalho escrito	7,50
Trabalho laboratorial	22,50
Total:	100,00

Amount of time allocated to each course unit

Designation	Time (hours)
Estudo autónomo	60,00
Frequência das aulas	52,00
Trabalho laboratorial	50,00
Total:	162,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 10 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, if Exam >= 8,0

Final mark = min{9; 0,7*Exam + 0,3*Distributed evaluation}, if Exam < 8,0

The distributed evaluation is obtained through the evaluation of a group work . This work will be evaluated in three different times: each of the first two deliveries worth 25% of the evaluation. The last delivery worth 50% of the distributed assessment.

Special assessment (TE, DA, ...)

Students in special circumstances who undergo some component of the distributed evaluation component in the edition in progress will be evaluated through the general evaluation rules as set out in 'Obtaining Frequency' being the final classification obtained under the rubric 'Formula de cálculo da classificação final'.

If not subjected to any component of the distributed evaluation they will be assessed by examination. In these cases, the final rating will be 100% of the mark obtained in the examination.

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 final ranking is obtained by weighted average between the exam and the distibuted evaluation, being the weights of 70% and 30% respectively.