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
- 💻 Getting Started
- 👥 Authors
- 🔭 Future Features
- 🤝 Contributing
- ⭐️ Show your support
- 🙏 Acknowledgements
- 📝 License
[Vet Animals] is a SQL database to store, update & retrieve animals data from the PostgreSQL.
Database
- [Store animals data]
- [Update animals data]
- [Retrieve animals data]
To get a local copy up and running, follow these steps.
In order to run this project you need:
- PostgreSQL
- Version control system (Git preferred)
Clone this repository to your desired folder:
Example commands:
cd my-folder
git clone https://github.com/hmunish/vetDB.gitInstall this project by cloning the repository into the local machine.
To run the project, execute the following SQL queries into local database.
👤 Munish Halai
- GitHub: @githubhandle
- Twitter: @twitterhandle
- LinkedIn: LinkedIn
👤 Rabaya Rabu
- GitHub: @rabayarabu
- Twitter: @rabaya_rabu
- LinkedIn: LinkedIn
- [Searching_animals_data]
- [Deleting_animals_data]
- [Editing_animals_data]
Contributions, issues, and feature requests are welcome!
Feel free to check the https://github.com/hmunish/vetDB/issues.
If you like this project feel free to contribute so that we can improve the project.
I would like to thank the Microverse team to provide an installation guide for PostgreSQL.
This project is MIT licensed.