Consider the following set of tables describing penguins and regions of Antartica: a. Assuming that PID and RNum are unique identifiers, what are likely primary keys for the Penguins and Regions tables?

a. Assuming that PID and RNum are unique identifiers, what are likely primary keys for the Penguins and Regions tables?

c. What are foreign keys necessary for this set of tables in order to ensure that only registered penguins can be in regions of the Antartica and penguins can only reside in registered regions of the Antartic?

d. Can you add a tuple (105, M, Gentoo, 5.7, 69) to the Penguin table? Why or why not?

Example solution:

Please do it like the example solution.Thanks

3. Consider the following set of tables describing penguins and regio Penguins PID Gender Breed Weight Height Regions kg cm. RNum Area Av Temp Emperor 35.6 118 100 M Sq Km C 1 Gentoo 5.1 67 101 M 200000-5 102 Gentoo 8.4 84 2 150000 -1 Emperor 41.9 127 103 F Emperor 29.4 111 105 F a. Assuming that PID and RNum are unique identifiers, what are