Information Systems

Code:

EEC0076

Acronym:

SINF

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

Instance: 2013/2014 - 2S

Active?	Yes
Web Page:	http://paginas.fe.up.pt/~arestivo/doku/doku.php/classes:years:2014: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	168	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;

 

• To know how to develop and analyze a decision support model following a data mining approach based on data in a relational database;

 

• 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 develop simple data mining projects using RapidMiner;

 

• Understand the basic principles of oprating systems;

 

• 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;

 

• Data mining: introduction, methodology, tasks (focusing on classification), evaluation;

 

• Use of RapidMiner;

 

• Design and implementation of moderately complex information system. 

 

Mandatory literature

Raghu Ramakrishnan; Database Management Systems. ISBN: 0-07-115508-2
Andrew S. Tanenbaum; Modern operating systems. ISBN: 0-13-031358-0

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: 0-07-228363-7

Teaching methods and learning activities

 

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

 

• Practical sessions: practical exercises and support to the development of the project;

 

• Evaluation: project, SQL quiz and exam.

 

Software

gcc
PostgreSQL
g++
RapidMiner

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Designation	Weight (%)
Exame	50,00
Teste	20,00
Trabalho laboratorial	30,00
Total:	100,00

Amount of time allocated to each course unit

Designation	Time (hours)
Elaboração de projeto	40,00
Estudo autónomo	66,00
Frequência das aulas	56,00
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.