Databases

Code:

CINF005

Acronym:

BD

Keywords
Classification	Keyword
OFICIAL	Computer Sciences

Instance: 2021/2022 - 2S

Active?	Yes
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	38	CINF - Study Plan	3	-	6	56	162

Teaching language

Portuguese

Objectives

The goal of the course is to get the students familiar with databases both as components of information systems to be specified or managed and as information sources to be explored, enabling them to participate on the definition of an organizational data storage strategy.

Learning outcomes and competences

1. To define a data model, according to the general principles of database systems;


2. to express queries to the database using relational algebra;


3. to retrieve information from a database using SQL;


4. to define models for the interface and access control of database applications;


5. to implement small databases;


6. to include data warehouses and XML technology in a global data storage strategy for the organization.

Working method

Presencial

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

Knowledge on information systems modeling, in particular UML.

Program

An organization’s information system. Database management systems.
Relational databases: relational model; translation from UML conceptual models into relational models; querying with relational algebra;

SQL data languages. Information retrieval tasks using simple queries, joins, agregation operators, subqueries, and universal quantification.

Building data access graphic interfaces. Information systems security and integrity.

Introduction to data warehouses and dimensional modelling. Databases and XML technologies.

Mandatory literature

Jeffrey D. Ullman, Jennifer Widom; A First course in database systems. ISBN: 978-0-13-600-637-4
Damas, Luís Manuel Dias; SQL. ISBN: 972-722-188-2

Complementary Bibliography

Ralph Kimball, Margy Ross; The data warehouse toolkit. ISBN: 0-471-20024-7

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

Designation	Weight (%)
Exame	50,00
Participação presencial	0,00
Teste	25,00
Trabalho laboratorial	25,00
Total:	100,00

Amount of time allocated to each course unit

Designation	Time (hours)
Estudo autónomo	82,00
Frequência das aulas	56,00
Trabalho laboratorial	24,00
Total:	162,00

Eligibility for exams

A minimum of 7 is required in the distributed evaluation (DE) to obtain frequency recognition and to obtain approval.

Calculation formula of final grade

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

DE - Distributed Evaluation
Ex - Exam
7 out of 20 minimum at the 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 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, besides the final examination. Final mark= 0.25 Assignment + 0.75 Exam