dev89s / db_audit

database audit excercise

📗 Table of Contents

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

📖 About The Project

Vet Clinic DB is a database that creates a table named animals and inserts 4 animals with their descriptions including name, date_of_birth, weight_kg, neutered, escape_attempts and then makes different queries on those animals. It is meant for SQL learning purpose.

🛠 Built With

Tech Stack

Client

• psql

Database

• PostgreSQL

(back to top)

Key Features

• Transactions are Atomic
• It is Consistent
• It's Reliable/Durable
• It is PostgreSQL

(back to top)

💻 Getting Started

How to install PostgreSQL on MacOS you ask? Well, let's start by install this simple app: PostgreSQL.app

Then follow the instructions (1-2-3) in here

And then if you have an open terminal close and open a new one. Enter the command below:

 $ psql

Use all the default fields by pressing enter and you'll be logged in.

(back to top)

Setup

Clone this repository to your desired folder:

Example commands:

  cd my-folder
  git clone https://github.com/dev89s/vet-clinic-db.git

👥 Authors

👤 Author1

• GitHub: @dev89s
• LinkedIn: LinkedIn

👤 Author2

• GitHub: @UbdaNam
• LinkedIn: Abdurahim M.

(back to top)

🔭 Future Features

• Query and update animals table
• Query multiple tables
• Add database schema diagram

(back to top)

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to give any recommendations issues page.

(back to top)

⭐️ Show your support

If you like this project consider giving it a star on GitHub!

(back to top)

🙏 Acknowledgments

I would like to thank microverse and Abdurahim in advance. You guys helped me to build this project by supporting me and providing resources.

(back to top)

📝 License

This project is MIT licensed.

(back to top)