Safari Zoo Database Project 🦁

This project is a relational database designed for managing and analyzing information in a safari zoo setting. It was developed as part of an academic course in SQL and database systems.

📁 Contents

• SQLQuerySafari.sql: Contains the full SQL script, including:
  • Schema creation (tables and relationships)
  • Data insertion (animals, habitats, visitors, etc.)
  • Constraints and keys (primary, foreign)
  • Complex queries for reporting and analysis

🧠 Project Goals

• Practice writing advanced SQL queries
• Understand data modeling and normalization
• Demonstrate the use of constraints and relationships in real-world scenarios
• Generate analytical insights from structured data

🛠️ Technologies Used

• Microsoft SQL Server Management Studio (SSMS)
• T-SQL (Transact-SQL)

📚 Use Case Examples

• Track animal habitats and caretakers
• Manage visitor tickets and schedules
• Generate reports on species population and rare animals
• Analyze visitor engagement and peak hours

📌 Notes

• The database was designed following best practices in relational modeling.
• All data is fictional and used for educational purposes only.

---