Managing Data in Databases: SQL Queries, Normalization and Design

This assignment focuses on managing data in databases, covering SQL queries, database normalization, and database design using MS Access. It includes creating a database structure, populating tables, and writing SQL queries to retrieve specific data, such as movie titles released after 2017 or horror movies. The assignment also delves into functional dependencies, normalization up to 3NF, and examples of insertion and deletion anomalies. Furthermore, it discusses the benefits of using a data warehouse for business and outlines the key responsibilities and skills required for a database developer. The project successfully implements a database for a quiz and MovieDB, demonstrating the ability to store and retrieve information efficiently, manage data in real-time, and eliminate redundancy through normalization.