Information Systems

Code:

ESG0003

Acronym:

SI

Keywords
Classification	Keyword
OFICIAL	Systems Design
OFICIAL	Information Services in Internet

Instance: 2009/2010 - 1S

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

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
MESG	0	Syllabus since 2007/08	1	-	6	42	162
PRDEIG	1	Syllabus since 2007/08	1	-	6	42	162

Teaching language

Portuguese

Objectives

MAIN AIMS
The main aim of this course unit is to train students to design adequate information systems which fulfil users’ needs and the objectives of organisations, always taking into account the short, medium and long term.

OTHER AIMS
1. To train students to use identification techniques of critical factors of success, activities modeling and business processes.
2. To train students to use conceptual modeling techniques of information, particularly object classes.
3. To train students to use user interface modeling techniques.
4. To train students to use a design methodology of computer technology.
5. To train students to use the available computer tools on Database Management Systems (DBMS) for Information Systems prototyping.
6. To train students to use relational modeling techniques.

Program

1. DESIGN OF INFORMATION SYSTEMS:
Introduction to processes of analysis and modeling of systems and organisations; Introduction to the design of an information system

2. USER INTERFACE MODELING:
Introduction to user interface modeling; Introduction to OAI model, forms of specification and prototyping tools; Recommendations, principles and rules to design interfaces; Main models of interface: menus, forms, dialogue boxes and direct manipulation; User interface modeling: problems

3. CONCEPTUAL MODELING OF CLASSES: static modelling of classes; object, attributes and methods classes; connections, associations and simple aggregations; generalisations and simple inheritance; Mapping between class model and relational model

4. DATABASE DESIGN:
Introduction to DBMS- Database Management Systems; Relational systems and SQL language; Database normalisation; Other DBMS models

5. CONCLUSIONS AND FINAL REFERENCES

Teaching methods and learning activities

This course unit is based on the following activity components:

A1. THEORETICAL NOTIONS
The theoretical concepts taught during theoretical classes should be learned by study activities and conceptualisation.

A2. THEORETICAL-PRACTICAL CASES
Students should study, practice and test cases and solutions presented in class.

A3. DBMS TOOL
After the presentation of the computer tool (Microsoft Access) students should autonomously use it.

A4. IS PROTOTYPE
Students have to design and develop a IS prototype. This project will be supervised by the professors.

Evaluation Type

Distributed evaluation without final exam

Eligibility for exams

Students have to reach a minimum mark to be admitted to exams (See General Evaluation Rules of FEUP).
All written examinations are closed book exercises. The most important formulas will be provided to students. It will also be taken into the account in the assessment the presentation, correctness and quality of the Portuguese language.

Calculation formula of final grade

Final Mark will be based on the mark of the mini-tests (60%) and on the group assignment (40%).

P1- Mini-tests TP
P1.1 Mini-test 1: 30%
P1.2 Mini-test 2: 30%

P2- Group assignment
P2.1- Report: 10%
P2.2- Work developed- 25%
P2.3- Presentation- 5%

Examinations or Special Assignments

Not applicable

Special assessment (TE, DA, ...)

Students with a special status (working students, military personnel and high-level competition athletes) can either opt to be assessed as ordinary students or substitute components P2.2 and P2.2 by a computer exam. It will be based on the design of a prototype (P2.1= 2 values- 10%).

It will last around 5 hours (P2.2 + P2.3 =8 marks- 40%). Besides they have to attend to a written exam (P3), in which the theoretical component (P3.1) is worth 4 marksand the practical component (P3.2) is worth 6 marks(P3.1 + P3.2= 10 marks- 50%).

Classification improvement

Students may improve their mark in the following academic year, by improving the components they wish.

Observations

The members of the groups will be selected by the professors. This selection will be based on a quiz, which will work as way of defining students’ profile.

Each member of the group will have the chance to assess the performance of the peer members, by a system of crossed assessment.

Students, who failed this course unit in previous years, can ask to their previous assignments (P1. mini-tests or P2. group assignment) to be taken into account in the assessment.

Only students who achieve an average mark of 10 out of 20 in the component P1 can complete the course.

Students must earn a minimum mark of 10 out of 20 both on the report and on the assignment, for component P2 to be taken into account in a future assessment.
Besides the mark of the assignment can only be taken into account, if students have achieved a passing mark in the crossed assessment.

The grade of previous years’ assignments will be calculated based on a simple proportionality rule (for example, if a student have achieved a mark of 16 out of 20 on P2 and if in the current year they achieve a grade of 8 out of 20, it will be calculated as follows: (16/20)x8=6,4

Contact with students will be made by e-mail (SIFEUP).



_______________________________________________________________________________________

REFERENCE BOOKS:

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

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

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