RELATIONAL DATA MODEL

In the relational database, identify the distinguishes a primary key from other database components. [C1]

• The primary key can contain duplicate data in the field.

• The primary key can be found only in a junction table.

• .The primary key uniquely identifies each record in a database table.

• .The primary key is always the first field in a database table.

Based on the diagram above, identify the entity that used in the database. [C2]

• EmpID

• Age

• Degree

• Employee

Identify a field in a related table that refers to the Primary Key in another table. [C1]

• Foreign Key

• B. Primary Key

• Candidate Key

• None of the above

Choose the correct attribute that should be taken as a Primary Key. [C2]

• Name

• DepartmentID

• Department

• Street

Based on the diagram above, choose the correct answer for relation schema. [C2]

• Department(DNo, PNo, Budget)

• Project(DNo, PNo, DName, PName)

• Department(PNo, PName, MgrNo)

• Project(PNo, PName, Budget)

Identify the fundamental operators in relational algebra. [C1]

• Set intersection

• Natural join

• Assigntment

• Cross Product

Identify the operators that not in Join. [C1]

• Natural

• Outer

• Beta

• Inner

Identify the False statements. [C2]

I. RIGHT OUTER JOIN is equivalent to LEFT OUTER JOIN if order of tables are reversed.

II. FULL OUTER JOIN is same as CROSS JOIN

III. SELF JOIN is a special type of OUTER JOIN

• I and II

• I and III

• II and III

• I, II and III

Identify the tradisional set of operators results that shows only the rows in both tables. [C1]

• Intersection

• Union

• Difference

• Cross product

Based on the above diagram, choose the correct output when using

union operator for supplier_id. [C2]

• 
• 
• 
•