Go to:
Logótipo
Esta página em português Ajuda Autenticar-se
Formação regular da Biblioteca |fevereiro a maio
Today is sunday
You are here: Start > EBE0061
Authentication




Site map
Edifício A (Administração) Edifício B (Aulas) - Bloco I Edifício B (Aulas) - Bloco II Edifício B (Aulas) - Bloco III Edifício B (Aulas) - Bloco IV Edifício C (Biblioteca) Edifício D (CICA) Edifício E (Química) Edifício F (Minas e Metalurgia) Edifício F (Minas e Metalurgia) Edifício G (Civil) Edifício H (Civil) Edifício I (Electrotecnia) Edifício J (Electrotecnia) Edifício K (Pavilhão FCNAUP) Edifício L (Mecânica) Edifício M (Mecânica) Edifício N (Garagem) Edifício O (Cafetaria) Edifício P (Cantina) Edifício Q (Central de Gases) Edifício R (Laboratório de Engenharia do Ambiente) Edifício S (INESC) Edifício T (Torre do INEGI) Edifício U (Nave do INEGI) Edifício X (Associação de Estudantes)

Information Systems Engineering

Code: EBE0061     Acronym: ESIN

Keywords
Classification Keyword
OFICIAL Biomedical Engineering

Instance: 2016/2017 - 1S

Active? Yes
Web Page: http://paginas.fe.up.pt/~apm/ESIN/
Responsible unit: Department of Informatics Engineering
Course/CS Responsible: Master in Bioengineering

Cycles of Study/Courses

Acronym No. of Students Study Plan Curricular Years Credits UCN Credits ECTS Contact hours Total Time
MEB 27 Syllabus 1 - 6 56 162
MIB 26 Syllabus 4 - 6 56 162

Teaching Staff - Responsibilities

Teacher Responsibility
António Miguel Pontes Pimenta Monteiro

Teaching - Hours

Recitations: 2,00
Laboratory Practice: 2,00
Type Teacher Classes Hour
Recitations Totals 1 2,00
António Miguel Pontes Pimenta Monteiro 2,00
Laboratory Practice Totals 2 4,00
António Miguel Pontes Pimenta Monteiro 4,00

Teaching language

English

Objectives

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 representation and organization.  The understanding and efficient use of the data relational model and its implementation in a database management system belong also to the course objectives.
Another objective is the knowledge and practice of building adequate user interfaces capable of supporting the business processes underlying the information system. That interface should execute the flow of a business process through the normal search, update, create and eliminate data operations.

Learning outcomes and competences

The students should be able to analyze and model business processes and its information needs and design and build an efficient relational database schema from it.
Another result should be the capacity to design and implement web interfaces in a simple server technology, and the database manipulation operations identified as needs in the business process model.

Working method

Presencial

Program

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
3. The database language SQL (Structured Query Language)
     The data definition language (DDL)
     Defining and modifying database schemas and properties
     The data manipulation language (DML)
     Selections and simple queries
     Queries and operations involving more than one relation
     Subqueries
     Data modification: insertions, deletions and updates
     Transactions in SQL
4. Web interfaces
     Business processes and use cases
     The working of a Web application
     Web interface needs and design
     Creating forms, business logic and data manipulation using ASP.NET technology
5. Application Examples Practice
     Analysis, design and implementation of databases
     Business processes and logic and user interface needed in information systems

Mandatory literature

Thomas Connolly, Carolyn Begg; Database Systems: A Practical Approach to Design, Implementation, and Management, 6th Edition, Pearson, 2015. ISBN: 978-0-132-94326-0 (A modern and complete description of DBMS)
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

Complementary Bibliography

C. J. Date; SQL and Relational Theory, 3rd Edition, O'Reilly, 2015. ISBN: 978-1-4919-4117-1 (How to Write Accurate Code)

Comments from the literature

The first or second titles cover the first 3 chapters, while the last title covers essentially chapter 4.

Teaching methods and learning activities

– 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 2013

keywords

Technological sciences > Technology > Information technology
Technological sciences > Technology > Internet technology

Evaluation Type

Distributed evaluation without final exam

Assessment Components

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

Amount of time allocated to each course unit

Designation Time (hours)
Elaboração de projeto 14,00
Estudo autónomo 34,00
Frequência das aulas 56,00
Trabalho laboratorial 58,00
Total: 162,00

Eligibility for exams

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

Calculation formula of final grade

0.5 * Assgn + 0.5 * Test
Assgn - Lab assignments grade
Test - Open book test examination grade

Special assessment (TE, DA, ...)

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

Classification improvement

The written test grade can be improved following the general rules.
The Lab assignments, due to their extension, can be improved in the next curricular unit ocorrence.

Recommend this page Top
Copyright 1996-2019 © Faculdade de Engenharia da Universidade do Porto  I Terms and Conditions  I Accessibility  I Index A-Z  I Guest Book
Page generated on: 2019-05-26 at 11:03:00