Information Systems

Code:

MEB0036

Acronym:

SI

Keywords
Classification	Keyword
OFICIAL	Informatics Engineering

Instance: 2021/2022 - 2S

Active?	Yes
Responsible unit:	Department of Informatics Engineering
Course/CS Responsible:	Master in Biomedical Engineering

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
MEB	11	Syllabus	1	-	6	39	162

Teaching language

Portuguese
Obs.: Materiais em Inglês

Objectives

This course has as main objective to provide the knowledge and practice of the planning and design of an information system, specially its data component representation and organization.  The understanding and efficient use of the data relational model and its implementation in a database management system belong also to the course objectives.

Another objective is the knowledge and practice of building adequate user interfaces capable of supporting the business processes underlying the information system. That interface should execute the flow of a business process through the normal search, update, create and eliminate data operations.

Learning outcomes and competences

After this course, the students should be able to analyze and model business processes and their requirements in terms of data and information, and also design and build an efficient relational database schema from it.

Another result should be the capacity to design and implement web interfaces in a simple server technology, and the database manipulation operations identified as requirements in the business process model.

Upon completing this course, students should be able to:

• Identify the requirements of an information system
• Design the data model of an information system using UML class diagrams
• Transform an UML class diagram into a relational model
• Create and explore a database using a relational database management system
• Querying the database in SQL
• Design and implement a user interface in HTML 5
• Use the PHP scripting language and some of its libraries to build the user interface and business logic of the web application
• Define presentation styles through the use of CSS
• Understand the issues involved in the development of recommender systems for web applications
• Use the Git version control system to collaborate efficiently within a team of developers
• Deploy and execute a web application using a Docker container

 

Working method

Presencial

Program

1. UML class model:




• Information systems modeling;


• Classes, Associations and Attributes




2. Relational model:




• From the UML class model to the relational model;


• Relations and constraints.




3. The SQL language:




• Database definition;


• Database querying;


• Database manipulation.




4. Database management systems;


5. Web information systems;


6. Client-side web languages:




• Web page structure using HTML;


• Web page design using CSS.




7. Server-side scripting language: PHP.


8. Features of the Git Version Control System


9. Basic features of the Docker container management system


10. Pratical application:




• Analysis, design and implementation of a web-based information system.

Mandatory literature

Ramakrishnan Raghu; Database Management Systems. ISBN: 0-07-115508-2
Silberschatz Abraham; Database system concepts. ISBN: 0-07-114810-8

Complementary Bibliography

Jon Loeliger, Matthew McCullough; Version Control with Git, 2nd Edition. ISBN: 978-1-44931-638-9
Ullman Jeffrey D.; A First Course in Database Systems. ISBN: 0-13-8687647-9
Adrian Mouat; Using Docker: Developing and Deploying Software with Containers. ISBN: 978-1-49191-576-9

Comments from the literature

.

Teaching methods and learning activities

• Lectures: presentation of concepts to be discussed, followed by presentation and discussion of practical examples.


• Practical classes: practical exercises and support to the development of the project.


• Evaluation: project and exam.

Software

SQLite
PHP
Docker
Git

keywords

Physical sciences > Computer science > Database management
Technological sciences > Technology > Internet technology
Technological sciences > Technology > Information technology

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Designation	Weight (%)
Exame	50,00
Trabalho prático ou de projeto	50,00
Total:	100,00

Amount of time allocated to each course unit

Designation	Time (hours)
Elaboração de projeto	15,00
Estudo autónomo	50,00
Frequência das aulas	39,00
Trabalho laboratorial	58,00
Total:	162,00

Eligibility for exams

• Complete and present the project, obtaining a minimum final grade of 8 (out of 20). The project comprises two different deliveries:




• 30%: report containing the UML and relational models


• 70%: implementation of a website using HTML, CSS and PHP




• A minimum grade of 8 (out of 20) on the written exam

Calculation formula of final grade

0.5 * Project + 0.5 * Exam

Project - Final grade of the project
Exam - Grade of the written exam

Special assessment (TE, DA, ...)

The project is mandatory and must be completed and presented before the deadlines set for the course. The written exam is also mandatory following regular established rules.

Students with worker statute (or equivalent) dismissed from attending the classes should, at a frequency agreed with the teachers, present the evolution of their project and perform the final presentation together with the regular students and take the individual written exam.

Classification improvement

The written exam grade can be improved following the general rules.
The project, due to its extension, can be improved on the next ocorrence of the course.