Blog

Refer to the sample tables and sample data below. Then answe…

Refer to the sample tables and sample data below. Then answer questions (a), (b), (c), (d), (e), and (f). Tables:adult (id(pk), name) child (id(pk), name)parent_child (parent(pk, fk), child (pk, fk)) — foreign key (parent) references adult(id) — foreign key (child) references child(id)mysql> SELECT * FROM adult;+—-+——————+| id | name |+—-+——————+| 1 | Homer Simpson || 2 | Marge Simpson || 3 | Jane Jetson || 4 | Peter Griffin || 5 | Wilma Flintstone | +—-+——————+mysql> SELECT * FROM child;+—-+————+| id | name |+—-+————+| 11 | Peppa Pig || 12 | George Pig || 13 | Candy Cat || 14 | Suzy Sheep || 15 | Danny Dog |+—-+————+mysql> SELECT * FROM parent_child;+——–+——-+| parent | child |+——–+——-+| 1 | 11 || 2 | 11 || 1 | 12 || 2 | 12 || 3 | 13 ||      3 |    14 || 4 | 15 |+——–+——-+ Complete the following statements based on the result set from the following command: SELECT c.name, a.name FROM child c JOIN parent_child pc ON c.id = pc.child JOIN adult a ON a.id = pc.parent; (a) The result set has [rows] row(s) (b) The result set has [cols] column(s). (c) Wilma Flintstone appears [wilma] time(s). (d) Jane Jetson appears [jane] time(s). (e) Candy Cat appears [candy] time(s). (f) George Pig appears [george] time(s).