Veterinarian Data Base using Postgress is a project that uses a data base to store information about veterinarians and their patients. Using postgress, the data base is set up and queries are used to filter the data.
Database
- Updated Vet Data Base
- Queries to filter from data set
- Schema for the data set
- Use primary key & foreign key mechanism for joining tables.
- Query multiple tables.
- Prepare complex queries that answer analytical questions.
- Use aggregate functions to answer analytical questions.
- Use subqueries to answer analytical questions.
- Understand the different types of relationships between tables.
- Prepare complex queries that answer analytical questions.
- Use primary key & foreign key mechanism for joining tables.
To get a local copy up and running, follow these steps.
PostgreSQL Installation: You need to have PostgreSQL, a popular open-source relational database management system, installed on your computer. You can download and install PostgreSQL from the official PostgreSQL website.
Clone this repository to your desired folder.
Install this project with PostgreSQL.
To run the project:
- Use schema.sql to create all tables.
- Use data.sql to populate tables with sample data.
- Check queries.sql.
👤 Glauber Bannwart
- Update Vet Data Base
- Improve Queries
- Add/Delete data base table rows
- Add/Delete data base constraints
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
If you like this project star it! ⭐️
I would like to thank microverse for this learning opportunity.