/Vet-clinic-database

A vet clinic database project that covers the creation of tables, SQL queries, and performance audits. It's designed to manage data about animals, owners, employees, and visits. Explore the database schema diagram for insights into efficient clinic operations.

Primary LanguagePLpgSQLMIT LicenseMIT

📗 Table of Contents

📖 Vet clinic

Vet Clinic Database Project This project involves the creation of a PostgreSQL database named "vet_clinic" and the design of a table called "animals" with various attributes to store information about the clinic's patients. Additionally, data is inserted into the table to represent a sample of animals with unique characteristics.

Project Components: Schema Definition (schema.sql): The database schema is defined with the table structure, including columns such as id, name, date_of_birth, escape_attempts, neutered, and weight_kg.

Data Insertion (data.sql): Sample data is inserted into the "animals" table, representing four unique animals, each with its own set of attributes.

SQL Queries (queries.sql): A series of SQL queries are crafted to answer specific questions or "quests" related to the animals in the database. These queries extract valuable insights from the data.

Quests: The queries include tasks such as finding animals by name patterns, birth years, neutered status, escape attempts, weight ranges, and more.

Query Results: Screenshots of the results obtained from executing the SQL queries are included in the project to visually demonstrate the outcome of each quest.

This project is a practical exercise in working with databases, SQL, and data retrieval. It showcases the ability to design a database schema, populate it with data, and extract meaningful information through structured queries.

🛠 Built With

Tech Stack

Database

Key Features

  • [Structured Database: Designed a well-organized PostgreSQL database called "vet_clinic" with a clear schema.]
  • [Realistic Data: Populated the database with sample data that reflects actual animal clinic scenarios.]
  • [Practical SQL Queries: Created SQL queries to extract specific information from the database, providing hands-on experience in database interaction and data retrieval.]

💻 Getting Started

To get a local copy up and running, follow these steps.

Prerequisites

In order to run this project you need:

Setup

Clone this repository to your desired folder:

Install

Install this project with:

Usage

To run the project, execute the following command:

Run tests

To run tests, run the following command:

Deployment

You can deploy this project using:

(back to top)

👥 Authors

👤 Hafizullah Rasa

(back to top)

🔭 Future Features

  • [Add more animals database]
  • [Easy data retrieval]
  • [Efficient data management]

(back to top)

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

(back to top)

⭐️ Show your support

If you like this project, star the project if you like it

(back to top)

🙏 Acknowledgments

I would like to thank my mentor and my cod partners for support

(back to top)

📝 License

This project is MIT licensed.

(back to top)