Curriculum Databases project using PostgreSQL

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!

📗 Table of Contents

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

📖 Vet clinic database

In this project, I use a relational database to create the initial data structure for a vet clinic. I create a table to store animals' information, insert some data, and query it.

Vet clinic database is a relational database create to store animals's information, insert some data into it, and query it.

🛠 Built With

Tech Stack

Database

• PostgreSQL

Key Features

• [Create database]
• [Insert and query data in SQL]

(back to top)

💻 Getting Started

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

• Clone the project using github

Setup

After cloning this repository to your desired folder:

  cd my-folder

Install

Install this project with:

PostgreSQL

Usage

To run the project, execute the following command:

  psql -U postgres

Run tests

To run tests, run the following command:

  \c dbname
  SELECT * from tableName;

(back to top)

👥 Authors

👤 Jean Emmanuel Cadet

• GitHub: @jecode93
• LinkedIn: jean-emmanuel-cadet
• Facebook: @jecode93
• Instagram: @jecode93
• Twitter: @jecode93

👤 Suleiman Gacheru

• GitHub: @hetrox8
• Twitter: @suleimangacheru

(back to top)

🔭 Future Features

• [Add animals owner table]
• [Add clinic employee table]
• [Add visits table]

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

(back to top)

🙏 Acknowledgments

I would like to thank Microverse for giving me this wonderful opportunity to work on this project

📝 License

This project is MIT licensed.