Information Systems Engineering

Code:

EBE0061

Acronym:

ESIN

Keywords
Classification	Keyword
OFICIAL	Biomedical Engineering

Instance: 2012/2013 - 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	7	Syllabus	1	-	5	42	135
MIB	19	Syllabus	4	-	5	42	135
PRODEB	3	Syllabus	1	-	5	42	135

Teaching language

Suitable for English-speaking students

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. 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.

Program

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

Mandatory literature

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

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 2010

keywords

Technological sciences > Technology > Information technology

Evaluation Type

Distributed evaluation without final exam

Eligibility for exams

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

Calculation formula of final grade

0.5 * Assgn + 0.5 * MidT

Assgn - Lab assignments grade
MidT - Open book midterms grade

Special assessment (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.

Classification improvement

Assignments can be improved until the end of classes.
A Final will be available for improving the midterms grade (February 2010).