Information Systems and Databases

Code:

EEC0044

Acronym:

SIBD

Keywords
Classification	Keyword
OFICIAL	Informatics

Instance: 2009/2010 - 1S

Active?	Yes
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	41	Syllabus since 2007/2008	4	-	7	77	187
			5

Teaching language

Portuguese

Objectives

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

Students, who successfully complete this course, should be capable of:
1) Identifying the requirements of an information system;
2) Designing an entity relationship diagram of a database;
3) Converting an entity relationship diagram into relational model;
4) Using relational algebra to formulate questions to a relational database;
5) Creating and exploring a database using PostgreSQL (Database Management System);
6) Using SQL queries;
7) Designing a user interface on XHTML;
8) Using scripting language PHP and libraries to develop an user interface;
9) Defining 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

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

Theoretical classes will be based on the presentation of the themes of the course and on discussion.
Practical classes will be based on assignments using PostgreSQL and PHP.

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Description	Type	Time (hours)	Weight (%)	End date
Subject Classes	Participação presencial	75,00
Database Model Report	Trabalho escrito	20,00		2009-10-14
Information System Implementation	Trabalho escrito	40,00		2009-12-18
SQL Quiz	Exame	20,00		2009-11-04
Exam	Exame	20,00		2010-02-12
Information System Architecture Report	Trabalho escrito	35,00		2009-11-18
	Total:	-	0,00

Eligibility for exams

Continuous assessment will be based on a laboratory group assignment (2 students), on a SQL mini-test and on a Final Exam.

Calculation formula of final grade

- Professor’s opinion regarding students’ performance in practical classes (2 values)
- SQL Mini test (2 values)
- Requirement Report (2 values)
- Information System Implementation (4 values)
- Final Exam (8 values)

Special assessment (TE, DA, ...)

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

Classification improvement

Students can improve their continuous assessment grade in the following year.

Observations

Students should be acquainted with programming.