This repository includes files with plain SQL that can be used to recreate a database:

• Use schema.sql to create all tables.
• Use data.sql to populate tables with sample data.
• Check queries.sql for examples of queries that can be run on a newly created database.

Important note: this file might include queries that make changes in the database (e.g., remove records). Use them responsibly!

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

The Clinic Database is a simple database that stores information about the animals in the vet.

The three key features of this project include the following.

• Query and update the paitents table.
• Record of all patients
• Query multiple tables.
• Add "join table" for vists.

(back to top)

Get ready to explore Clinic Database with these steps:

Schema Diagram

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

In order to run this project you need: PostgreSQL

Clone this repository to your desired folder:

  cd my-folder
  git clone git@github.com:katarighe/clinic_database.git

Install this project with: Install PostgreSQL

To run the project, execute the following command:

• Start the PostgreSQL server
• Run psql
• Create the database with: CREATE DATABASE clinic;
• Connect to the database with: \c clinic
• Create the tables with the queries from schema_based_on_diagram.sql

To run tests, run the following command: Not available

You can deploy this project using: Not available

(back to top)

👤 Mohamed Aden Ighe

• GitHub: @katarighe
• Twitter: @katarighe
• LinkedIn: @mighe

👤 Noel Nomgne Foka

• GitHub: @noelnomgne
• Twitter: @noelnomgne
• LinkedIn: @noelnomgne

(back to top)

Here are some future features that could be added to the Clinic Database in the future.

• User authentication and authorization: This would allow users to create accounts, sign in and out, and have their own personal items.

These are just a few ideas for future features that could be added to the Clinic Database. The specific features that are added will depend on the needs and wants of the users.

(back to top)

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

(back to top)

Give a star⭐️ or a thumbs up 👍 if you like this project! You can visit my GitHub profile for more of my projects.

(back to top)

• Project supervised by Microverse
• Creative Commons 4.0 License

(back to top)

This project is MIT licensed.

(back to top)