$(3$a$)$ Table EMP has $25,000$ records.

Create View V$1$ as Select Sex, Count$(*)$ from EMP order by Sex group by Sex;

How many records does V$1$ have? Is V$1$ updatable? Explain your answer.

$(3$b$)$ Table T$1$ has fields A B C D$.$ A is the primary key. D is a foreign key into table T$2.$ User X has view V$1$ on T$1$ with fields B C D $($column subset$).$ Can user X add a record to V$1?$ Explain your answer.

$(3$c$)$ Table T$1$ has fields A B C D$.$ A is the primary key. D is a foreign key into table T$2.$ User A has view V$5$ on T$1$ with fields A B C D for B $>10.$and. B $<20($row subset$).$ Give an example of how adding a record can cause a violation of entity integrity.

$(3$d$)$ Table T$1$ has fields A B C D$.$ A is the primary key. D is a foreign key into table T$2.$ User Y has view V$2$ on T$1$ with fields A B C$.$ Give an example of user Y adding a record that will cause a referential integrity error.

$(3$e$)$ You have a table R with five fields A$,$ B$,$ C$,$ X$,$ and W with the following functional dependencies:

X $->$ A W $->$ B B$,$ W $->$ A$,$ C$,$ X

$1.$ What is the only choice for the primary key of this table? Give a complete explanation why this is the primary key $($and not something else$).$

$2.$ Give one normal form that the table does not satisfy. Explain why the table does not satisfy that normal form.

$3.$ Convert table R into tables satisfying $3$NF$.$