Databases (10640)

http://ssdi.di.fct.unl.pt/bd/

To provide the basis for the modeling, implementation, analysis and manipulation of relational databases.

Objectives

Knowledge

To know the entity-relationship model and the relational data model, as well as the foundations of the object-relational model
Relational algebra as the formal language of relational data base querying and manipulation
Foundations of the SQL language (both as a definition and as a manipulation language)
Normalization of data bases using functional and multi-valued dependencies
Brief overview of data modeling in XML and manipulation mechanisms for semi-structured data

Know-how

To model a medium sized real problem first using Entity-Relationship Diagrams and then a relational database (the resulting data base should have 10 to 20 tables)
To create a database in SQL for the medium-sized problem, including implementation of all mechanisms for guaranteeing referential integrity
To implement a simple interface for manipulation of the database
To be proficient in writing complex SQL queries
To use the basic object-relational mechanisms of SQL

Soft-Skills

Introduction to Database Management Systems
Data models
- Entity-Relationship model
- Relational model
Relational databases normalization
- Functional and multi-valued dependencies
- Normal forms: 3rd, 4th andBoyce-Cood
Database manipulation languages
- Relational Algebra
- SQL query and manipulation language
- Other languages
Database integrity
- Referential integrity
- Assertions andtriggers
Interaction with databases
- Embedded SQL, ODBC, JDBC
- Security and authorisations
- Transactions
Discussion about other database models
- Object/relational databases (and the SQL case).
- Deductive databses
- XML

Recommended book

Database System Concepts, 5th Edition.
Abraham Silberschatz, Henry F. Korth and S. Sudarshan
McGraw Hill, 2005
ISBN 0-07-295886-3
or
Database System Concepts, 4th Edition
Abraham Silberschatz, Henry F. Korth and S. Sudarshan
McGraw Hill, 2001
ISBN 0-07-255481-9
Alternatively, you may use the previous edition (which does not contain the final part of the syllabus - XML) :
Database System Concepts, 3rd Edition
Abraham Silberschatz, Henry F. Korth and S. Sudarshan
McGraw Hill, 1997
ISBN 0-07-044756-X

Slides and exercises

After each class the sldes and exercises will be made available online in the course''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''s web page.

Complemetary readings

A Guide to the SQL Standard (4th Ed)
C. J. Date and Hugh Darwen
Addison-Wesley
ISBN:0-201-94426-0
The theory of Relational Databases
David Maier
Computer Science Press
ISBN:0-914894-42-0
Database Management Systems
Raghu Ramakrishnan and Johannes Gehrke
McGraw Hill, 2000
An Introduction to Database Systems (6th Ed)
C. J. Date
Addison-Wesley,1994
ISBN:0-201-82458-2

	Hours per credit		28
	Hours per week	Weeks	Hours
Aulas prÃ¡ticas e laboratoriais			26.0
Aulas teÃ³ricas			42.0
AvaliaÃ§Ã£o			4.0
Self study			60.0
OrientaÃ§Ã£o tutorial			2.0
Project			118.0
Total hours			252
ECTS			9.0