Exercise 4-1 Figure 4-23 shows a first draft of modeling the situation where a publishing company wants to keep information about authors and books. Consider the possible optionalities at each end of the relationship writes and so determine some possible definitions for a book and an author wnites Author Book Figure 4-23. Consider possible optionalities for authors writing books Exercise 4-2 Figure 4-24 shows a possible data model for cocktail recipes. The Many-Many relationship uses can be navigated in either direction. To find out the ingredients in a Manhattan or to discover the possible uses for that bottle of Vermouth. What is missing? USes Figure 4-24. Cocktails and their ingredients. What is missing? Exercise 4-3 Part of the data model about guests at a hostel ls shown in Figure 4-25. How could the model be amended to keep historical information about room occupancy? Guestoccupies name type 01 1. 8 Exercise 4-1 Figure 4-23 shows a first draft of modeling the situation where a publishing company wants to keep information about authors and books. Consider the possible optionalities at each end of the relationship writes and so determine some possible definitions for a book and an author wnites Author Book Figure 4-23. Consider possible optionalities for authors writing books Exercise 4-2 Figure 4-24 shows a possible data model for cocktail recipes. The Many-Many relationship uses can be navigated in either direction. To find out the ingredients in a Manhattan or to discover the possible uses for that bottle of Vermouth. What is missing? USes Figure 4-24. Cocktails and their ingredients. What is missing? Exercise 4-3 Part of the data model about guests at a hostel ls shown in Figure 4-25. How could the model be amended to keep historical information about room occupancy? Guestoccupies name type 01 1. 8