Each Row of the Table Department Describes a Department

question 4

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.
-To retrieve the projects in which all employees participate,the following operator would be used:

• A) Outer join
• B) Natural join
• C) Divide
• D) Extended cross product

Assess the financial viability of accepting special orders or further processing decisions.

Apply the total cost and sales price methods to pricing decisions.

Understand the concept of incremental analysis and its application in making business decisions.

Analyze various cost components (direct materials, direct labor, overhead) in manufacturing decisions.

---

Definitions:

Anticipated Punishment

The expectation of a penalty or negative outcome as a result of specific behavior, often used as a deterrent for such behavior.

Conditioned Stimulus

A neutral stimulus that, once paired with an unconditioned stimulus, eventually triggers a conditioned response.

Television Ad

A span of television programming produced and paid for by an organization, which conveys a message, typically to market a product or service.

Cigarettes

Narrow cylinders of finely cut tobacco rolled in paper for smoking, known to contain harmful substances including nicotine.