Each Row of the Table Department Describes a Department

question 15

Multiple Choice

$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptno } & \text { Empsalary } & \text { Emptitle } \\\hline\end{array}$
Each row of the table Department describes a department. Deptno is the primary key. Deptmgr (Department manager) refers to Empno in table Employee.

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline\end{array}$
Each row of the table Project describes a project. The primary key is Projno. Projmgr (project manager. refers to Empno in the table Employee.

$Table~Project\\\begin{array}{|l|l|l|}\hline \text { Projno } & \text { Projname } & \text { Projmgr } \\\hline\end{array}$
The table Projstaff indicates the staff assigned to various Projects.

$Table~Project\\\begin{array}{|l|l|l|l|l|}\hline \text { Prstno } & \text { Prstempno } & \text { Prsthours } & \text { Prstdate } & \text { Prstasgtno } \\\hline\end{array}$
The combination of columns Prstno, Prstempno is a candidate key. There could be other candidate
keys. Prstempno is the Empno in table Employee of the employee working on project number Prstno, which refers to Projno in the table Project. The meaning of Prstasgtno is left undefined.
-Which of the following columns of the table Department is a foreign key?

• A) Deptno
• B) Deptname
• C) Deptcity
• D) Deptmgr

---

Definitions:

Compound Proposition

A statement formed by combining two or more propositions using logical connectors (like and, or, not), resulting in a proposition with a more complex structure.

Complete Propositions

Statements or assertions that convey a complete idea, capable of being true or false, and usually containing both a subject and a predicate.

Inclusive Sense

Refers to an understanding or interpretation that aims to encompass or include all relevant aspects or elements.

Disjunction

A compound proposition containing two or more component propositions (the disjuncts) and asserting that at least one of them is true.