Give an E-R model in an E-R diagram for project 9. This should include any assumptions that you make and anything else that you think helps explain, clarify and validate your E-R model.

Database Design We present here the main entity types of this database. For each entity type, we provide some of the corresponding attributes. Use this information in order to: (a) Build an Enhanced E-R diagram;

1. Curriculum: The main attributes are curriculum code, a list of courses offered, etc.

2. School: The main attributes are name, location (suburban, major city, etc.), code of their current curriculum, number of MBAs they graduate every year, size of their library, budget allocated to the MBA program, AACSB accreditation status, etc. (AACSB accredit those schools that meet certain requirements. AACSB accreditation is important since it indicates a high quality program.)

3. Alumni: The main attributes are social security number, name, name and address of the current employer, current position, current salary, GPA at graduation, etc.

4. Course: The main attributes are course code, name, type (foundational, functional, general, or institutional), topics covered, etc.

5. Student: The main attributes are social security number, name, address, current GPA, a list of courses completed, enrollment date, expected graduation date, etc.

The following are some of the queries, forms, and reports one can create in order to increase the functionality of the database:

Queries: 1. There are a few indicators of the quality of a particular MBA program. Create a query that prompts for the name of a school and returns the following information: a. The total number of MBA graduates per year during the last ten years. b. A list of graduates who are currently CEOs. Include in this list the name of the company they work for and estimated yearly salary. c. A list of graduates who make more than $60,000/year. For each graduate report the corresponding GPA. d. A list of the graduates who had a GPA higher than 3.3. For each graduate present the name of the current employer and position.

2. The experience from the best Business Schools in the nation should be considered when designing the curriculum of an MBA program. Create the following queries to help identify such schools: a. List the schools that have graduated more than 1,000 MBAs in the last 10 years. b. For all schools in the database, find the total number and the percentage of MBAs (out of all MBA graduates) who currently have a top management position with a company. Sort the information by total number of MBA graduates on top management position. c. Show for each MBA program how long it has been AACSB accredited. Sort the information by number of years. d. For each school, present the total number of graduates who had a GPA higher than 3.3 and are currently working as managers. Consider the data for the last ten years. Sort the information by total number of graduates.

3. In order to judge the validity of a particular curriculum, it is important to identify whether it has been implemented and how many schools are currently using it. List the codes of the curriculums that are currently implemented, and for each one present the total number of schools that are currently using it.

4. In the accredited MBA programs, students are required to complete their foundational courses. For each accredited MBA program, list the number of current students who have completed the foundational courses. For the students who have not completed their foundational courses, identify how far they are in the program. Count the number of students who are planning to graduate in the current semester and have not completed the foundational courses. These students will have to postpone their graduation.