Multiple Choice
Each row of the table Department describes a department. Deptno is the primary key. Deptmgr (Department manager) refers to Empno in table Employee.
Each row of the table Project describes a project. The primary key is Projno. Projmgr (project manager. refers to Empno in the table Employee.
The table Projstaff indicates the staff assigned to various Projects.
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
Correct Answer:

Verified
Correct Answer:
Verified
Q20: The tables Dept1 and Dept2
Q21: When using a full outer join between
Q22: <span class="ql-formula" data-value="Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno }
Q23: M-N relationships cannot be directly represented in
Q24: In the case of a natural join,where
Q26: The _ operator produces a table in
Q27: A divide operator is used to retrieve
Q28: The tables Dept1 and Dept2
Q29: The following data are in the
Q30: Each operator of relational algebra transforms one