Write down the question assigned to you below, construct the SQL statement to answer the question and copy paste / screenshot (prtsc) the results of the SQL statement executed in Oracle. Compile them in ONE document and submit HERE.

1. Show lot num, plant type, and fish species in Garden KICT
2. Show plant ID, plant type and the type of fertilizer used.
3. How many plants were received in the month of May 2020?
4. Show the fish species and the plant type that are in lot number 1003

GARDEN INVENTORY +Lot_Num: INT + Garden_Name: VARCHAR (70) + Fish_ld: INT + Plant_ld: INT PLANT_OBSERVATION + Plant_id: INT + Plant_Type: VARCHAR (45) + Date_received: DATE + Plant_Height: INT FISH_REARING + Fish_ld: INT + Species: VARCHAR (45) + Quantity_Of_Fish: INT + Date_Recorded: VARCHAR (60) PLANT_WATERING_SCHEDULE + Plant_id: INT + Date_Recorded: VARCHAR (45) + Watering_Time: TIME FERTILIZING_SCHEDULE + Plant_id: INT + Type_Of_Fertilizer: VARCHAR (45) + Fertilizing_Date: DATE FISH_FEEDING_SCHEDULE + Fish_ld: INT + Feeding_Date :DATE + Feeding_Time: TIME + Remarks: VARCHAR (60) 4.0 PHYSICAL DATABASE DESIGN CREATE TABLE PLANT_OBSERVATION (Plant_id int Plant Type varchar(45), Date_recieved date, PlantHeight int, PRIMARY KEY (Plant_id) CREATE TABLE FISH REARING (Fish_Id int, Species varchar(15), Quantity_Of_Fish int, Date_Recorded date, PRIMARY KEY (Fish_ld) }; CREATE TABLE GARDEN_INVENTORY (Lot_Num int, Garden_Name varchar(70), Fish ld int. Plant_id int, PRIMARY KEY (Lot_Num), FOREIGN KEY (Fish_ld) REFERENCES FISH_REARING(Fish_id), FOREIGN KEY (Plant_id) REFERENCES PLANT_OBSERVATION(Plant_id) }; CREATE TABLE PLANT WATERING SCHEDULE (Plant Id int, date Recorded date, Watering Time TIMESTAMP WITH LOCAL TIME ZONE, FOREIGN KEY (Plant_id) REFERENCES PLANT_OBSERVATION(Plant_id) CREATE TABLE FERTILIZING_SCHEDULE (Plant_id int, Type_Of_Fertilizer varchar(45), Fertilizing_Date date, Remarks Varchar(60), FOREIGN KEY (Plant_id) REFERENCES PLANT_OBSERVATION(Plant_id) ); CREATE TABLE FISH_FEEDING_SCHEDULE (Fish_ld int, Feeding_Date date, Feeding Time TIMESTAMP WITH LOCAL TIME ZONE, FOREIGN KEY (Fish_Id) REFERENCES FISH_REARING(Fish_Id) ); TABLE PLANT WATERING SCHEDULE Number of Records: 5 Plant_id date_Recorded Watering Time 1 6 April 2020 6 Apr 2010 05:05-01 2 6 April 2020 6or 2020 05:05 01 1 5 April 2020 sol 2020 05:05:01 4. 6 April 2020 6 Apr 2030 05:05-03 5 6 April 2020 620200001 TABLE FISH_FEEDING SCHEDULE Number of Records: 5 Fishid Feeding Date Feeding Time 100 6 April 2020 6 April 2020 03:05:01 6 April 2020 03:15:01 102 6 April 2020 103 6 April 2020 6 April 2020 03:25:01 104 6 April 2020 6 April 2020 03:35:01 105 6 April 2020 6 April 2020 03:45:01 TABLE PLANT OBSERVATION umber of recorda Pant_id Planttype Date resigned PlantHeight Dies 20 y 3030 7 2 Les 152030 50 1 22 2020 10 Sprach Tomatoes 4 5 June 2010 35 Spinach 22 000 77 TABLE FISH_REARING Number of Records: 5 Fish_Id Species Quantity_of_Fish Date Recorded 101 Tilapia 5 20 June 2020 102 KOI 4 20 JULY 2020 103 GOLD FISH 6 20 AUGUST 2020 104 BETA FISH 20 20 OCTOBER 2020 105 GUPPY FISH 20 20 NOVEMBER 2020 TABLE GARDEN_INVENTORY Number of Records tom Garden Home 1001 100 1 1003 102 2 Garden ICT Garden RIGT 100) 10 1 1 LOC Garden 10 LOS Garden ICT 105 TABLE FERTILIZING SCHEDULE Number of Records Plant PlantId Type of fertilizer 100 Ammo Fertilizing Date Remarks 20 Jan 2020 Piste ta Ongan 20 il 2020 Twice a year 103 Organic 20 Xuly 2020 Twice a year 20 y 2020 Twice a year Organic Organic 105 20 July 2020 wice a year