Database Design Quiz

The minimal set of super key is called

• Primary key

• Secondary key

• Candidate key

• Foreign key

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

• Strong entity set

• Weak entity set

• Simple entity set

• Primary entity set

The Primary key must be

• Non Null

• Unique

• Option A or B

• Option A and B

The attribute that can be divided into other attributes is called

• Simple Attribute

• Composite Attribute

• Multi-valued Attribute

• Derived Attribute

In an Entity-Relationship Diagram "Ellipses" represents

• Attributes

• Weak entity set

• Relationship sets

• Multi-valued attributes

In an Entity-Relationship Diagram "Diamonds" represents

• Attributes

• Multi-valued attributes

• Weak entity set

• Relationship sets

Which of the following in true regarding Referential Integrity?

• Every primary-key value must match a primary-key value in an associated table

• Every primary-key value must match a foreign-key value in an associated table

• Every foreign-key value must match a primary-key value in an associated table

• Every foreign-key value must match a foreign-key value in an associated table

How many types of keys in Database Design?

• Candidate key

• Primary key

• Foreign key

• All of these

An entity type whose existence depends on another entity type is called a entity.

• Strong

• Weak

• Codependent

• Independent

Key to represent relationship between tables is called

• Primary key

• Secondary

• Foreign Key

• None of these