CS403P Quiz 2

Q1. In Entity Relationship Data Model, which of the following symbol is used to represent Entity Type?

1. Diamond
2. Rectangle
3. Parallelogram
4. Oval

Correct answer: Rectangle

Q2. Super type/sub type are __________ between entities.

1. Instances
2. Interactions
3. Groups
4. Relationships

Correct answer: Relationships

Q3. The transfer of characteristics of super type to sub types is knows as ________________.

1. Inheritance
2. Abstraction
3. Encapsulation
4. Dependency

Correct answer: Inheritance

Q4. Generalization and specialization are associations between different __________.

1. Databases
2. Columns of table
3. Rows of table
4. Entity types

Correct answer: Entity types

Q5. In enhanced Entity Relationship Diagram, which of the following is known as specialized type?

1. Super type
2. Weak entity type
3. Sub type
4. Strong entity type

Correct answer: Sub type

Q6. In an Entity Relationship diagram, a rectangle represents ___________.

1. Relationship
2. Entities
3. Identifier
4. Attributes

Correct answer: Entities

Q7. Consider the following two sets: STD Name = [Ali, Hassan] Course Name = {Eng, Math, Phy} Then the Cartesian product of STD Name and Course Name (i.e. STD Name x Course Name) will be equal to:

1. {(Ali, Eng), (Ali, Math), (Ali, Phy), (Hassan, Phy), (Ali, Math), (Hassan, Eng)}
2. {(Ali, Math), (Ali, Phy), (Hassan, Phy), (Hassan, Eng), (Hassan, Math), (Hassan, Phy)}
3. {(Ali, Eng), (Ali, Math), (Ali, Phy), (Hassan, Eng), (Hassan, Math), (Hassan, Phy)}
4. {(Ali, Eng), (Hassan, Math), (Ali, Phy), (Hassan, Eng), (Hassan, Math), (Hassan, Phy)}

Correct answer: {(Ali, Eng), (Ali, Math), (Ali, Phy), (Hassan, Eng), (Hassan, Math), (Hassan, Phy)}

Q8. The process of identifying entity types, their properties and relationships between them is known as__________.

1. Phrase
2. Descriptor
3. Cardinality
4. Abstraction

Correct answer: Abstraction