Skip to content

This is an educational project to create the initial data structure for a vet clinic using a relational database. Built with PostgreSQL.

Notifications You must be signed in to change notification settings

Elijahdre/vet_clinic

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Vet Clinic Database

This is an educational project to create the initial data structure for a vet clinic using a relational database. I started with one table and created a complete database about:

schema

Built With

  • Relation Database: PostgreSQL
  • VS Code

Getting Started

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!

To get a local copy up and running follow these simple steps.

Prerequisites

  • A web browser like Google Chrome.
  • A code editor like Visual Studio Code with Git and Node.js.

You can check if Git is installed by running the following command in the terminal.

$ git --version

Likewise for Node.js and npm for package installation.

$ node --version && npm --version

Setup

Clone the repository using the GitHub link provided below.

Install

In the terminal, go to your file directory and run this command.

$ git clone [email protected]:Elijahdre/vet_clinic.git

Usage

Kindly modify the files as needed.

Author

👤 Elijah Odjegba

  • GitHub: GitHub Badge
  • Twitter: Twitter Badge
  • LinkedIn: LinkedIn Badge

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

Show your support

Give a ⭐️ if you like this project!

Acknowledgments

  • Hat tip to anyone whose code was used
  • Inspiration
  • etc

📝 License

This project is MIT licensed.

About

This is an educational project to create the initial data structure for a vet clinic using a relational database. Built with PostgreSQL.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published