anita00001/clinic_database

CLINIC DATABASE

📗 Table of Contents

• 📖 About the Project
  • 🛠 Built With
    • Tech Stack
    • Key Features
  • 🚀 Live Demo
• 💻 Getting Started
  • Prerequisites
  • Setup
  • Install
• 👥 Authors
• 🔭 Future Features
• 🤝 Contributing
• ⭐️ Show your support
• 🙏 Acknowledgements
• 📝 License

📖 Vet Clinic Database

clinic database is a relational database built using PostgreSQL. In this database information like name, date_of_birth, admitted_at, patient_id, status and invoices, are stored.

🛠 Built With

• PostgreSQL

Tech Stack

Database

• PostgreSQL

Key Features

• Relational Database
  
• medical_histories Table
  
• Queries

(back to top)

🚀 Live Demo

Not available

(back to top)

💻 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!

Prerequisites

In order to run this project you need:

Setup

Clone this repository to your desired folder:

git clone https://github.com/Othniel2471/clinic_database.git

cd clinic

psql

postgres=# \c clinic

Install

Download and Install PostgreSQL

• Download PostgreSQL

(back to top)

👤 Author

• GitHub: @anita00001
• LinkedIn: anitaa-sharmaa
• Twitter: @anitaa_sharmaa

(back to top)

🔭 Future Features

• Query Multiple tables
• Join tables for visits
• Database performance audit

(back to top)

🤝 Contributing

• Contributions, issues, and feature requests are welcome!
  Feel free to check the issues page.

(back to top)

⭐️ Show your support

Do you like this project❔❓
Give it a star ⭐

(back to top)

🙏 Acknowledgments

• I express my sincere gratitude to Microverse (microverse.org) for providing the necessary resources and knowledge.
• I am thankful to my Learning Partners, Mentors and Code Reviewers who encourage me to optimize and make this project functional.

(back to top)

📝 License

This project is MIT licensed.

(back to top)