Questions from Database Systems


Q: What two attributes must be contained in the composite entity between STORE

What two attributes must be contained in the composite entity between STORE and PRODUCT? Use proper terminology in your answer.

See Answer

Q: What is a strong (or identifying) relationship, and how

What is a strong (or identifying) relationship, and how is it depicted in a Crow’s Foot ERD?

See Answer

Q: Describe precisely the composition of the DEPENDENT weak entity’s primary key.

Describe precisely the composition of the DEPENDENT weak entity’s primary key. Use proper terminology in your answer.

See Answer

Q: The local city youth league needs a database system to help track

The local city youth league needs a database system to help track children that sign up to play soccer. Data needs to be kept on each team and the children that will be playing on each team and their...

See Answer

Q: Given the business rule “an employee may have many degrees,”

Given the business rule “an employee may have many degrees,” discuss its effect on attributes, entities, and relationships.

See Answer

Q: What is a composite entity, and when is it used?

What is a composite entity, and when is it used?

See Answer

Q: Suppose you are working within the framework of the conceptual model in

Suppose you are working within the framework of the conceptual model in Figure Q4.5. Figure Q4.5- The Conceptual Model Given the conceptual model in Figure Q4.5: a. Write the business rules that ar...

See Answer

Q: What is a recursive relationship? Given an example.

What is a recursive relationship? Given an example.

See Answer

Q: How would you (graphically) identify each of the following ERM

How would you (graphically) identify each of the following ERM components in a Crow’s Foot model?

See Answer

Q: Discuss the difference between a composite key and a composite attribute.

Discuss the difference between a composite key and a composite attribute. How would each be indicated in an ERD?

See Answer