This is an individual assignment. You may 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. In keeping track of a music collection, we have identified CD as being in a One to Many relationship to RECORDING (relationship: CD contains RECORDING) In designing tables, where should the foreign key linking the two tables be put? Explain.
3. The local police are attempting to computerize their paperwork for accident reports. They are interested in drivers, and in accidents. What is the connectivity of the relationship between the two? Explain why.