Questions from Database Management


Q: Why must the minimum cardinality next to SUPPLIES from PURCHASED PART be

Why must the minimum cardinality next to SUPPLIES from PURCHASED PART be one yet the minimum cardinality next to SUPPLIES from SUPPLIER may be zero?

See Answer

Q: When is a member of a supertype always a member of at

When is a member of a supertype always a member of at least one subtype?

See Answer

Q: Match the following terms and definitions: - supertype -

Match the following terms and definitions: - supertype - entity cluster - subtype - specialization - subtype discriminator - attribute inheritance - generalization a. subset of supertype b. creating a...

See Answer

Q: Contrast the following terms: a. supertype; subtype

Contrast the following terms: a. supertype; subtype b. generalization; specialization c. disjoint rule; overlap rule d. total specialization rule; partial specialization rule e. PARTY; PARTY ROLE f. e...

See Answer

Q: Discuss the notations used to represent EER models. Which notation is

Discuss the notations used to represent EER models. Which notation is the most widely used?

See Answer

Q: Explain the need for EER modeling.

Explain the need for EER modeling.

See Answer

Q: Explain how specialization and generalization assist in the development of supertype/

Explain how specialization and generalization assist in the development of supertype/subtype relationships.

See Answer

Q: What is attribute inheritance? Why is it important?

What is attribute inheritance? Why is it important?

See Answer

Q: What is a completeness constraint, and what are the total and

What is a completeness constraint, and what are the total and partial specialization rules?

See Answer

Q: What types of business rules are normally captured in an EER diagram

What types of business rules are normally captured in an EER diagram?

See Answer