Database

Syllabus: 

Entity-Relationship Model. Entity types, entity sets and key attributes. Types of relationships, roles and structural constraints. Entity-Relationship Diagram. Relational Data Model. Key attributes of a relationship. Relational Database Schema and Integrity Constraints. Formal Consultation Languages: Relational Algebra. The SQL language. NoSQL databases. RDF Databases. Manipulation of publicly available databases.

Bibliography

Mandatory: 

•    KORTH, H. F .; SILBERSCHATZ, A .; SUDARSHAN, S .. Database system. 5th ed., Campus, 2006.
•    HEUSER, Carlos Alberto. Database Project. 6th Ed., Bookman, 2008.
•    GARCIA-MOLINA Hector, ULLMAN, Jeffrey D., WIDOM, Jennifer. Data base.

Complementary: 

  • ELMASRI, R.; NAVATHE, S. B.. Sistemas de Banco de Dados. 4a ed., Pearson-Addison-Wesley, 2005.
  • DATE, C. J.Introdução a Sistemas de Banco de Dados. Elsevier Editora, 2004.
  • GARCIA-MOLINA Hector, ULLMAN, Jeffrey D., WIDOM, Jennifer. Database
  • Systems: the complete book. 2a ed., Prentice Hall, 2008.
  • RAMAKRISHNAN, R.; GEHRKE, J.Sistemas de Gerenciamentos de Bancos de Dados. 3a ed., McGraw Hill Brasil, 2008.