Information Systems and Databases

Code:

EEC0044

Acronym:

SIBD

Keywords
Classification	Keyword
OFICIAL	Informatics

Instance: 2011/2012 - 1S

Active?	Yes
Web Page:	http://www.fe.up.pt/~jlopes/doku.php/teach/sibd/index
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	34	Syllabus (Transition) since 2010/2011	4	-	6	63	162
		Syllabus	4	-	6	63	162

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:
- 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

Mandatory literature

Raghu Ramakrishnan, Johannes Gehrke; Database management systems. ISBN: 0-07-116898-2

Complementary Bibliography

Jeffrey D. Ullman, Jennifer Widom; A First Course in Database Systems. ISBN: 0-13-8687647-9
Abraham Silberschatz, Henry F. Korth, S. Sudarshan; Database system concepts. ISBN: 978-007-128959-7

Teaching methods and learning activities

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.

keywords

Physical sciences > Computer science > Informatics

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Description	Type	Time (hours)	Weight (%)	End date
Attendance (estimated)	Participação presencial	56,00
Requirements report	Defesa pública de dissertação, de relatório de projeto ou estágio, ou de tese	25,00		2011-11-04
Architecture report	Defesa pública de dissertação, de relatório de projeto ou estágio, ou de tese	25,00		2011-11-18
Product and presentation	Defesa pública de dissertação, de relatório de projeto ou estágio, ou de tese	35,00		2011-12-16
Exam	Exame	21,00
	Total:	-	0,00

Eligibility for 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.

Calculation formula of 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)

Examinations or Special Assignments

There are no special works or tests.

Special assessment (TE, DA, ...)

All students have the same evaluation.

Classification improvement

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