lnvaldez/pokemon-database

A comprehensive SQL-based project for managing a Pokémon database. Includes scripts for creating, reading, updating, and deleting trainers, Pokémon, battles, and trainer-Pokémon relationships.

🔴 Pokémon-Database ⚪

SQL scripts to create and manage a Pokémon database. The database includes tables for trainers, Pokémon, and battles, along with relationships between trainers and Pokémon. The repository also includes various SQL queries to interact with the data.

🔑 Database Schema

⚙️ CRUD

➕ Create

• Add trainers
• Add pokemon
• Add battles
• Add trainer-pokemon relationship

📖 Read

• Retrieve all pokemon and trainers
• Retrieve a trainer's pokemon
• Retrieve all trainers
• Retrieve a battle

☝️ Update

• Update trainer data
• Update pokemon data
• Update battle data

❌ Delete

• Delete trainer records
• Delete pokemon records
• Delete trainer-pokemon relationship
  

---

Icons by TheArtificial