====== Description of Course Unit ======

**[[http://sigarra.up.pt/feup/pt/cur_geral.cur_view?pv_curso_id=741|Master in Electrical and Computers Engineering]]\\
  [[http://www.fe.up.pt/si_uk/disciplinas_geral.FormView?p_cad_codigo=EEC0044|Information Systems and Databases]]\\
  [[http://www.fe.up.pt/si_uk/disciplinas_geral.formview?p_cad_codigo=EEC0044&p_ano_lectivo=2011/2012&p_periodo=1S|Instance: 2011/2012]]**
\\
---
\\

//**[[http://www.fe.up.pt/si_uk/disciplinas_geral.formview?p_cad_codigo=EEC0044&p_ano_lectivo=2011/2012&p_periodo=1S|Institutional page]]**// 

===== General Information =====

**Course Unit**: Information Systems and Databases\\
**Code**: EEC0044\\
**Programmes**: MIEEC, 4º, 31 students\\
**Academic Year**: 2011/2012\\
**Semester**: 1S
**ECTS**: 6\\
**Hours/Weeks**: 2T, 2x2P\\
**Teachers**: [[http://www.fe.up.pt/si/en/func_geral.FormView?p_codigo=230756|João Correia Lopes]] 

===== Teaching Language =====

Portuguese

===== Objectives, Skills and Learning Outcomes =====

==== Goals ====

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

==== Learning Outcomes ====

Students, who successfully complete this course, should be able to:
  - Identify the requirements of an information system;
  - Design an entity relationship diagram of a database;
  - Convert an entity relationship diagram into the relational model;
  - Use relational algebra to formulate questions to a relational database;
  - Create and explore a database using the DBMS PostgreSQL;
  - Formulate SQL queries;
  - Design an user interface using XHTML;
  - Use PHP, a scripting language, and PHP libraries to develop an user interface;
  - Define presentation styles using CSS.

===== Program =====

  * Extended Entity Relationship Model
  * Relational Model
  * Relational Algebra
  * SQL
  * PostgreSQL
  * Advanced topics:  triggers, indexes and transactions;
  * Web Information Systems
  * Client-side languages: HTML, CSS
  * Server-side languages. PHP

===== Main Bibliography =====

  * Raghu Ramakrishnan, J. Gehrke, [[http://www.cs.wisc.edu/~dbbook/|Database Management Systems]], McGRAW-Hill International Editions, 3rd Edition, 2002, ISBN=0-07-246563-8. [[http://aleph.fe.up.pt/F/-?func=find-b&find_code=SYS&request=000045331|Biblioteca]]

===== Complementary Bibliography =====

  * Jeffrey D. Ullman, Jennifer Widom, [[http://www-db.stanford.edu/~ullman/fcdb.html|A First Course in Database Systems]], Prentice-Hall, 2nd Edition, 2001, ISBN=0-13-035300-0. [[http://aleph.fe.up.pt/F/-?func=find-b&find_code=SYS&request=000045331|Biblioteca]]
  * Abraham Silberschatz, Henry Korth, S. Sudarshan, [[http://www.mcgraw-hill.com.au/html/9780073523323.html|Database System Concepts]], McGRAW-Hill Higher Education, 6th Edition, 2010, ISBN=0-07-352332-1. [[http://aleph.fe.up.pt/F/-?func=find-b&find_code=SYS&request=0000110633|Biblioteca]]

===== Teaching Procedures =====

In theoretical classes the 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.

===== Software =====

  * PostgreSQL, PHP

===== Keywords =====

Physical sciences > Computer science > Informatics

===== Evaluation Type =====

Distributed evaluation with final exam

===== Registered evaluation and occupation components =====

^  Description  ^  Type  ^  Time (Hours)  ^  Date of conclusion  ^
| Attendance (estimated)  | Lectures  |  56   |	  | 
| Requirements report  | Project Work  |  25  |  2011-11-04  |
| Architecture report  | Project Work  |  25  |  2011-11-18  |
| Product and presentation  | Project Work  |  35   |  2011-12-16  |
| Examn  | Test/Examination  | 	21  |   | 
|  | Total:   |	 162   |   |

===== Admission to Exams =====

Distributed evaluation will be based on:
  * A laboratory group assignment (2 students)

The Final Exam will contain questions about:
  * Entity-relationship modelling
  * Conversion into the Relation model
  * Relational algebra
  * SQL
  * Advanced database topics

Minimum required to pass this course: 40% in each practical assignment and in the final exam.

===== Final grade =====

The final grade is the result of:
  * Requirements report (2,5 points)
  * Architecture report (2,5 points)
  * Information System Implementation (5 points)
  * Final exam (10 points)

===== Special Assignments =====

There are no special works or tests. 

===== Improvement of Final/Distributed Classification =====

Students can improve their distributed evaluation grade in the course's next edition. 

===== Special evaluation (TE, DA, ...) =====

All students have the same evaluation.


\\
-- JCL