DataBase Management Systems

Objectives

This unit intends to introduce the methods and techniques used to the analysis and design of Databases, which are adapted to the organization¿s activities. The following aspects are considered fundamental:

-Acquire knowledge about the use of Databases. -Acquire knowledge on the use Database Management Systems which improves organization performance. -Giving students the necessary background to design, build and analyse relational databases.

At the end of this unit the student should be able to:

LO1-Understand the main architectures and concepts of database management systems

LO2-Getting to know the Entity-Relationship model and the relational data model

LO3-Learning the basics of SQL (as a language for defining and manipulating data)

LO4-Understanding the normalization of databases based on functional and multivalue needs

LO5-Knowing how to formulate complex questions in SQL

LO6-Understand the main challenges posed to database construction

General characterization

Code

200032

Credits

7.5

Responsible teacher

Vítor Manuel Pereira Duarte dos Santos

Hours

Weekly - Available soon

Total - Available soon

Teaching language

Portuguese. If there are Erasmus students, classes will be taught in English

Prerequisites

Bibliography

- Thomas M. Connolly and Carolyn E. Begg, Database Systems:a Practical Approach to Design, Implementation, and Management, Addison-Wesley, Pearce Education Limited, 2010

- Abraham Silberschatz, Henry F. Korth and S. Sudarshan, Database System Concepts, McGraw-hill, 2006

- Pereira, José Luis (1998) 'Tecnologia de Base de Dados, 3ª Ed.', FCA

-Damas, Luís Manuel Dias (1999) 'SQL, 6ª Ed.', FCA

-Ramakrishnan, Raghu, e Gehrke, Johannes (2003) 'Database Management Systems, 3rd ed.', McGraw-Hill

-O'Neil, Patrick e O'Neil, Elizabeth (2001) 'Database:Principles, Programming, and Performance, 2nd Ed.', Morgan Kaufmann Publishers

-Date, C. J. (2004) 'An Introduction to Database Systems', Addison Wesley Longman, Inc.

-Post, Gerald V. (1999) 'Database Management Systems - Designing and Building Business Applications', McGraw-Hill International Editions

Teaching method

Teaching based on lectures and practical classes. The lectures are, in essence, for expository sessions, which serve to introduce the fundamental concepts of databases associated with each of the topics. The practical classes are based on design and implementation of database systems, using the computers and software

Teaching Methods -Expository and interrogative teaching:lectures and discussions. -Declarative:tutorials tools -Active and participative:case studies, participation in project teams, use of database management systems

Evaluation method

Evaluation:

1st round:Two Theoretical tests (60%) + Practical Works (40%)

2nd round:final exam (100%)

Subject matter

LU1-Introduction

LU2-The Database Management System

LU3-Architecture and concepts

LU4-Relational Algebra

a.Concepts

b.Standardization

c.Relational Languages

d.SQL Language (Structured Query Language) e.Processing and Optimizing Questions

LU5-Relational Model

a.Basic features

b.Tables and relationships

c.Referential integrity and entity integrity

LU6-Data modeling using the ER model

a.Logical and Physical model

b.Normalization

c.Conceptual model - Entity-Relationship Model) - Object oriented model

LU7-Introduction to Programming with SQL (basic level)

a.Designing the frame of business applications

b.SQL as a programming language

c.Elements of the SQL language

d.Additional elements of the SQL language e.Ways of executing SQL instructions

LU8-Draft a database using the relational model

LU9-SQL language (Advanced)

LU10-Need for new models

a. Extensions to the relational model

b. Model logical/deduc

Programs

Programs where the course is taught: