this is the scnerio that is highlighted

please I help in solving this asap.

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 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 assigned 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 ave been told to use in your course 21. In the chapter, when describing Figure 2-4a, it was argued 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 each signed off on that report. Redraw Figure 2-4a, now including any attributes and relationships required for this revised situation 22. Prepare an ERD for a real estate firm that lists property for sale. Also prepare a definition for each entity type, attri- bute, and relationship on your diagram. In addition, draw a data model for this situation using the tool you have been told to use in your course. The following describes this organization: .The firm has a number of sales offices in several states Attributes of sales office include Office Number (identi- fier) and Location 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 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 assigned 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 ave been told to use in your course 21. In the chapter, when describing Figure 2-4a, it was argued 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 each signed off on that report. Redraw Figure 2-4a, now including any attributes and relationships required for this revised situation 22. Prepare an ERD for a real estate firm that lists property for sale. Also prepare a definition for each entity type, attri- bute, and relationship on your diagram. In addition, draw a data model for this situation using the tool you have been told to use in your course. The following describes this organization: .The firm has a number of sales offices in several states Attributes of sales office include Office Number (identi- fier) and Location