CS403 Quiz 2 Solution

1) A ________ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

1. Weak
2. Relationship
3. Business
4. Strong

2) Which of the following constraint is included in the definition of the table>

1. Foreign key
2. Domain
3. Null
4. Default value

3) The basic purpose of Diamond in ER diagram is to show the _________.

1. Composite attribute
2. Relationships
3. Entity set
4. Attributes

4) The attribute that is calculated from other attribute is called _______

1. Derived attribute
2. Multi-valued attribute
3. Simple attribute
4. Composite attribute

5) For which binary operation, relations are not required to be union compatible>

1. Union
2. Difference
3. Intersection
4. Cartesian product

6) “Select” and “Project” are the examples of _________.

1. Ternary operations
2. Binary operations
3. Nary operations
4. Unary operations

7) ______ is same as Equi-Join with a slight difference.

1. Semi Join
2. Natural Join
3. Outer Join
4. Theta Join

8) The attribute EXPERIENCE is calculated from DATE_OF_JOINING attribute. The EXPERIENCE is a ________ attribute.

1. Stored
2. Derived
3. Composite
4. Multi-valued

9) An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.

1. Primary
2. Super
3. Candidate
4. Sub

10) _________ is the first comprehensive complete database design.

1. Conceptual Database Design
2. Logical database design
3. Relational Database design
4. Hierarchical Database design