Diets of animals in zoo garden

This is a schema of SQL database that holds data about diets and the way how Animals are fed in it

Getting Started

Following insructions are going to help you with running code

Prerequisites

Create data

Database schema can be created via Create file

Data load

Data can be loaded within the usage of 4 following files in the following order :

• 1-Boksy , Diety , Gatuki , Zwierzeta.sql
• 2-Pracownicy i weterynarze.sql
• 3-Składniki , Posiłki składy posiłków , Zlecenia Diety.sql
• 4-Karmienia Zwierzat Boksów i ogólnie Modyfikacje.sql

all of them contains simple inserts

SQL

In the file Zapytania you can see my inventions of the sql queries for this database

Cleaning

To clean after database you need to use drop file

Versioning

Final version of files was uploded.

Authors

• Aleksandra Rezetka - Initial work - NiebieskiLis