CSCI 4402: Database Systems - Module 5/Quiz 5

An entity set that does not have sufficient attributes to form a primary key is termed a __________

a. Variable set

b. Variant set

c. Strong entity set

d. Weak entity set

Weak entity set

For a weak entity set to be meaningful, it must be associated with another entity set, called the______________

a. Strong entity

b. Identifying entity

c. Owner entity

d. Neighbor entity

Identifying entity

If two entities have many to many relationships mostly results in how many tables.

a. Two

b. Four

c. One

d. Three

Three

If you were collecting and storing information about your music collection, an album would be considered a/an ___________

a. Relation

b. Instance

c. Entity

d. Attribute

Entity

Select from the following the multi-valued attribute.

a. Phone_number

b. All of the mentioned

c. Name

d. Date_of_birth

Phone_number

Select the attributes which made up of more than one single attribute.

a. Single value attribute

b. Composite attribute

c. Derived attribute

d. Multi-value attribute

Composite attribute

The attribute AGE is?

a. Single valued

b. Composite

c. Derived

d. Multi-valued

Derived

The number of entities to which another entity can be related through a relationship set is called?

a. Entity

b. Attributes

c. Cardinality

d. Schema

Cardinality

The primary key in a many to one relationship, acts as a foreign key on which side?

a. On both the sides

b. On the side where many relationships are defined

c. On the side where a single (one) relationship is defined

d. Neither of them

On the side where many relationships are defined

The Rectangles in ERD represents __________

a. Primary key

b. Attributes of a relationship

c. Entity

d. Relationship

Entity

The relationship is represented in E-R diagram as________________

a. Dashed lines

b. Diamond

c. Double diamonds

d. Undivided rectangles

Diamond

Weak entity set is represented as____________

a. Double diamond

b. Double rectangle

c. Underline

d. Double line

Double rectangle

Which of the following gives a conceptual structure of the database graphically?

a. Entity-relationship diagram

b. Architectural representation

c. Entity diagram

d. Database diagram

Entity-relationship diagram