pid is a foreign key $($without CASCADE$)$ in Emp table references to the Prj table and cid the primary key in Emp table.

If we need to add a new record $($cid$,$ cname, salary, pid, pname$)$ with values $(1,$ 'Mary', $12000,3,\text{'}$C$++\text{'}),$ which answer is TRUE?

Given the following tables and records:

mysql$>$ select $*$ from Emp;

$+-----+-------+--------+------+$

$|$ cid $|$ cname $|$ salary $|$ pid $|$

$+-----+-------+--------+------+$

$|1|$ Mary $|12000|1|$

$|2|$ Tom $|6000|2|$

$+-----+-------+--------+------+$

mysql$>$ select $*$ from Prj;

$+-----+--------+$

$|$ pid $|$ pname $|$

$+-----+--------+$

$|1|$ Java $|$

$|2|$ Python $|$

$|3|$ Web $|$

$+-----+--------+$

pid is a foreign key $($without CASCADE$)$ in Emp table references to the Prj table and cid the primary key in Emp table.

If we need to add a new record $($cid$,$ cname, salary, pid, pname$)$ with values $(1,$ 'Mary', $12000,3,\text{'}$C$++\text{'}),$ which answer is TRUE?

We must insert the data into the Prj table first.

We cannot insert the data of this record into both tables.

We can either insert the data into the Prj table first or insert the data into the Emp table first. There is no order we need to follow.

We must insert the data into the Emp table first.