SQL Pet Database

📌 Project Overview

The SQL Pet Database is a relational database system designed to efficiently manage pet boarding service records. This project ensures structured data storage, quick retrieval of pet records, and optimized query performance for seamless operations.

🚀 Features

• Relational Database Design: Implements normalized tables for pets, owners, bookings, and staff.
• Efficient Query Performance: Optimized queries reducing execution time by 50%.
• Data Integrity & Security: Uses constraints, indexing, and stored procedures to maintain accuracy and prevent unauthorized access.
• Automated Data Processing: Includes stored procedures and triggers to manage check-ins, check-outs, and billing automatically.
• Scalable Data Management: Handles 100+ pet records, allowing easy data import/export.

🔧 Technologies Used

• Database: MySQL
• Query Language: SQL
• Indexing & Optimization: Normalization, Indexing, Stored Procedures
• Security Measures: Access Control, Data Validation

📂 Database Schema

1. Pets Table: Stores pet details (ID, Name, Species, Breed, Age, Owner ID).
2. Owners Table: Manages pet owners (ID, Name, Contact Info).
3. Bookings Table: Tracks pet boarding schedules (Booking ID, Pet ID, Check-in/out Dates, Cost).
4. Staff Table: Logs employees handling the pets (Staff ID, Name, Role).

🛠️ Installation & Setup

1. Install MySQL on your system.
2. Clone this repository:

   git clone https://github.com/GoodEvening07/SQL-Pet-Database.git