Information Systems I

Code:

EIG0021

Acronym:

SI I

Keywords
Classification	Keyword
OFICIAL	Informatics
OFICIAL	Computer Science

Instance: 2006/2007 - 1S

Active?	Yes
Web Page:	http://paginas.fe.up.pt/~sibd/
Responsible unit:	Industrial Management and Engineering Section
Course/CS Responsible:	Master in Engineering and Industrial Management

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
LGEI	1	Plano de estudos de transição para 2006/07	3	6	6	56	160
MIEIG	47	Plano de estudos de transiçao para 2006/07	3	-	6	56	160
		Syllabus since 2006/2007	3	-	6	56	160

Teaching language

Portuguese

Objectives

Prepare the students to design information systems that organizations need and that satisfy the users, considering the short, medium and long term.

Program

1. Systems analysis and design - determining systems requirements; development life cycles; decision analysis concepts and systems design.

2. Designing the User Interface. Usability and Interaction Design.

3. Overview of the entity-relationship model, OMT and UML. Entities and attributes. Relationships. Entity-relationship diagrams. The extended entity-relationship model.

4. Relational Database system concepts - Overview of database systems. The relational model - structure of relational databases. Relational algebra and calculus.
Relational operators - selection, projection, binary operators and joins. Normalisation process. Data redundancy and inconsistency.
Functional dependencies. The first, second and third normal forms. Referential integrity. Boyce-Codd normal form. Fourth and fifth normal forms. Database Management Systems (DBMS) - Acess, Oracle and SQL Server. Query languages overview. Introduction to the SQL language. Selection conditions. Functions in SQL statements. Updating the database. Querying many tables. Joins and recursion. Reducing entity-relationship diagrams to tables.

5. Introduction to CSF - Critical Success Factor - analysis and tp BPE - Business Process Engineering.

Teaching methods and learning activities

Exposition in lectures and Tutorial classes.

There is no final examination but several short problems to be solved in the classes and a group project. Special teaching and evaluation procedure for students that cannot follow the course in Portuguese.

Evaluation Type

Distributed evaluation without final exam

Assessment Components

Description	Type	Time (hours)	Weight (%)	End date
Subject Classes	Participação presencial	56,00
	Total:	-	0,00

Eligibility for exams

Please contact João Falcão e Cunha (jfcunha@fe.up.pt).

Calculation formula of final grade

See above.

Examinations or Special Assignments

See above.

Special assessment (TE, DA, ...)

See above.

Classification improvement

See above.

Observations

See above.