Manufacturing Production Data Analysis (SQL)

Project Overview

This project demonstrates the use of SQL in managing and analyzing production data within a manufacturing environment. It focuses on tracking machine performance, shift productivity, and scrap rates to drive data-informed decisions in production engineering.

Key Features

• Database Schema: Design of relational tables for Machines, Production Logs, and Maintenance Schedules.
• Performance Metrics: SQL queries to calculate Scrap Rate and Machine Downtime.
• Production Optimization: Identification of low-performing shifts and bottlenecks.

Technologies Used

• SQL (PostgreSQL / MySQL)
• Relational Database Design

Example Query

The project includes a core query that joins production logs with machine data to provide a comprehensive efficiency report.