This repository includes files with plain SQL that can be used to recreate a database:
- Use schema.sql to creat 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!
[] is a database to create a data structure for a vet clinic. The database includes tables for animals, animal owners, clinic employees, and visits. These tables store comprehensive information about each aspect, such as animal details, owner information, employee data, and visit records. This database facilitates efficient management, organization, and analysis of information, enabling better care and service for animals and their owners.
Database
- [store comprehensive information about animals]
- [unique Autoincrementing id for each animal]
- To install PostgreSQL, follow these steps:
Determine the appropriate installation method for your operating system. PostgreSQL supports various platforms, including Linux, macOS, and Windows. Visit the PostgreSQL website to find the installation method specific to your OS.
- For Linux:
sudo apt-get install postgresql
or
sudo yum install postgresql-server
or
sudo dnf install postgresql-server postgresql-contrib
Other distributions: Refer to the PostgreSQL documentation or consult your distribution's documentation for installation instructions.
- For Windows:
PostgreSQL Installer for Windows: Download the PostgreSQL Installer for Windows from the official website and run the installer. Follow the prompts and choose the components you want to install.
- For macOS
Homebrew: If you have Homebrew installed, use the following command:
brew install postgresql
PostgreSQL for macOS: Download the PostgreSQL package for macOS from the official website and follow the installation instructions.
During the installation process, you may be prompted to provide a password for the default PostgreSQL superuser (postgres). Choose a strong password and remember it for future use. After the installation is complete, PostgreSQL should be up and running as a service on your system. You can start and stop the service using the provided tools or by using the system services manager.
Once PostgreSQL is installed, you can access it using the psql command-line tool or a graphical client.
To get a local copy up and running, follow these steps. Choose the directory on your local machine where you want to copy project. For example:
cd /home/user/name-of-your-directory
Clone the project using one of the options.
Using HTTPS:
git clone https://github.com/beteland123/vet-clinic.git
You can also create the new directory just adding the name of it in the end of command. For example:
git clone https://github.com/beteland123/vet-clinic.git vet-clinic
To create the PostgreSQL database and view its contents, follow the steps below:
-
Ensure that PostgreSQL is installed on your system and the PostgreSQL server is running.
-
Open a terminal or command prompt.
-
Run the following command to create the database:
psql -U <username> -c "CREATE DATABASE <database_name>;"
Replace with your PostgreSQL username and <database_name> with the desired name for your database.
- To view the contents of the database, use the following command:
psql -U <username> -d <database_name> -c "SELECT * FROM <table_name>;"
Replace with your PostgreSQL username, <database_name> with the name of your database, and <table_name> with the name of the table you want to view.
Mention all of the collaborators of this project.
👤 Micronaut JUAN DAVID DIAZ
- GitHub: @JuanDBta
- Twitter: @simplebetsas
- LinkedIn: LinkedIn
Describe 1 - 3 features you will add to the project.
- Add new tables & create relations between
- Add schema diagram
Contributions are welcome! If you have any ideas, improvements, or bug fixes, please open an issue or submit a pull request. For major changes, please discuss them with the project maintainers first.
Write a message to encourage readers to support your project
If you like this project, please give a ⭐️ (Thank you)
Give credit to everyone who inspired your codebase.
-
I would like to thank Microverse for this learning opportunity.
This project is MIT licensed.