CREATE TABLE Person $($

PersonID Number PRIMARY KEY,

Name Char$(45)$

Gender Char$(1)$

$)$;

CREATE TABLE Parent $($

ParentID Number,

ChildID Number

$)$;

CREATE TABLE Spouse$($

Spouse$1$ID Number,

Spouse$2$ID Number

$)$;

INSERT INTO Person VALUES $(1200,\text{'}$E M$,\text{'}$F$\text{'})$;

INSERT INTO Person VALUES $(301,\text{'}$R T$\text{'},\text{'}$F$\text{'})$;

INSERT INTO Person VALUES $(302,\text{'}$Z T$,\text{'}$M$\text{'})$;

INSERT INTO Person VALUES $(1201,$S T$,$M$)$;

INSERT INTO Person VALUES $(1010,\text{'}$B M$\text{'},\text{'}$M$\text{'})$;

INSERT INTO Person VALUES $(1011,$C G$,$F$)$;

INSERT INTO Person VALUES $(1001,\text{'}$R M$\text{'},\text{'}$F$\text{'})$;

INSERT INTO Person VALUES $(1000,\text{'}$J M$\text{'},\text{'}$M$\text{'})$;

INSERT INTO Person VALUES $(1100,\text{'}$C M$\text{'},\text{'}$M$\text{'})$;

INSERT INTO Person VALUES $(107,\text{'}$S M$\text{'},\text{'}$M$\text{'})$;

INSERT INTO Person VALUES $(108,\text{'}$J M$\text{'},\text{'}$M$\text{'})$;

INSERT INTO Person VALUES $(1110,\text{'}$N B$\text{'},\text{'}$F$\text{'})$;

INSERT INTO Person VALUES $(1300,\text{'}$J M$\text{'},\text{'}$F$\text{'})$;

INSERT INTO Person VALUES $(1310,\text{'}$S G$,\text{'}$F$\text{'})$;

INSERT INTO Person VALUES $(1301,$L G$,$M$)$;

INSERT INTO Person VALUES $(1020,\text{'}$D V$,\text{'}$F$\text{'})$;

INSERT INTO Person VALUES $(1021,\text{'}$J V$\text{'},\text{'}$M$\text{'})$;

INSERT INTO Person VALUES $(1202,\text{'}$K V$\text{'},\text{'}$F$\text{'})$;

INSERT INTO Person VALUES $(1201,\text{'}$R V$\text{'},\text{'}$M$\text{'})$;

INSERT INTO Parent VALUES $(105,104)$;

INSERT INTO Parent VALUES $(103,)$;

INSERT INTO Parent VALUES $(102,202)$;

INSERT INTO Parent VALUES $(103,203)$;

INSERT INTO Parent VALUES $(104,204)$;

INSERT INTO Parent VALUES $(105,205)$;

INSERT INTO Spouse VALUES $(1000,2000)$;

INSERT INTO Spouse VALUES $(1100,2100)$;

INSERT INTO Spouse VALUES $(1200,2200)$;

Using these tables Write:

b$.$ a query to return the two parents of each child $($if you aren$$t careful, the rows will show up twice$).$

c$.$You notice there might be siblings in there. Instead or returning the pair of parents for each child, modify the query to return pairs of people who have at least one child together.

d$.$Extend the prior query to count how many children they have together

e$.$Write a query to connect each female in the dataset to her children $($one child per row$).$ If she has no children, it should return NULL.

f$.$Write a query to determine if each mother has a spouse. If they do not have a spouse, the return should be NULL.

g$.$Write a query to determine all of the grandsons.

h$.$Using a semi$-$join, determine all the People who are fathers.

i$.$Using an anti$-$join, determine all of the unwed people.

j$.$Determine all brother$-$sister combinations.