WorksheetsRelational Database Model
Total questions: 10
Worksheet time: 5mins
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
