/the_oscar_archives

A MySQL-powered database management with Python integration. Features normalization, ER modeling, and CRUD operations for efficient data handling. Includes SQL scripts for schema creation and Python scripts for data manipulation and analysis. Ideal for learning database design, SQL proficiency, and Python data handling in a real-world context

Primary LanguagePython

The Oscars Archives

Explore The Oscars DBMS project, a MySQL-powered database management system with Python integration. This project focuses on efficient data handling through normalization, ER modeling, and CRUD operations. It includes SQL scripts for schema creation and Python scripts for data manipulation and analysis.

Features

  • Normalization: Ensures efficient data storage.
  • ER Modeling: Visualizes database structure.
  • CRUD Operations: Manage data effectively.
  • Python Integration: Scripts for data manipulation and analysis.

Instructions

  1. Clone the repository.
  2. Set up MySQL and execute SQL scripts.
  3. Run Python scripts for data operations and analysis.