demesameneshoa/vet_clinic

This is a project for a Postgres database structured to record data of a vet clinic in a database

Vet_Clinic

📗 Table of Contents

• 📖 About the Project
  • 🛠 Built With
    • Tech Stack
    • Key Features
• 💻 Getting Started
  • Setup
  • Prerequisites
  • Install
  • Usage
  • Run tests
• 👥 Authors
• 🔭 Future Features
• 🤝 Contributing
• ⭐️ Show your support
• 🙏 Acknowledgements
• 📝 License

📖 [Vet_Clinic]

[Vet_Clinic] is a Postgres database structured to record data of a vet clinic in a database

🛠 Built With

Tech Stack

Database

• PostgreSQL

Key Features

• [Database Created]
• [Animals Table Created]
• [Data entered into the table]
• [Multiple data queries executed]
• [Updating data with transaction Rollback and Commit Executed]
• [Deleting data with transaction Rollback and Commit Executed]
• [Updating data with transaction savepoint Executed]
• [Querying table with aggregated response Executed]
• [Multiple tables added]
• [Primary Keys and Foreign Keys Deployed]
• [Data Inserted in multiple tables]
• [Tables linked with Foreign keys]
• [Querying Multiple tables using Join Executed]
• [Join Tables added for multiple tables]
• [Inserting Data into Join tables Executed]
• [Querying Data by using Join Tables Executed]
• [Bulk data recorded to measure performance audit]
• [Indexes added to table to improve the db performance ]

(back to top)

💻 Getting Started

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

Prerequisites

In order to run this project you need: Postgres Installed

Setup

Clone this repository to your desired folder:

  mkdir vet-clinic
  cd vet-clinic
  git clone git@github.com:demesameneshoa/vet_clinic.git

Install

No Installation Required

Usage

To deploy the database, execute shcema.sql, data.sql and queries.sql repectively in your psql shell

Run tests

No tests here

(back to top)

👥 Authors

👤 Author1

• GitHub: @demesameneshoa
• Twitter: @demesabera
• LinkedIn: Demes Ameneshoa

👤 Author2

• GitHub: @fmanimashaun
• Twitter: @fmanimashaun
• LinkedIn: Fisayo Michael Animashaun

(back to top)

🔭 Future Features

• [Relation Diagram]

(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 please show us support by givintg it a star.

(back to top)

🙏 Acknowledgments

I would like to thank my colleagues at Microverse for their support during the project.

(back to top)

📝 License

This project is MIT licensed.

(back to top)