Each Row of the Table Department Describes a Department

question 25

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.
-The _______ part of a table consists of the table name and the column names.The ______ body shows the rows of the table.

• A) Body, heading
• B) Heading, body
• C) Heading, context store
• D) Hyper data, body

---

Definitions:

Information-Processing Theorists

Information-Processing Theorists study how human beings process, store, retrieve, and utilize information, likening the mind to a computer.

Short-Term Memory

The capacity for holding a small amount of information in an active, readily available state for a short period of time.

Control Processes

Pertains to mechanisms or systems that regulate, guide, or manage operations or activities in various contexts such as biology, psychology, or engineering.

Long-Term Memory

The part of the information-processing system that holds memories of past experiences.