This is an individual assignment. You may ask teammates, other class members, and random people (only) the same types of questions I would answer. You must develop your own individual answers.
Task:
Answer the questions below:
1. In keeping track of politicians and offices, we have identified POLITICIAN as being in a One to One relationship to OFFICE (relationship: POLITICIAN holds OFFICE). Business rules suggest that there are POLITICIANs who are not in OFFICE, and that all OFFICEs have a POLITICIAN holding it. In designing tables, where should the foreign key linking the two tables be put? Explain.
2. As an airline, in keeping track of TICKETs and BOARDING PASSes, we have identified TICKET as being in a One to Many relationship to BOARDING PASS (relationship: TICKET authorizes BOARDING PASS). In designing tables, where should the foreign key linking the two tables be put? Explain.
3. Suppose that you are modeling for a publisher such as Prentice-Hall, and that Prentice-Hall wants to keep track of AUTHORs and the BOOKs that the authors have written. What do you think the connectivity between AUTHOR and BOOK is? Briefly explain why.