MBA 8660 Case Study- Final Exam Fall 2022

ABC University is a large institution with several campuses. Each campus has a different Name, address, distance to the city center, and the only bus running to the campus. Each campus has one club. The name of the club, the build club’s phone number, and the multiple sports the club offers should all be recorded.
ABC University comprises several groups of faculties, including the Art Faculty, the Science Faculty, and so on. Each faculty has a name, dean, and building.

Several groups of faculties may be forced into several schools; for example, the Science Faculty has a Physics and a Chemistry school. Every school has a name and building assigned. Each school offers different programs and can be offered by only one school. Each program has a unique code, title, level, and duration. Each program comprises several courses, and different programs have different courses. Each course has a unique code and course title. Some courses may have one or more prerequisite courses, and one can be the prerequisite for others. Each student is enrolled in a single program of study, which involves a fixed core of courses specific to that program and several electives taken from other programs. Students work on courses and are awarded a grade in any course if they pass the course. Otherwise, the student must retake the failed course. The system needs to record the year and term in which the course was taken and the grade awarded to the student. Every student has a unique ID. The system also keeps the student’s name, birthday, and the year they enrolled in the course.

You (MBA 8660 Consultants Inc.) have been hired to oversee the implementation and utilization of this database across ABC University. You have two weeks before your database project kickoff meeting with the Provost, President, and Cabinet of ABC University. Please answer the question below to help you plan your database project kickoff meeting with the Provost, President, and Cabinet of ABC University.

Instructions: Write a four to five-sentence introduction (150 Words or so), a body (600 Words or so), and a conclusion (150 Words or so) for your response. Write your answer in Microsoft Word to ensure your word count is accurate and you fix significant grammatical errors before submission. Answers under 825 words will automatically have 45 out of the possible 190 points deducted.

Scoring Structure: 100 Points for Substance (Is your response reasonably aligned with common business logic and the material presented throughout the course- Chapters 3, 4, and 7), 45 Points for demonstrating attention to detail by hitting the appropriate word count and structure described in the instructions. The remaining 45 Points will be distributed for response readability (Can you write in straightforward language).