Questions from Database Management


Q: How do you represent a 1:M unary relationship in a

How do you represent a 1:M unary relationship in a relational data model?

See Answer

Q: Martin is encouraged by the progress you have made so far.

Martin is encouraged by the progress you have made so far. As promised, he forwards you an email from one of the key members of his staff, Pat Smith (an artist manager). He also provide you with an e-...

See Answer

Q: Match the following terms to the appropriate definitions: - well

Match the following terms to the appropriate definitions: - well-structured relation - anomaly - functional dependency - determinant - composite key - 1NF - 2NF - 3NF - recursive foreign key - transit...

See Answer

Q: Suggest four steps to represent super/subtype relationships.

Suggest four steps to represent super/subtype relationships.

See Answer

Q: In the context of unary relationships, what is a recursive foreign

In the context of unary relationships, what is a recursive foreign key?

See Answer

Q: What are the properties that a candidate key must satisfy?

What are the properties that a candidate key must satisfy?

See Answer

Q: Under what conditions must a foreign key not be null?

Under what conditions must a foreign key not be null?

See Answer

Q: What is an enterprise key, and why is it important?

What is an enterprise key, and why is it important?

See Answer

Q: Describe the difference between how a 1:M unary relationship and

Describe the difference between how a 1:M unary relationship and an M:N unary relationship are implemented in a relational data model.

See Answer

Q: Why is the natural key preserved whenever a surrogate key is created

Why is the natural key preserved whenever a surrogate key is created?

See Answer