Skip to content

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

License

Notifications You must be signed in to change notification settings

KanzaTahreem/Vet-Clinic-Database

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

56 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

📗 Table of Contents

📖 Vet Clinic Database

Vet Clinic Database is a relational database, based on a real-life example, to create the data structure for a vet clinic. The database consist of data about

  • Animals
  • Animals's owners
  • Clinic employees
  • Visits

🛠 Built With

Tech Stack

Client

Key Features

  • Create Database animals table to store animals' information
  • Insert data to the table and perform query to it
  • Update animals table by altering the rows and create more tables.
  • Primary key & foreign key mechanism for joining tables to model one-to-many relationships.
  • Join tables to model many-to-many relationships.
  • Database performance audit.

(back to top)

🚀 Schema Diagram

Schema Diagram

(back to top)

💻 Getting Started

Prerequisites

In order to run this project you need:

Setup

Clone this repository to your desired folder:

  git clone git@github.com:KanzaTahreem/Vet-Clinic-Database.git
  cd Vet-Clinic-Database

Creating a database

  1. Connect to your PostgreSQL server with psql
> psql
postgres=#
  1. Create the database vet_clinic
postgres=# CREATE DATABASE vet_clinic;
CREATE DATABASE
  1. Connect to your database vet_clinic. Inside your current session do
postgres=# \c vet_clininc
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. Learn more at PostgreSQL: Create 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.

(back to top)

👥 Authors

👤 Author 1

👤 Author 2

(back to top)

🔭 Future Features

  • Add more data to the tables
  • Perform multiple queries

(back to top)

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

(back to top)

⭐️ Show your support

If you like this project and want to support me make cooler projects Give this project a Star.

(back to top)

📝 License

This project is MIT licensed.

(back to top)

About

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

Topics

Resources

License

Stars

Watchers

Forks