Information Systems

Code:

EM0030

Acronym:

SI

Keywords
Classification	Keyword
OFICIAL	Informatics

Instance: 2007/2008 - 2S

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

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
LEM	0	Plano de estudos de transição para 2006/07	3	6	6	56	160
MIEM	114	Syllabus since 2006/2007	3	-	6	56	160
		Plano de estudos de transição para 2006/07	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.

Main Bibliography

[Date 1995] C. J. Date: An Introduction to Database Systems (6th Edition), Reading, Massachusetts: Addison Wesley Publishing Company 1995, Systems Programming Series, World Student Series Edition, xxiii+839 pp.; ISBN: 0-201-82458-2.

Complementary Bibliography

[Blaha & Premerlani 1998] Michael R. Blaha, William J. Premerlani: Object-Oriented Modeling and Design for Database Applications, Upper Saddle River, New Jersey: Prentice Hall 1998, xv+484 pp.; ISBN: 0-13-123829-9.

[Rockart 1979] John F. Rockart: Chief Executives Define their own Data Needs, Harvard Business Review, 2 (March-April 1979), pp. 81-93.

[Rummler & Brache 1995] Geary A. Rummler, Alan P. Brache: Improving Performance: How to Manage the White Space on the Organization Chart (2nd Edition). San Francisco: Jossey-Bass Publishers, 1990, xxv+226 pp.; ISBN 0-7879-0090-7.

[Shneiderman 1998] Ben Shneiderman: Designing the User Interface: Strategies for Effective Human-Computer Interaction (3rd Edition), Reading, Massachusetts: Addison Wesley Longman, Inc. 1998, xiv+639 pp.; ISBN: 0-201-69497-2.

Teaching methods and learning activities

Exposition in lectures and Tutorial classes.

Evaluation Type

Evaluation with final exam

Assessment Components

Description	Type	Time (hours)	Weight (%)	End date
Subject Classes	Participação presencial	56,00
	Exame	1,00		2008-03-28
	Exame	2,00		2008-03-11
	Exame	2,00		2008-04-29
	Trabalho escrito	10,00		2008-04-15
	Trabalho escrito	16,00		2008-05-20
	Exame	1,00		2008-05-30
	Total:	-	0,00

Amount of time allocated to each course unit

Description	Type	Time (hours)	End date
	Estudo autónomo	52	2008-06-06
	Total:	52,00

Eligibility for exams

See above.

Calculation formula of final grade

See above.

Examinations or Special Assignments

See above.

Special assessment (TE, DA, ...)

See above.

Classification improvement

The next academic year the student may be able to improve the marks obtained. For students with special status there is the possibility of replacing the group project by a design report of a data base, followed by building a prototype in a controled situation with available time of 5 hours. Examinations can be replaced by a special exam (on a date to be set).

Observations

Group project marks can be taken to next academic year.

Contact with students will be maintained through email (on SiFEUP system).

(Course Webpage in Portuguese)