Information Systems and Databases

Code:

EEC0044

Acronym:

SIBD

Keywords
Classification	Keyword
OFICIAL	Informatics

Instance: 2010/2011 - 1S

Active?	Yes
Web Page:	http://paginas.fe.up.pt/~arestivo/wiki/doku.php?id=aulas:sibd
Responsible unit:	Department of Informatics Engineering
Course/CS Responsible:	Master in Electrical and Computers Engineering

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
MIEEC	56	Syllabus (Transition) since 2010/2011	4	-	6	63	162
			5
		Syllabus	4	-	6	63	162
			5

Teaching language

Portuguese

Objectives

This course aims to endow students with skills to design and develop Web-accessible Information Systems supported by Databases.

Students, who successfully complete this course, should be able to:
1) Identify the requirements of an information system;
2) Design an entity relationship diagram of a database;
3) Convert an entity relationship diagram into a relational model;
4) Use relational algebra to formulate questions to a relational database;
5) Create and explore a database using PostgreSQL (a Database Management System);
6) Formulate SQL queries;
7) Design an user interface using XHTML;
8) Use PHP, a scripting language, and PHP libraries to develop an user interface;
9) Define presentation styles using CSS

Program

1) Database modelling
-----------------------------------------------
a. Extended Entity Relationship Model
b. Relational Model and Logical Schema

2) Using Databases
----------------------------------------------
a. Relational Algebra;
b. SQL;
c. PostgreSQL;
d. Advanced Topics (Triggers, Indexs and Transactions)

3) Web Information Systems
---------------------------------------------------------
a. HTML/ CSS;
b. PHP

Mandatory literature

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

Complementary Bibliography

Ramakrishnan, Raghu; Database Management Systems. ISBN: 0-07-115508-2
Silberschatz, Abraham; Database system concepts. ISBN: 0-07-114810-8

Teaching methods and learning activities

In theoretical classes the several topics of the course will be presented and discussed.

In Practical classes there will be assignments about the Entity-Relationship and Relational models and a project using PHP and PostgreSQL will be developed.

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Description	Type	Time (hours)	Weight (%)	End date
Attendance (estimated)	Participação presencial	52,00
Requirements and Modelation Report	Defesa pública de dissertação, de relatório de projeto ou estágio, ou de tese	25,00		2010-10-29
Architecture Report	Defesa pública de dissertação, de relatório de projeto ou estágio, ou de tese	25,00		2010-11-19
Project and Presentation	Defesa pública de dissertação, de relatório de projeto ou estágio, ou de tese	35,00		2010-12-17
Examn	Exame	40,00
	Total:	-	0,00

Eligibility for exams

Distributed evaluation will be based on:
- A laboratory group assignment (2 students)
- A SQL minitest

The Final Exam will contain questions about:
- Relationship Modeling
- Conversion into the Relation Model
- Relational Algebra
- SQL
- Advanced Database Topics

Calculation formula of final grade

- SQL Minitest (2 points)
- Requirements Report (2 points)
- Information System Implementation (4 points)
- Final Exam (10 points)

Special assessment (TE, DA, ...)

Students with a special status will be assessed just like ordinary students.

Classification improvement

Students can improve their distributed evaluation grade in the following year.

Observations

Students should be acquainted with programming.