Information Systems

Code:

EEC0076

Acronym:

SINF

Keywords
Classification	Keyword
OFICIAL	Informatics
OFICIAL	Automation, Control & Manufacturing Syst.

Instance: 2010/2011 - 2S

Active?	Yes
Web Page:	http://paginas.fe.up.pt/~arestivo/wiki/?p=aulas/2011/sinf
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	193	Syllabus (Transition) since 2010/2011	3	-	6	63	162
		Syllabus	3	-	6	63	162

Teaching language

Portuguese

Objectives

Aims:
- To know how to analyse, design, implement and document moderately complex information systems using relational database management systems;
- To know how to use SQL language in moderately complex situations;
- To be familiar and use visual programming, event-driven tools and implications associated to this type of programming;
- To know how to develop moderately complex information systems using visual programming tools and relational database management systems.

Skills:
- To design and implement an information system using PGSQL;
- To be familiar and use SQL when carrying out a moderately complex research;
- To design and implement moderately complex programs using FPC/Lazarus and PGSQL.

Program

Program
- Entity-relationship model: specification tool of information systems;
- Relational model: Change of entity-relationship model to relational model; Integrity rules
- SQL language: creation, manipulation, queries and relational databases;
- Use of PostgreSQL;
- Introduction to operating systems services;
- Visual and even-driven programming;
- Use of FPC/Lazarus;
- Design and implementation of moderately complex information system.

Mandatory literature

Raghu Ramakrishnan; Database Management Systems. ISBN: 0-07-115508-2

Complementary Bibliography

Ullman, Jeffrey D; A First Course in Database Systems. ISBN: 0-13-8687647-9
Abraham Silberschatz, Henry F. Korth, S. Sudarshan; Database system concepts. ISBN: 0-07-228363-7
Cantú, Marco; Mastering Delphi 6. ISBN: 0-7821-2874-2
Marco Cantu, Uberto Barbini; Mastering Kylix 2, Sybex, 2002. ISBN: 0782128734

Teaching methods and learning activities

-Theoretical-classes: presentation of the themes of the course unit along with presentation and discussion of practical examples.
- Practical classes: resolution of practical exercises and supervision of a practical assignment.

Software

PostgreSQL
FPC/Lazarus

keywords

Physical sciences > Computer science > Database management
Physical sciences > Computer science > Programming

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Description	Type	Time (hours)	Weight (%)	End date
Attendance (estimated)	Participação presencial	56,00
SQL quiz	Exame	20,00
Project Proposal Report	Trabalho escrito	20,00
Information System Implementation	Exame	40,00
Exam	Exame	20,00
	Total:	-	0,00

Eligibility for exams

- Attendance to practical classes;
- Minimum grade of 35% in each of the assessment components

Calculation formula of final grade

- Professor’s opinion regarding students’ attitude and performance in practical classes: 2 values
- Practical test: 4 values
- Assignment: 6 values
- Final Exam: 8 values

Comment 1: Students have to reach a minimum grade of 35% in each of the assessment components.
Comment 2: If students miss the practical assignment (the absence has to be justified) the assignment is worth 8 values and the final exam 10 values.

Examinations or Special Assignments

- Practical tests using SQL/PGSQL: laboratory exam at the computer;
- Assignment: implementation of an information systems using Lazarus and databases; the theme is chosen by the students and approved by the professor; group assignment (3 students preferentially).

Special assessment (TE, DA, ...)

Students do not need to attend practical classes and do the practical test.
Assignment: 9 values
Final Exam: 11 values

Classification improvement

Individual improvement of the group assignment

Observations

- Automatic correction may be partially or totally used during the assessment of the practical test.
- The assessment of the assignment will be based on problem modelling and on the implementation of a Lazarus visual application using a database.