Information Systems and Databases

Code:

EEC0044

Acronym:

SIBD

Keywords
Classification	Keyword
OFICIAL	Informatics

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 Electrical and Computers Engineering

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
MIEEC	41	Syllabus	4	-	6	56	162

Teaching language

Portuguese

Objectives

The goal is to give students the ability to design and develop web-based information systems supported by Relational Database Management Systems.

Learning outcomes and competences

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

• UML class model;


• Relational model;


• SQL;


• SQLite;


• Advanced database topics: triggers, indexes and transactions;


• Web-based information systems;


• Client languages: HTML, CSS;


• Server scripting languages: PHP;


• Git Functionality


• Basic concepts of Docker

Mandatory literature

Raghu Ramakrishnan, Johannes Gehrke; Database management systems. ISBN: 0-07-116898-2
Abraham Silberschatz, Henry F. Korth, S. Sudarshan; Database system concepts. ISBN: 978-007-128959-7

Complementary Bibliography

Jeffrey D. Ullman, Jennifer Widom; 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
Jon Loeliger, Matthew McCullough; Version Control with Git, 2nd Edition. ISBN: 978-1-44931-638-9

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

Git
SQLite
PHP
Docker

keywords

Physical sciences > Computer science > Informatics

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Designation	Weight (%)
Exame	50,00
Participação presencial	0,00
Trabalho laboratorial	50,00
Total:	100,00

Amount of time allocated to each course unit

Designation	Time (hours)
Elaboração de projeto	75,00
Estudo autónomo	31,00
Frequência das aulas	56,00
Total:	162,00

Eligibility for exams

The distributed evaluation consists of:

• laboratory work group (2 elements) with 2 deliveries (1st: Report containing the UML model and Relational Model. 2nd: Implemented website) 

The final exam containing questions about:

• Modeling using UML
• Passage to the relational model
• Relational algebra
• SQL
• PHP
• Advanced database topics

• To achieve approval, the student must attain at least 40% in each of the evaluation components.

 

Calculation formula of final grade

The final score is the sum of:

• Implementation of information system (10 points: 3 points for UML and Relational Model + 7 points for the website)
• Final Exam (10 points)

 

Special assessment (TE, DA, ...)

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 distributed evaluation can be improved in the next edition of the course.