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.

Problem Description

The traditional MBA program has been receiving criticism because it is mainly focused on analytical training, whereas employers are looking for executives with broader education. Some of the concerns regarding the existing system are as follows:

The curriculum may not be relevant to many political, legal, or social business problems.

The MBAs need better communication and interpersonal skills.

Currently the MBAs are oriented to analysis rather than decision-making.

The MBAs are focused on short-term rather than long-term performance.

The MBAs are not oriented to competition in the international market.

The American Assembly of Collegiate Schools of Business (AACSB) requires the following components in an MBA curriculum:

Common body of knowledge in management.

A field of specialization.

General competence for overall management.

The following is a list of courses offered in the MBA program.

Foundational areas Functional Applications

Accounting Finance

Communications Human Resources

Information Systems Marketing

Managerial Economics Production and Operations

Organizational Behavior

Quantitative Methods

General Management Sectoral and Institutional Areas

Economic System Arts Management

International Marketplace Educational Administration

Legal and Governmental Processes Health Care Management

Society and Ethics Public Management

Strategy, Planning, Policy Transportation

Many Business Schools are trying to improve their MBA program, and this is not an easy task. You were hired to build a support system that will be used to redesign the existing MBA curriculum. You can use the following guidelines to build your system, but you should be creative and add additional features to your system.

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; (b) Transform the Enhanced E-R diagram to a relational database. Identify the primary key(s) and the foreign key(s) for each relation. Draw the relational integrality constraints; (c) For each of the relations created, indicate its normal form. If the relation is not in the 3NF, decompose it into 3NF relations.

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.

Access Application Development

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. Make 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.