Write the relational algebra expressions that will produce tables with the following information, using the tables P (containing information on penguins), R (containing information on regions of the Anartica), PR (containing information on where penguins reside in Anartica; a (PID,RNum) tuple indicates that the penguin with ID PID resides in region RNum) shown above.

15. List of penguin breeds.

16. List penguins IDs weighing more than 20 kg.

17. List penguin IDs who are male or under 30 kg in weight using only sigma selection and projection operators.

18. List the names of female penguin with heights greater than 77 using only sigma selection operator and intersection.

19. List the penguin ID of penguins who live in a region in which the average temperature is -1 C.

20. List the breeds of penguins who live in a region in which the average temperature is -5 C.

Example solution:

Please do the solution like the example solution given. Thanks.

i4. PID Gender Breed Weight Height R PR kg cm RNum Area Av Temp RNum PID Emperor 35.6 118 100 M Sq Km C 1 Gentoo 5.1 67 200000-5 103 Gentoo 8.4, 84 102 F 150000-1 105 103 F Emperor 41.9 127 105 F Emperor 29.4 111 the relational algebra expressions that will produce tables with the following information, usin the tables P (containing information on penguins), R (containing information on regions of the Anartica), PR (containing information on where penguins a (PLD, tuple indicates that the penguin with ID PID resides in region RNum) shown above