Information Systems

Code:

EM0030

Acronym:

SI

Keywords
Classification	Keyword
OFICIAL	Management

Instance: 2017/2018 - 2S

Active?	Yes
Responsible unit:	Department of Industrial Engineering and Management
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
MIEM	169	Syllabus since 2006/2007	3	-	6	39	162

Teaching language

English

Objectives

This course aims to prepare students to develop information systems suitable for users and organisations, taking into account short, medium and long term.

Learning outcomes and competences

This course also aims to:

1. prepare students to use identification techniques of critical factors of success and active modelling and business processes.

2. prepare students to use conceptual modelling techniques of information, especially object classes.

3. prepare students to use modelling techniques of interaction with users, especially graphic interaction.

4. prepare students to use a project methodology of engineering informatics.

5. prepare students to use the available computer tools of SGBDr (Sistema de Gestão de Bases de Dados)- System Manager Database- to prototype information systems.

6. prepare students to use relational modelling techniques

Working method

Presencial

Program

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

2. Designing the User Interface Introduction to the process of interaction modelling with users; introduction to the OAI model, specification forms and prototyping tools; recommendation, principles and rules for interface design; main models of interaction: menus, forms, dialog boxes and direct manipulation; Modelling interaction problems with users

3. Conceptual modelling classes: process of static classes modelling; classes of objects; attributes and methods; connections; associations and simple aggregations; generalization and simple inheritance; mapping between classes model and relational model

4. Data base design: Introduction to SGBD, Relational Systems and SQL language; Functional normalization of data to BDr design

5. Conclusion and final references

Mandatory literature

José Luís Moura Borges, Teresa Galvão Dias, João Falcão e Cunha; Modelação de Dados em UML, FCA - Editora de Informática, 2015. ISBN: 978-972-722-812-6
C. J. Date; An introduction to database systems. ISBN: 0-201-19215-2 (vol.1)

Complementary Bibliography

Michael Blaha, William Premerlani; Object-oriented modeling and design for database applications. ISBN: 0-13-123829-9
Feliz Gouveia; Fundamentos de Bases de Dados, FCA - Editora de Informática, 2014. ISBN: 978-972-722-799-0

Teaching methods and learning activities

This course will be composed by four components:

A1. Theory- The program’s theory will be exposed in classes and students are supposed to learn it through study activities

A2. Theoretical-practical - Problems and solutions will be presented in classes and they should be studied by the students

A3. SGBD tool- This tool will be present in classes and students should be able to use it autonomously

A4. SI Prototype – the design of a SI prototype will be supervised by the Professor during classes

Software

microsoft access

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Designation	Weight (%)
Defesa pública de dissertação, de relatório de projeto ou estágio, ou de tese	5,00
Exame	45,00
Participação presencial	0,00
Teste	10,00
Trabalho escrito	40,00
Total:	100,00

Amount of time allocated to each course unit

Designation	Time (hours)
Elaboração de projeto	20,00
Elaboração de relatório/dissertação/tese	20,00
Estudo autónomo	70,00
Frequência das aulas	40,00
Trabalho de investigação	12,00
Total:	162,00

Eligibility for exams

Students can only complete this course if they achieve a minimum grade indicated (General Evaluation Rules of FEUP).

Students are not allowed to consult notes during the written exams, because the most important formulas will be provided.
Students will also be assessed on their correctness and Portuguese language skills.

A grade of an assignment done in previous years can only be taken into account if on crossed assessment within the group, the student earn more than 2.5 votes out of 5.

Calculation formula of final grade

The final mark will be calculated based on the grades achieved on the mini-test Access (10% of the Final Mark),  and on the group assignment (45% of the Final Mark)

P1. Mini-test Access: 10%

P2. Final Exam : 45% (Note: A minimum mark of 6.5 out of 20 is required in this component for successful completion of this course.

P3 Group assignment

P3.1 Report: 15%

P3.2 Assignment: 25%

P3.3- Assignment presentation: 5%

For those students whose project classification (P3) exceeds the exam classification (P2) by more than 5 marks, for the computation of the final mark it will be considered as the project classification P3=P2+5

Students who do not respond to the survey used to define the profile of each student within the stipulated period will have a penalty of up to 25% on the final grade in the component corresponding to team project.

 

Examinations or Special Assignments

Not Applicable

Special assessment (TE, DA, ...)

Students with a special status (working students, military students and athletes) can either choose between the assessment rules above mentioned or substitute the components P1 and P3 for a practical individual computer exam, which will take place on a date scheduled by the Professor. This exam will be based on the design of a prototype.

This exam will last 5 hours. Besides, students must attend a written exam instead of components P2 and P4.

Classification improvement

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

The group project mark done in a previous academic year will be considered only if the cross-evaluation by the rest of the group is over 2.5 values in 5.

Observations

The members of the groups for the group assignment will be selected by the Professors.

This selection will be based on a questionnaire, which will work as way of defining students’ profile. Each member of the group will have the chance to assess the performance of the members of their group, through a system of crossed assessment.

Students who failed this course on the previous years, can use their previous assignments (P2 exam or P3 group assignment) to be assessed this year.

Students must earn a minimum grade of 10 out of 20 both on the report and on the assignment, for component P3 to be taken into account in a future assessment.
In addition, a grade of an assignment done in previous years can only be taken into account if on crossed assessment within the group, the student earn more than 2.5 votes out of 5.

The grade of previous years’ assignments will be calculated based on a simple proportionality rule (for example, if a student achieved a grade of 16 out of 20 on P2 and if in the current year he/she achieves 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)