kal2944/VetClinicDatabase

📗 Table of Contents

• 📖 About the Project

  • 🛠 Built With
    • Tech Stack
    • Key Features

• 💻 Getting Started

  • Setup
  • Prerequisites
  • Install
  • Usage
  • Run tests
  • Deployment

• 👥 Authors

• 🔭 Future Features

• 🤝 Contributing

• ⭐️ Show your support

• 🙏 Acknowledgements

• 📝 License

📖 Vet Clinic Database

demonstrated the use of PostgreSQL commands for tasks such as creating a database and table, inserting data into the table, and executing various queries with different parameters.

• Commit transactions
• roll back
• Save point with commit
• Answering with quries

🛠 Built With

• Sql shell (psql) and pgAdmin

Tech Stack

PostgreSQL

Database

• PostgreSQL

Key Features

• Vet clinic database
• animals table
• animals data
• Querying data

(back to top)

(back to top)

💻 Getting Started

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

  git clone https://github.com/habasm/VetClinicDatabase.git
  cd vet_clinic_database

Prerequisites

In order to run this project you need installed postgresql and pgAdmin.

Setup

Clone this repository to your local machine and run sql commands in the terminal or pgAdmin.

Install

  locate to your postgresql folder

Usage

To run the project, execute the following command:

  1 create vet_clinic database
  2 Run  schema.sql
  3 to insert data into the table run data.sql
  4 execute queries

Run tests

no test for this project,

Deployment

no deployment for this project

(back to top)

👥 Authors

👤 HABASM

• GitHub: habasm
• Twitter: @habasm
• LinkedIn: HABASM

👤 Kalkidan Daniel

• GitHub: @kal2944
• Twitter: @Kalkida01088197
• LinkedIn: Kalkidan Daniel

(back to top)

🔭 Future Features

to be Added related animal tables and queries

(back to top)

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

(back to top)

⭐️ Show your support

Give a ⭐️ if you like this project!

(back to top)

🙏 Acknowledgments

I would like to thank microverse community for the support and guidance.

(back to top)

📝 License

This project is MIT licensed.

(back to top)

#