“Kroenke, David M., et al. Database Concepts.

Q1. What is denormalization? When is denormalization justified?

Q2. For a 1:M relationship, explain why we must place the PK of the parent table in the child table as the FK, rather than place the PK of the child table in the parent table as the PK.

Q3. You might have noticed that we keep M:N relationships in data modeling phase in Ch4, but we need to resolve them in the database designing phase in Ch5. Why do you think we can not keep M:N relationships in database designing phase? How do we resolve the M:N relationship in Ch5?

Q4. What is an intersection table? What are the differences between an intersection table and an associative table introduced in Ch4?

Q5. Someone says the FK of a subtype entity is the same as its PK, do you agree? What does this suggest the relationship (1:1, 1:M, or M:N) should be between the subtype entity and its supertype?

find the cost of your paper

This question has been answered.

Get Answer