Database Systems

The theoretical exposure precedes the practical thus giving the necessary structure to knowledge acquisition by foliar spraying practices. All material of theoretical and practical components is available on an electronic platform and the bibliography where are the links to the examples, case studies, the authors adopted.

Provide students the basic concepts of databases so that it can analyze, model, design and devise a system of Databases.
Thus the stage of data models the student should be able to implement the entity-relationship model and adapt it to different realities and restrictions thereof. Learn to structure a database according to the relational model and perform all operations of relational algebra associated with this model. Designing Databases using UML modeling language.
In the second phase, the relational databases require three basic themes viz. The language SQL (Structured Query Language) as a reference for any management system database. Aspects relating to the security and integrity of databases, including referential integrity and protection aspects and access to stored data. Finally the design phase of the database according to the theory of normalization. 

1. Introduction.
2. Data Models
2.1. The entity-relationship model.
2.2. The relational model.
2.3. Relational algebra and calculus.
3. Relational Databases
3.1. SQL (Structured Query Language).
3.2. Integrity and security.
3.3. Draft relational databases.
4. Databases and Object-Oriented Object-Relational.
5. Transaction management.
6. Concurrency and distribution in Databases.
7. Web Databases and XML

NAO