vet-clinic-db project (Module 4)

vet-clinic-db project

📗 Table of Contents

• 📖 About the Project
  • 🛠 Built With
    • Tech Stack
    • Key Features
• 💻 Getting Started
  • Prerequisites
  • Setup
  • Create database
• 👥 Author
• 🔭 Future Features
• 🤝 Contributing
• ⭐️ Show your support
• 🙏 Acknowledgements
• ❓ FAQ
• 📝 License

📖 Vet Clinic

Vet Clinic is a project to create data structure for a vet clinic using a relational database. It implements PostgreSQL and contains all the data about animals. The complete database contains tables with data about: [] animals [] animals' owners [] clinic employees [] visits

🛠 Built With

Tech Stack

Client

• PostgreSQL

Key Features

• Create a database to store animals' information
• Insert some data into table, and query it

(back to top)

💻 Getting Started

Prerequisites

In order to run this project you need:

• PostgreSQL server installed and running
• psql installed

Setup

Clone this repository to your desired folder:

git clone https://github.com/MMGGYY66/vet-clinic-db.git
cd vet-clinic

Create database

1. Connect to your PostgreSQL server with psql

> psql
postgres=#

2. Create the database vet_clinic

postgres=# CREATE DATABASE vet_clinic;
CREATE DATABASE

3. Connect to your database vet_clinic. Inside your current session do:

postgres=# \c vet_clinic
You are now connected to database "vet_clinic" as user "postgres".
vet_clinic=#

That's it! Congratulations, you have created your database and connected to it. Next, we will add a table.

• 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

👤 Mohamed Gamil Eldimardash

• GitHub: @github
• LinkedIn: LinkedIn
• Twitter: twitter
• Facebook: facebook
• StackOverflow: stackoverflow

👤👤 Lucas Comamala

• GitHub: @lucascomamala
• LinkedIn: Lucas Comamala

(back to top)

🔭 Future Features

• Insert new data
• Update existence data
• Delete existence data

(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 start if you like this project!

(back to top)

🙏 Acknowledgments

• I would like to thank the Microverse Team!
• I would like to thank All my partners!

📝 License

This project is MIT.

(back to top)