1. Home
  2. NOVA Information Management School
  3. Post-Graduation in Marketing Intelligence
  4. Data Management and Storage

Data Management and Storage

Objectives

1. Explain what a Database is and the challenges in their design and implementation
2. Understand the main concepts and architectures of Database Systems
3. Explain the relational data and Use Entity-Relationship Models for Data Modeling
4. Explain and Apply Data Normalization (3-Normal Forms)
5. Understand and Explain the main concept behind SQL languages
6. Perform basic SQL operations (Create, Read, Update, and Delete)
7. Perform complex SQL operations (Joins, Sorting, and Grouping)
8. Create Views, Triggers, and Schema Modification
9. Understand the CAP theorem and Identify databas e management systems for distributed systems and big data

General characterization

Code

200193

Credits

4.0

Responsible teacher

Docente a designar

Hours

Weekly - Available soon

Total - Available soon

Teaching language

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

Prerequisites

  

Bibliography

- Elmasri, Ramez, and Sham Navathe. Fundamentals of database systems. London: Pearson, 2016
- Selected book chapters and articles shared by the teaching staff.

Teaching method

The curricular unit is based on a between Lectures and Labs and counts with a strong active learning component. During each session, students are exposed to new concepts and methodologies, case studies and the resolution of examples.
Active learning activities ¿ debates, quizzes, mud cards, compare and contrast, among others ¿ will place students at the center of the classroom, so that he/she takes an active role in the discussion and in the learning process. During the Lab classes students will have the opportunity to practice in the computer the new knowledge with the guidance of an instructor.
 

Evaluation method

Evaluation Elements:
- Participation in c lassroom activities and (35%)
- Homework Assignments (25%)
- Final Project with oral presenta tion and written report (40%)

Subject matter

1. Introduction to Database Management Systems
2. Data Modeling and Database Design
3. Relation Data Model and SQL
4. Introduction to Distributed Systems