Databases

Code:

CINF005

Acronym:

BD

Instance: 2009/2010 - 2S

Active?	Yes
Web Page:	https://www.fe.up.pt/si/DISCIPLINAS_GERAL.FORMVIEW?P_ANO_LECTIVO=2009/2010&P_CAD_CODIGO=CINF005&P_PERIODO=2S
E-learning page:	http://moodle.fe.up.pt/
Responsible unit:	Department of Informatics Engineering
Course/CS Responsible:	Bachelor of Arts in Information Science

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
CINF	53	Plano Oficial a partir de 2008/2009	3	-	6	56	162

Teaching language

Portuguese

Objectives

When faced with the problem of automating an information process, students shall be able to define a data model, according to the general principles of database systems; understand the basic notions of the relational model and be able to query a database using SQL; and know how to define a global data storage strategy for the organization.

Program

An organization’s information system. Modelling. Entity-relationship modelling. Relational databases: relational model, relational algebra, data languages (SQL). Exploring a Database Management System: security and integrity. Databases and decision support systems. Introduction to data warehouses and dimensional modelling.

Mandatory literature

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

Complementary Bibliography

Damas, Luís Manuel Dias; SQL. ISBN: 972-722-188-2
Kimball, Ralph 070; The Data Warehouse lifecycle toolkit. ISBN: 0-471-25547-5

Teaching methods and learning activities

Explanation of the subject matter will take place in class, using transparencies, providing examples and discussing hands-on exercises.

Software

Oracle 10g com Application Express
Microsoft Access

keywords

Physical sciences > Computer science > Database management

Evaluation Type

Distributed evaluation without final exam

Assessment Components

Description	Type	Time (hours)	Weight (%)	End date
Attendance (estimated)	Participação presencial	64,00
Work in groups	Exame	16,00		2010-06-11
	Total:	-	0,00

Amount of time allocated to each course unit

Description	Type	Time (hours)	End date
Work extra classes	Estudo autónomo	82
	Total:	82,00

Eligibility for exams

Distributed Evaluation = Test + SQL Quiz + Assignment

Calculation formula of final grade

Final mark = 0.5 DE + 0.5 EX

Special assessment (TE, DA, ...)

Working students and other special cases follow the same evaluation procedures as normal students.

Classification improvement

Exam to improve marks can be taken according to the general rules in force.