Databases

Code:

CINF005

Acronym:

BD

Instance: 2012/2013 - 2S

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

Working method

Presencial

Program

An organization’s information system. The automated information system.
Relational databases: relational model, relational algebra, data languages (SQL).
Building data access graphic interfaces.
Exploring a Database Management System: security and integrity.
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 slides, providing examples and discussing hands-on exercises.

Software

Soft. Update License &Support - 1 Oracle Database Enterprise Edition - Named user Plus Perp.
Microsoft Campus Agreement

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
Minitest	Exame	2,00
SQL contest	Exame	2,00
Design and implementation of a DB with interface	Trabalho laboratorial	20,00		2013-05-20
	Total:	-	0,00

Amount of time allocated to each course unit

Description	Type	Time (hours)	End date
Self study	Estudo autónomo	82
	Total:	82,00

Calculation formula of final grade

DE = 0.2 Test + 0.3 SQL Quiz + 0.5 Assignment
Final mark = 0.5 DE + 0.5 EX

DE - Distributed Evaluation
Ex - Exam

Examinations or Special Assignments

The Assignment consists in the design and implementation of a small database, including the data access interface. Is is developed by two persons groups. The assignment classification may be differ among the group members.

Special assessment (TE, DA, ...)

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

Classification improvement

The classification improvement examination substitutes the assessment components Test and SQL Quiz, besides the final examination. Final mark= 0.25 Assignment + 0.75 Exam