Information Systems

Code:

EEC0076

Acronym:

SINF

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

Instance: 2012/2013 - 2S

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

Teaching language

Suitable for English-speaking students

Objectives

• To know how to analyse, design, implement and document moderately complex information systems using relational database management systems; 


• To know how to use the SQL language in moderately complex situations; 


• Explain the main functions and structure of an operating system.

 

Learning outcomes and competences

• To design and implement an information system using PostgreSQL; 


• To be familiar and use SQL when carrying out moderately complex queries; 


• To design and implement moderately complex programs using C/C++, including access to relational databases. 

Working method

Presencial

Pre-requirements (prior knowledge) and co-requirements (common knowledge)

Program

• Entity-relationship model: tool for the specification of information systems; 


• Relational model: conversion of an entity-relationship model to a relational model; Integrity rules ;


• SQL language: creation, manipulation and queries in relational databases; 


• Use of PostgreSQL; 


• Introduction to operating systems services: architectures and basic functions; processes, threads, scheduling and interprocess communication; memory management; file systems;


• Design and implementation of moderately complex information system. 

Mandatory literature

000016736. ISBN: 0-07-115508-2
000051494. ISBN: 0-13-031358-0

Complementary Bibliography

000045331. ISBN: 0-13-8687647-9
000048499. ISBN: 0-07-228363-7

Teaching methods and learning activities

• Lectures: presentation of concepts to be discussed, followed by presentation and discussion of practical examples.


• Practicals: practical exercises and support to the development of the project.


• Evaluation: project, SQL quiz and exam.

Software

PostgreSQL
gcc
g++

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Description	Type	Time (hours)	Weight (%)	End date
Lectures (estimated)	Participação presencial	56,00	0,00
Exam	Exame	3,00	50,00
Mini-test	Teste	3,00	20,00
Project	Trabalho laboratorial	40,00	30,00
	Total:	-	100,00

Amount of time allocated to each course unit

Description	Type	Time (hours)	End date
Lectures (estimated)	Frequência das aulas	56
Study	Estudo autónomo	66
Project	Elaboração de projeto	40
	Total:	162,00

Eligibility for exams

• Attendance of practical sessions


• Minimum 40% grade in each of the components of the evaluation

Attendance grade (10 points)

• Mini-test: 4 points


• Project: 6 points

Calculation formula of final grade

• Attendance grade: 10 points


• Final exam: 10 points

Obs 1: Minimum grade of 40% on each evaluation component 

Obs 2: In case of justified failure to attend the mini-test, the grade of the project will be 8 points and the grade of the final exam will be 12 points.

Examinations or Special Assignments

• Mini-teste on SQL: individual laboratory test carried out in a computer; 


• Project: implementation of a multi-threaded application in C/C++; the project is selected by the students and adapted / validated by the teacher; group project, with preferably 3 elements from the same class per group. 

Special assessment (TE, DA, ...)

Students with worker statute or equivalent should periodically get advice from the teachers concerning their progress, present them together with the regular students and take the minitests for the individual evaluation.

Classification improvement

Individual improvement of the group project.

Observations

Automatic correction methods may be used in the evaluation.