Personality Prediction Database (MySQL)

A structured and normalized MySQL database for behavioral analytics and personality classification (Introvert vs. Extrovert). Designed to support data science and machine learning workflows.

Database Schema

• person: Personal info (name, gender, age)
• behavior: Psychological traits (talkative, empathy, etc.)
• personality_label: Final personality classification

Technologies Used

• MySQL
• Power BI (ER Diagram)
• SQL (DDL & Constraints)

ER Diagram

ER diagram created using Power BI:

Files

• schema.sql: SQL script to create and define tables
• personality_dataset_synthetic.csv: Synthetic dataset for testing

Project Purpose

This database helps:

• Behavioral scientists explore trait correlations
• Data scientists prepare labeled datasets for personality prediction
• Dashboards to monitor behavioral patterns