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

Understand the principles of calculating overhead rates and their implications for costing.

Analyze the operational and financial implications of job order production in various industry settings.

Identify the characteristics of cost accounting systems and their application in timely inventory and cost management.

Understand the distinction and examples of direct and indirect labor costs in production.

---

Definitions:

Poisson Distributions

A statistical distribution that expresses the probability of a given number of events occurring in a fixed interval of time or space if these events occur with a known constant rate and independently of the time since the last event.

Arrivals PER Unit

A measure in queue theory or operations research indicating the rate at which entities arrive into a system for processing, per unit of time.

Model C

A specific model or version within a series of designs, products, or frameworks, distinguished by unique features or specifications.

M/D/1 System

A queueing model describing a service system with a single server, Poisson arrival process, deterministic service times, and a queue capacity of one.