📗 Table of Contents

• 📗 Table of Contents
• 📖 Vet Clinic Database
  • 🛠 Built With
    • Tech Stack
    • Key Features
  • 💻 Getting Started
  • 👥 Author
  • 🔭 Future Features
  • 🤝 Contributing
  • ⭐️ Show your support
  • 🙏 Acknowledgments
  • 📝 License

📖 Vet Clinic Database

Vet Clinic Database is a relational database focus project. Through this project, users can create, read, update and delete specific data form the database using sql queries in the terminal of command prompt.

🛠 Built With

Tech Stack

Database

• PostgreSQL

Key Features

• Users can create database table.
• Users can insert and update database table column.
• Users can read specific data with sql query

(back to top)

💻 Getting Started

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

• At first Clone this repository to your desired folder:

  cd my-folder
  git clone https://github.com/kennedyowusu/vet_clinic_database.git
  git clone https://github.com/kenendyowusu/vet_clinic_database.git

• To use this repo to your local computer make sure you have installed POSTGRESQL
• Then create a new database then open a sql editor or sql terminal then your can use below SQL language to read and update your database with multiple tables.
• 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.

(back to top)

👥 Author

👤 Kennedy OWUSU

• GitHub: kennedyowusu
• Twitter: @_iamkobby
• LinkedIn: kennedyowusu

(back to top)

🔭 Future Features

• Add Indexes to columns
• Make Views of tables
• Generate the ER diagrams of the tables

(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

Thanks to Microverse for giving me the opportunity to create such a project

(back to top)

📝 License

This project is MIT licensed.

(back to top)