3. (40 points) 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. Redesigning the MBA curriculum 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 Accounting Communications Information Systems Managerial Economics Organizational Behavior Quantitative Methods Functional Applications Finance Human Resources Marketing Production and Operations General Management Economic System International Marketplace Legal and Governmental Processes Society and Ethics Strategy, Planning, Policy Sectoral and Institutional Areas Arts Management Educational Administration Health Care Management Public Management 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. 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. Create a query that prompts for the name of a school and returns the following information: 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 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 Forms: 1. Create a user sign-in form together with a registration form for new users. 2 Create the following data entry forms that are used for database administrative functions: curriculums, schools, students, courses, etc. These forms allow the user to add, update, and delete information about curriculums, schools, students, courses, etc. 3. Create a form that allows the user to select from a combo box the name of a Business School. Create a subform that presents the following information about the selected school: social security number and name of the students who are currently enrolled in the program. Create a form that allows the user to browse through the information about the who are currently enrolled in an MBA program. Create a subform that presents the following information about a student social security number, name, address, enrollment date, and a list of courses taken so far. Group the courses by type (foundational, functional, general, or institutional) 5. Create a form that allows the user to choose a particular curriculum from a list box Create a subform that presents for the chosen curriculum the name and code of the courses offered. 6. We designed a number of queries that help identify the best MBA programs in the nation. Create a form that enables the user to run these queries. Command buttons can be used for this purpose. Name this form identifying the Best MBA Programs." When the user clicks on a particular command button, one of the queries is run, and the outcome is presented. Design a logo for this database. Put this logo in the forms created above as well as on the reports that you will be creating next Include the following in the forms created record navigation command buttons, record operations command buttons, and form operations command buttons as needed 2. 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 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. Reports 1. Prepare a report on existing curriculums. This report should include information such as the number of schools currently using that curriculum, the courses offered, and the date the curriculum was last updated. 2 Every month, MBA students get a newsletter. Use the label wizard to create labels with the address of the students who are currently enrolled in an MBA program 3. Use the chart wizard to plot the following: a The total number of students graduated from an MBA program per year during the last ten years. b. The total number of students enrolled in an MBA program per year during the last ten years. C. The total number of MBA graduates who have a top management position. To build this plot use the data about MBA graduates of the last ten years. d. The number of AACSB accredited MBA programs per year for the last ten years. e The average student faculty ratio of each MBA program. [ Average GPA of MBA graduates per year during the last ten years. 4. Report for each of the current students the classes they have taken Group the classes by type 5. List the schools that are AACSB accredited. MBA Curriculum The user can browse the database to leam more about curriculums offered in business schools. The user can identify the most successful curriculums, the courses included in a particular curriculum, etc. MBA Alumni. This option provides information about MBA graduates. We encourage the use of statistical analysis tools, usage of plots (similar to the ones created in the Access Application Development section), etc. that enable the user to draw conclusions about the placement of an MBA program Current Students: This option provides information about current MBA students. Update: The update form requires an administrator login name and password. This form allows the user to add delete update the information kept in this database about MBA programs, students, etc Visual Basic.NET Application Development This database application can be used by prospective MBA students, companies that plan to hire MBAs, the database administrator, etc. In the following figure we present a tentative layout of the system. Web Extension Users of this database are alumni, current students, professors, companies, etc. A user can access the database from a personal computer at home or in the office. To be able to use the database, a user should be a member and have a login name and password. To become a member, the user should submit the following information: name name of the employer (if applicable), address, profession, etc. The user should be able to search the database to find out about the current curriculums, AACSB accredited schools, etc. A member, however, should not be allowed to update/delete information about other members, curriculums, schools, etc. Only the administrator of the database can have access to the update forms. Develop an ASP.NET web application that will enable the users to access the database and perform the activities described above. Your application will have forms similar to the ones described in the VB.NET Application section Welcome Screen Updates MBA Programs MBA Curriculum MBA Alumni Current Students Reference D. Windsor and F. D. Tuggle, "Redesigning the MBA curriculum, Interfaces 12(4): 72-77, 1982 Login Red Present Results Excit the Database In the welcome screen, the user can choose one of the five options presented. We give details about the forms or set of forms to be included in each option, however, you are encouraged to add other forms you find important MBA Programs. The user can search the database to retrieve information about the business schools that offer MBA programs. We suggest that the search queries and forms already created in the Access Application Development section be included in here. These forms will enable the user to identify the best MBA programs in the nation, the placement of an MBA program of preference, etc. 3. (40 points) 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. Redesigning the MBA curriculum 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 Accounting Communications Information Systems Managerial Economics Organizational Behavior Quantitative Methods Functional Applications Finance Human Resources Marketing Production and Operations General Management Economic System International Marketplace Legal and Governmental Processes Society and Ethics Strategy, Planning, Policy Sectoral and Institutional Areas Arts Management Educational Administration Health Care Management Public Management 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. 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. Create a query that prompts for the name of a school and returns the following information: 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 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 Forms: 1. Create a user sign-in form together with a registration form for new users. 2 Create the following data entry forms that are used for database administrative functions: curriculums, schools, students, courses, etc. These forms allow the user to add, update, and delete information about curriculums, schools, students, courses, etc. 3. Create a form that allows the user to select from a combo box the name of a Business School. Create a subform that presents the following information about the selected school: social security number and name of the students who are currently enrolled in the program. Create a form that allows the user to browse through the information about the who are currently enrolled in an MBA program. Create a subform that presents the following information about a student social security number, name, address, enrollment date, and a list of courses taken so far. Group the courses by type (foundational, functional, general, or institutional) 5. Create a form that allows the user to choose a particular curriculum from a list box Create a subform that presents for the chosen curriculum the name and code of the courses offered. 6. We designed a number of queries that help identify the best MBA programs in the nation. Create a form that enables the user to run these queries. Command buttons can be used for this purpose. Name this form identifying the Best MBA Programs." When the user clicks on a particular command button, one of the queries is run, and the outcome is presented. Design a logo for this database. Put this logo in the forms created above as well as on the reports that you will be creating next Include the following in the forms created record navigation command buttons, record operations command buttons, and form operations command buttons as needed 2. 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 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. Reports 1. Prepare a report on existing curriculums. This report should include information such as the number of schools currently using that curriculum, the courses offered, and the date the curriculum was last updated. 2 Every month, MBA students get a newsletter. Use the label wizard to create labels with the address of the students who are currently enrolled in an MBA program 3. Use the chart wizard to plot the following: a The total number of students graduated from an MBA program per year during the last ten years. b. The total number of students enrolled in an MBA program per year during the last ten years. C. The total number of MBA graduates who have a top management position. To build this plot use the data about MBA graduates of the last ten years. d. The number of AACSB accredited MBA programs per year for the last ten years. e The average student faculty ratio of each MBA program. [ Average GPA of MBA graduates per year during the last ten years. 4. Report for each of the current students the classes they have taken Group the classes by type 5. List the schools that are AACSB accredited. MBA Curriculum The user can browse the database to leam more about curriculums offered in business schools. The user can identify the most successful curriculums, the courses included in a particular curriculum, etc. MBA Alumni. This option provides information about MBA graduates. We encourage the use of statistical analysis tools, usage of plots (similar to the ones created in the Access Application Development section), etc. that enable the user to draw conclusions about the placement of an MBA program Current Students: This option provides information about current MBA students. Update: The update form requires an administrator login name and password. This form allows the user to add delete update the information kept in this database about MBA programs, students, etc Visual Basic.NET Application Development This database application can be used by prospective MBA students, companies that plan to hire MBAs, the database administrator, etc. In the following figure we present a tentative layout of the system. Web Extension Users of this database are alumni, current students, professors, companies, etc. A user can access the database from a personal computer at home or in the office. To be able to use the database, a user should be a member and have a login name and password. To become a member, the user should submit the following information: name name of the employer (if applicable), address, profession, etc. The user should be able to search the database to find out about the current curriculums, AACSB accredited schools, etc. A member, however, should not be allowed to update/delete information about other members, curriculums, schools, etc. Only the administrator of the database can have access to the update forms. Develop an ASP.NET web application that will enable the users to access the database and perform the activities described above. Your application will have forms similar to the ones described in the VB.NET Application section Welcome Screen Updates MBA Programs MBA Curriculum MBA Alumni Current Students Reference D. Windsor and F. D. Tuggle, "Redesigning the MBA curriculum, Interfaces 12(4): 72-77, 1982 Login Red Present Results Excit the Database In the welcome screen, the user can choose one of the five options presented. We give details about the forms or set of forms to be included in each option, however, you are encouraged to add other forms you find important MBA Programs. The user can search the database to retrieve information about the business schools that offer MBA programs. We suggest that the search queries and forms already created in the Access Application Development section be included in here. These forms will enable the user to identify the best MBA programs in the nation, the placement of an MBA program of preference, etc