I need solution for problem 20 from the above picture

106 Part II Database Analys Draw an ERD for this situation and place minimum and maximum cardinalities on the diagram. Also, draw a data model for this situation using the tool you have been told to use in your course. State any assumptions that you have made. Each unit of property must be listed with one (and only one) of the sales offices. A sales office may have any number of properties listed or may have no properties Each unit of property has one or more owners. Attributes of owners are Owner ID (identifier) and Owner Name 20. Each semester, each student must be assigned an adviser who counsels students about degree requirements and helps students register for classes. Each student must regis- ter for classes with the help of an adviser, but if the student's ssigned adviser is not available, the student may register with any adviser. We must keep track of students, the as- signed adviser for each, and the name of the adviser with whom the student registered for the current term. Represent this situation of students and advisers with an E-R diagram. Also, draw a data model for this situation using the tool you have been told to use in your course An owner may own one or more units of property. An tribute of the relationship between property and owner is Percent Owned. 23. After completing a course in database management, y ou are asked to develop a preliminary ERD for a symphony orchestra. You discover the entity types that should be included as shown in Table 2-3 During further discussions you discover the following: diagram. included a ou discover . A concert season schedules one or more concerts. A particular concert is scheduled for only one concert A concert includes the performance of one or more com- For each concert there is one conductor. A conductor may 21. In the chapter, when describing Figure 2-4a, it was argued season. that the Received and Summarizes relationships and TREASURER entity were not necessary. Within the context of this explanation, this is true. Now, consider a slightly different situation. Suppose it is necessary, for compliance purposes (e.g, Sarbanes-Oxley compliance), to know when each expense report was produced and which officers (not just the treasurer) received each expense report and when ach signed off on that report. Redraw Figure 2-4a, now sitions. A composition may be performed at one or more concerts or may not be performed conduct any number of concerts or may not conduct a concerts. .Each composition may require one or more soloists o may not require a soloist. A soloist may perform one or