For your answers to questions 1, 2, and 3 describe a method for obtaining the children for...

For your answers to questions 1, 2, and 3 describe a method for obtaining the children for one of the entities in the original data model, given the primary key of the table based on the second entity. Also, describe a method for obtaining the children for the second entity, given the primary key of the table based on the first entity.

Question 1

Show how to represent the N:M relationship in your answer to question 4. Use an IE Crow’s Foot E-R diagram.

Question 4

List the three types of binary relationships and give an example of each. Do not use the examples given in this text.

Question 2

Explain the meaning of the term intersection table.

Question 3

Explain how the terms parent table and child table relate to the tables in your answer to question 1.