Engenharia de Sistemas de Informação

Código:

EBE0061

Sigla:

ESIN

Áreas Científicas
Classificação	Área Científica
OFICIAL	Engenharia Biomédica

Ocorrência: 2012/2013 - 1S

Ativa?	Sim
Página Web:	http://paginas.fe.up.pt/~apm/ESIN/
Unidade Responsável:	Departamento de Engenharia Informática
Curso/CE Responsável:	Mestrado Integrado em Bioengenharia

Ciclos de Estudo/Cursos

Sigla	Nº de Estudantes	Plano de Estudos	Anos Curriculares	Créditos UCN	Créditos ECTS	Horas de Contacto	Horas Totais
MEB	7	Plano de estudos oficial	1	-	5	42	135
MIB	19	Plano de estudos oficial	4	-	5	42	135
PRODEB	3	Plano de estudos oficial	1	-	5	42	135

Língua de trabalho

Português - Suitable for English-speaking students

Objetivos

This course has as main objective to provide the knowledge and practice of the planning and design of an information system, specially its data component. The students should be able to analyze and model business processes and its information needs and design and build an efficient database schema from it. The design of database manipulation operations and web interfaces identified in the business process model should also be grasped by the students.

Programa

Theory:

1. Information Systems Introduction
Data and information
What is an information system
Information systems components
Data, business logic, interface
Information systems architecture
Life cycle and development phases
2. Data, Databases and Database Management Systems
Information and data modeling
Entity / Relationship model
Representation using the Universal Modeling Language (UML)
The Relational Model of Data
Relational algebra and set operations
The design of a database
Database schema
Decomposing relations
Normalization
The database language SQL (Structured Query Language)
The data definition language
Defining and modifying database schemas and properties
The data manipulation language
Selections and simple queries
Queries and operations involving more than one relation
Subqueries
Data modification: insertions, deletions and updates
Transactions in SQL
3. Web interfaces
Business processes and use cases
Web interface needs and design
Creating forms, business logic and data manipulation using ASP.NET
4. Medical Information Systems and Application Examples

Practice: Analysis, design and implementation of databases, business logic and user interface needed in information systems

Bibliografia Obrigatória

Jeffrey D. Ullman, Jennifer Widom; A First course in database systems. ISBN: 978-0-13-600-637-4
Raymond D. Frost, John Day, Craig Van Slyke; Database design and development. ISBN: 0-13-035122-9

Métodos de ensino e atividades de aprendizagem

- Theoretical concept exposition, with presentation of examples and demonstrations.
– Practical study of various types of business processes specially related to the medical field. This includes tha analysis, modeling, design and implementation of several real examples.

Software

DBMS - SQL Server
Web server - IIS
Visual Studio 2010

Palavras Chave

Ciências Tecnológicas > Tecnologia > Tecnologia da informação

Tipo de avaliação

Avaliação distribuída sem exame final

Obtenção de frequência

Complete and present the Lab assignments
A minimum grade of 6 (out of 20) in the written midterms

Fórmula de cálculo da classificação final

0.5 * Assgn + 0.5 * MidTerms

Assgn - Lab assignments grade
MidTerms - One or two open book midterms grade (average)

Avaliação especial (TE, DA, ...)

The same as for ordinary students. The assignments are mandatory and must be done and presented before the deadlines. Midterms are also mandatory.

Melhoria de classificação

A Final will be available for improving the midterm(s) grade.
Assignments can only be improved in the next instance of the curricular unit.