Information Systems Engineering

Code:

EBE0061

Acronym:

ESIN

Keywords
Classification	Keyword
OFICIAL	Biomedical Engineering

Instance: 2019/2020 - 1S

Active?	Yes
Web Page:	https://silvae86.github.io/teaching/2020/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	11	Syllabus	1	-	6	56	162
MIB	23	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.

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. Pratical application:




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

Mandatory literature

Ramakrishnan Raghu; Database Management Systems. ISBN: 0-07-115508-2

Complementary Bibliography

Ullman Jeffrey D.; A First Course in Database Systems. ISBN: 0-13-8687647-9
Silberschatz Abraham; Database system concepts. ISBN: 0-07-114810-8

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

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.

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.