/vet-clinic

Use a relational database to create the data structure for a vet clinic.

Primary LanguagePLpgSQLMIT LicenseMIT

curriculum-databases-projects-template

Getting Started

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!

📗 Table of Contents

📖 [VET-CLINIC-DB]

[] 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.

🛠 Built With

Tech Stack

Database

Key Features

  • [store comprehensive information about animals]
  • [unique Autoincrementing id for each animal]

(back to top)

Getting Started

Prerequisites

  1. 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.

  1. 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.

  1. 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.

  1. 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.

Setup

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

Usage

To create the PostgreSQL database and view its contents, follow the steps below:

  1. Ensure that PostgreSQL is installed on your system and the PostgreSQL server is running.

  2. Open a terminal or command prompt.

  3. 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.

  1. 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.

(back to top)

(back to top)

👥 Authors

Mention all of the collaborators of this project.

👤 Betel Andarge

👤 Micronaut JUAN DAVID DIAZ

(back to top)

🔭 Future Features

Describe 1 - 3 features you will add to the project.

  • Add new tables & create relations between
  • Add schema diagram

(back to top)

🤝 Contributing

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.

(back to top)

⭐️ Show your support

Write a message to encourage readers to support your project

If you like this project, please give a ⭐️ (Thank you)

(back to top)

🙏 Acknowledgments

Give credit to everyone who inspired your codebase.

  • I would like to thank Microverse for this learning opportunity.

  • Microverse team

(back to top)

📝 License

This project is MIT licensed.

(back to top)