Vidyalelo
Database · all questions

Modeling Data in the Organization
practice.

Practice every MCQ with options. Use Show answers when you want the correct option and solution.

30

Questions

1/2

Page

Pick an option on a question to see the right answer and solution.

A binary relationship is which of the following?

Select an option to see the answer and solution.

If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist?

Select an option to see the answer and solution.

A relationship is which of the following?

Select an option to see the answer and solution.

Which of the following conditions should exist if you want to convert a relationship to an associative entity?

Select an option to see the answer and solution.

A good identifier is which of the following?

Select an option to see the answer and solution.

A rectangle represents which of the following in an ERD?

Select an option to see the answer and solution.

An entity name should be which of the following?

Select an option to see the answer and solution.

An oval represents which of the following in an ERD?

Select an option to see the answer and solution.

When the minimum and maximum number of instances of an entity is one, you know which of the following?

Select an option to see the answer and solution.

An attribute name should be which of the following?

Select an option to see the answer and solution.

A composite attribute is which of the following?

Select an option to see the answer and solution.

A binary relationship cannot be which of the following?

Select an option to see the answer and solution.

A ternary relationship involves how many entities?

Select an option to see the answer and solution.

When the minimum number of instances of an entity is one, you know which of the following?

Select an option to see the answer and solution.

A good business rule is which of the following?

Select an option to see the answer and solution.

An attribute is a person, place, object, event in a user environment.

Select an option to see the answer and solution.

Output reports should be included as part of an ERD.

Select an option to see the answer and solution.

Cardinality specifies the number of instances of one entity that can be associated with each instance of another entity.

Select an option to see the answer and solution.

Relationships cannot have attributes.

Select an option to see the answer and solution.

Business rules and policies are universal.

Select an option to see the answer and solution.