overve? One of the major functions of any academic department is student advising. In order to assist departments in better serving its majors, several reports are generated by the Registrar's Office. The Problem To design these reports, a database administrator wishes to develop an entity-relationship (ER) diagram that will capture the data necessary to generate the reports. The ER diagram will allow the database administrator to meet with the end users and effectively communicate the intended design and to determine if any items are missing from the design. To Get You Started A college listing provides a list of all majors for each department in each college. Entries are grouped under a heading that includes the name of the school or college as well as its dean. Each group consists of a department entry that lists the department name, chair and number of majors. Example: College Listing College: Business Dean: Tom Ottaway Department Informatics Accounting Management Chair Parker K. Ames, D. Tocher, N Majors 112 135 210 A faculty advisor listing includes the faculty advisor name, office, and phone number for each college and department. Example: Faculty Advisor Listing College: Business Department: Informatics Faculty Advisor Bob Houghton Jon Holmes Michael McGregor Office 539 430 317C Phone 208-282-4932 208-282-4667 208-282-3040