Reference no: EM132105676

Prestige College wants you to develop a database to maintain information about its operation and programs. Based on initial interviews, the following reporting requirements were established as a starting point for database development. The reporting requirements are specified in terms of views that can be implemented as reports or forms. So, based on these views, you need to identify underlying entity sets and relationship types for your ERD when working on conceptual modeling. The last thing you may want to do is to simply create a table for each of the views presented below. View 1: Information is needed about each course to include the following: Course Number, Course Title, Number of Credits, Department Number (department number where the course is offered) and Department Name (department where the course is offered). View 2: Information is needed about each department to include the following: Department Number and Department Name, Office Number, and Chairperson (first and last names only) View 3: Information is needed about each major to include the Major Number, Major Name, Department Name (housing the major), Department Number (housing the major), Number of Required Credits, Number of Required Semesters, and Minimum GPA to complete. View 4: Information is needed about each student to include the Student Number, Student Name, Student Address (street#, street name, apt #. city, state, and ZIP code), Start Date (Semester, Year), Major Number, Major Name (or Title), Department Number (housing the major), Department Name (housing the major), Advisor Number, Advisor Name, Advisor Office Number and Advisor Office Phone Number. View 5: Information is needed about student past records to include the Student Number, Student Name, Number of Courses Taken, Number of Credits Taken, and Grade Point Average. View 6: Information is needed about current student schedules to include Student Number, Student Name, and Course Schedule (to include Course Number, Course Title, and Number of Credits). View 7: Information is needed about advisors to include the Advisor Number, Advisor Name, Supervisor’s name, Advisor Office Number, Advisor Phone Number, and Advisee List (list of students being advised by the advisor), Department Number (the advisor is assigned to), and Department Name (the advisor is assigned to). View 8: Information is needed to show courses that have been completed by the student to include Student Number, Student Name, Course Number, Number of Credits, and Grade for each course attempted by the student. Courses should be grouped by the semester (or date) that the course was completed. View 9: Information is needed about each department to include the Department Number, Department Name, Office Number, Office Location (to include Building Name and Floor) and List of Majors housed in the department, List of Course Numbers and Course Names offered in the department. View 10: Information is needed about each office to include the Office Number, Location (Building Name and Floor), Size (in sq ft), Capacity (Max # of Occupants), and List of Occupants (to include Advisor Names, or Department Name). Assumptions: 1. Students may take more than one course. 1.1. Students can retake a same course multiple times, but the one with the best grade will be recorded on the system. 2. Each course may include more than one student. 3. Each advisor has one office. 4. Each office can house multiple advisors, or one department. 5. Each student will have one advisor. 6. Each advisor may advise many students or no students. 7. Each advisor is assigned to a specific department. 7.1. Each advisor has a supervisor (another advisor) and may supervise other advisors. 8. Each department may contain no advisors or multiple advisors. 9. Each department occupies one and only one office space. 10. Each major has a unique number and a unique name and is housed in a specific department. 11. Each student can major in multiple areas. 12. Each course is offered in a specific department. 13. Each department may offer one or multiple courses. * If necessary, you can make your own additional assumptions to clarify any potential ambiguity in the above assumptions (please, include such assumptions in your final report).