Information Systems I

Code:

ESG0028

Acronym:

SII

Keywords
Classification	Keyword
OFICIAL	Interaction and Multimedia
OFICIAL	Engineering

Instance: 2020/2021 - 2S

Active?	Yes
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	9	Syllabus since 2007/08	1	-	6	56	162

Teaching language

Suitable for English-speaking students

Objectives

Prepare students for designing information systems appropriate to user needs and objectives of organizations, considering the short, medium and long term. So they should be able to prepare conceptual models of information, in particular classes of objects and relational models, develop conceptual models of user interaction, apply software engineering methodology, and use relational database management systems.

Learning outcomes and competences

Students should be able to (i) analyze a problem of information management, (ii) propose and test a conceptual model, (iii) build and test a prototype database and user interfaces, including searches and reports. This prototype can be for personal use, but it is not suitable for groups of people. Students learn to negotiate the development of robust enterprise systems.

Working method

Presencial

Pre-requirements (prior knowledge) and co-requirements (common knowledge)

Algebra.

Basic enterprise Management concepts.

Basic personal computing skills.

Program

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

2. USER INTERFACE MODELING: Introduction; Introduction to specification and prototyping tools; Recommendations, principles and rules for interface design; Main models of interface: menus, forms, dialogue boxes and direct manipulation; Problems with user interaction modelling.

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

4. DATABASE DESIGN: Introduction to DBMS - Database Management Systems; SQL language; RelacionalAlgebra and Calculus; Database normalisation.

5. CONCLUSIONS AND REFERENCES.

Mandatory literature

C. J. Date; An introduction to database systems. ISBN: 0-201-19215-2 (vol.1)
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

Complementary Bibliography

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

Comments from the literature

MAIN BIBLIOGRAPHY: Documentation prepared by lecturers (lecture notes in Portuguese and presentations from classes in English) in the course Web page (SiFEUP/SIGARRA).

OTHER BIBLIOGRAPHY (selected chapters to be indicated by the lecturers on the indicated themes):
DESIGN OF INFORMATION SYSTEMS: Barry W. Boehm: Software Engineering Economics, Prentice Hall 1981.
USER INTERFACE MODELING: Yvonne Rogers, Helen Sharp, Jenny Preece: Interaction Design: Beyond Human - Computer Interaction, John Wiley & Sons 2011.
CONCEPTUAL MODELING OF CLASSES: Michael R. Blaha, William J. Premerlani: Object-Oriented Modeling and Design for Database Applications, Prentice Hall 1998.
DATABASE DESIGN and CONCEPTUAL MODELING OF CLASSES: Abraham Silberschatz, Henry F. Korth, S. Sudarshan: Database System Concepts, McGraw-Hill 1997.
DATABASE DESIGN: C. J. Date: An Introduction to Database Systems (6th Edition), Addison Wesley 1995.
CRITICAL SUCCESS FACTORS: John F. Rockart: Chief Executives Define their own Data Needs, Harvard Business Review, 2, 1979.
PROCESS MODELLING: Geary A. Rummler, Alan P. Brache: Improving Performance: How to Manage the White Space on the Organization Chart, Jossey-Bass 1990

Teaching methods and learning activities

This course is based on the following complementary activities that involve lecturing, learning, and associated assessment of acquired knowledge and competences:

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

A2. THEORETICAL-PRACTICAL CASES: Students should study test cases and solutions presented by lecturers in classes, and practice with new problems.

A3. DBMS TOOL: After the presentation of the software tool (MS Access) students should autonomously use and explore it.

A4. INFORMATION SYSTEM PROTOTYPE: Students have to design and develop an IS prototype. This project will be supervised by the lecturers during classes. Note: Student groups will be composed based on a questionnaire with behavioural questions aiming at creating homogenous groups.

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
Teste	10,00
Trabalho escrito	15,00
Trabalho laboratorial	25,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	16,00
Estudo autónomo	60,00
Frequência das aulas	56,00
Trabalho de investigação	10,00
Total:	162,00

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 if required. It will also be taken into the account in the assessment the presentation, correctness and quality of the Portuguese or English language used.

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.

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%

Each group makes a 10 minute presentation. The lecturers may choose which student will make the presentation and may ask questions to each group member individually (this allows a distinct evaluation of each group member in this evaluation component).

At the end of the group project assignment, each student has to assess each of his group colleagues using a cross evaluation system available on: http://paginas.fe.up.pt/~sibd/aval (SiFEUP/SIGARRA username and password). This cross-evaluation may change the individual mark of a student in the group project negatively or positively as follows: [-2, -1, 0, 1] (when compared to the global group mark before cross-evaluation).

Students who do not answer the survey used to set the profile for the creation of the projects groups within the prescribed deadline will have a penalty of 25% on the group work mark.

Students who do not perform the cross-evaluation within the prescribed deadline will have a penalty of 25% on the group work mark and the corresponding cross-evaluation will be filled with the default value.

At the time of appeal exam: the marks obtained in group work and in the MS Access mini-test will keep the same weight.

Examinations or Special Assignments

Not applicable.

Internship work/project

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

Classification improvement

Students may also improve their marks in the P2 or P3 components in the following academic year.

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 will be selected by the lecturers. This selection will be based on a questionnaire, which will work as way of defining each students’ profile in a group. 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 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)