Each Row of the Table Department Describes a Department

question 39

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.
-If the combination Prstno,Prstempno is chosen as the primary key for table Projstaff,setting Prstno to null in some row would be:

• A) A violation of the entity integrity rule
• B) A violation of the referential integrity rule
• C) A violation of the entity integrity rule and of the referential integrity rule
• D) None of the above

Recognize the characteristics and limitations of preoperational thinking, including animism, static reasoning, and centration.

Identify the concept of conservation and its challenges for preoperational children.

Explain the role of the amygdala in emotional responses and its developmental implications in early childhood.

Understand Vygotsky's theories on scaffolding and the zone of proximal development in the cognitive development of children.

---

Definitions:

Lump Sum

A one-time payment made for a particular purpose, rather than recurring payments over time.

Future Value

The amount of money an investment is expected to grow to over a period of time when interest or dividends are reinvested.

Straight-Line Depreciation

A method of allocating the cost of a tangible asset over its useful life in equal annual amounts.