Database
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. Data access via API.
Basic Information
Workload
60 hours
Requirements
Introduction to Computing
Mandatory:
- DATE, C. J. Introduction to Database Systems. Elsevier Editora, 2004.
- HEUSER, Carlos Alberto. Database Project. 6th Ed., Bookman, 2008.
- GARCIA-MOLINA Hector, ULLMAN, Jeffrey D., WIDOM, Jennifer. Data base Systems: the complete book. 2a ed 2014.
Complementary:
- Marz, Nathan; W, James. Big data: Principles and best practices of scalable realtime data systems. 2015. Manning Publication
- RAMAKRISHNAN, R .; GEHRKE, J. Database Management Systems. McGraw Hill Brasil, 2008.
- Silberschatz, A .; Korth, H. F. Sudarshan, S. Database System. Elsevier, 2012.
- Silberschatz, A .; Korth, H. F. Sudarshan, S. Database system concepts. 6th ed. 2011.
- Neves, Júlio Cezar. Shell Linux programming. 2017.