Relational Database Model

Below are the characteristics of a Relational Table EXCEPT

• A table is perceived as a two-dimensional structure composed of rows and columns.

• Each table row(tuple) represents a single entity occurrence within the entity set.

• Each table column represents an attribute.

• All values in a column may have different data format.

Attribute whose value is determined by the other attribute is called____________

• Determinant

• Dependant

Which of the below attribute is determinant?

• Student ID

• Student Name

• Student GPA

Below are the type of key(s) available in RDBM EXCEPT

• Superkey

• Candidate key

• Primary key

• Composer key

In the table above, which one is candidate key?

• StudentID, firstName, lastName

• (StudentID,firstName),(StudentID,lastName)

• CourseID

In the table above, which one is Primary Key?

• firstName

• lastName

• StudentID

Select is a unary operator that yields a ______________________ subset of a table.

• vertical

• horizontal

Referring to the original table above, if we execute project CustomerName, which result will be produced?

• 
• 
• 

If we execute Product operator for table A and B, how many possible pair will be produced?

• 5

• 4

• 6

• 9

What operator between table Completed and DBProject that be able to produce result as in picture above?

• Union

• Intersect

• Difference

• Divide