Information Systems and Databases

Code:

EEC0044

Acronym:

SIBD

Keywords
Classification	Keyword
OFICIAL	Informatics

Instance: 2014/2015 - 1S

Active?	Yes
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	50	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 Management Systems Relational Databases.

Learning outcomes and competences

Upon completing this course, students should be able to:

• Identify the requirements of an information system

• Draw the conceptual schema of a database using the entity-relationship model

• Transform an entity-relationship diagram into a relational model

• Use relational algebra to formulate questions to a relational database

• Create and explore a database using the PostgreSQL database management system

• Express questions to the database in SQL

• Draw the user interface in XHTML

• Use the PHP scripting language and some of its libraries to build the user interface and business logic of the application Web

• Define presentation styles through the use of CSS
• Understand the issues involved in the development of recommender systems for web applications

 

Working method

Presencial

Program

 

• ⁃entity-relationship model;

• relational model;

• relational algebra;

• SQL;

• PostgreSQL;

• Advanced database topics: triggers, indexes and transactions;

• Web-based information systems;

• client languages: HTML, CSS, Javascript;

• server scripting languages: PHP;
• Recommender systems.

 

Mandatory literature

Raghu Ramakrishnan, Johannes Gehrke; Database management systems. ISBN: 0-07-116898-2

Complementary Bibliography

Jeffrey D. Ullman, Jennifer Widom; A First Course in Database Systems. ISBN: 0-13-8687647-9
Abraham Silberschatz, Henry F. Korth, S. Sudarshan; Database system concepts. ISBN: 978-007-128959-7

Teaching methods and learning activities

 

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

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

• Evaluation: project and exam.

 

Software

PHP
PostgreSQL

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 escrito	13,00
Trabalho laboratorial	37,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 3 deliverables

The final exam containing questions about:

• Modeling using the entity-relationship model

• Passage to the relational model

• Relational algebra

• SQL

• Advanced database topics

 

Calculation formula of final grade

The final score is the sum of:

• Requirements Report (2.5 points)

• Architecture Report (2.5 points)

• Implementation of information system (5 points)

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