Information Systems Engineering

Code:

EBE0061

Acronym:

ESIN

Keywords
Classification	Keyword
OFICIAL	Biomedical Engineering

Instance: 2020/2021 - 1S

Active?	Yes
Web Page:	https://silvae86.github.io/teaching/2021/ESIN_SIBD/esin/
Responsible unit:	Department of Informatics Engineering
Course/CS Responsible:	Master in Bioengineering

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
MEB	12	Syllabus	1	-	6	56	162
MIB	25	Syllabus	4	-	6	56	162

Teaching language

Portuguese

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

The students should be able to analyze and model business processes and its information needs and 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 needs 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
• Use relational algebra to formulate questions to a relational database
• Create and explore a database using the SQLite database management system
• Express questions to 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. The SQLite Database management system;


5. Advanced topics in databases:




• Triggers;


• Indexes;


• Transactions.




6. Web information systems;


7. Client-side Web languages:




• Web page structure using HTML;


• Web page design using CSS.




8. Server-side scripting language: PHP.


9. Features of the Git Version Control System


10. Basic features of the Docker container management system


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

Docker
Git
SQLite
PHP

keywords

Technological sciences > Technology > Internet technology
Technological sciences > Technology > Information technology

Evaluation Type

Distributed evaluation without final exam

Assessment Components

Designation	Weight (%)
Exame	50,00
Trabalho laboratorial	50,00
Total:	100,00

Amount of time allocated to each course unit

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

Eligibility for exams

Complete and present the Lab assignments.
A minimum grade of 8 (out of 20) in the written exam.

Calculation formula of final grade

0.5 * Assgn + 0.5 * Test
Assgn - Lab assignments grade (divided into 30% for a report containing the UML and relational models + 70% for a website implementation)
Test - Open book test examination grade

Special assessment (TE, DA, ...)

The same as for ordinary students. The assignments are mandatory and must be done and presented before the deadlines. Final is also mandatory.

Students with worker statute or equivalent should periodically get advice from the teachers concerning their progress, present them together with the regular students and take the minitests for the individual evaluation.

Classification improvement

The written exam grade can be improved following the general rules.
The Lab assignments, due to their extension, can be improved in the next curricular unit ocorrence.