Question

Fly-By-Night University (FBNU) has several campuses and has recently decided to centralize their student records. The university’s main office needs to develop a new system to house student records and course information. You have been hired to make recommendations regarding the design of the new system. You have met with key personnel for the purposes of requirements gathering. You have analyzed the current system and the goal for the future system.

These are the items you have determined:

Faculty are grouped based on their subject matter expertise. For example, there is English faculty, CIS/IT faculty, Management faculty, etc. Every faculty group has a dean. Each professor is assigned a specific school and campus. Faculty are allowed to teach any course within their subject matter area.

Courses will have a title, but are categorized by a course code. Some courses have prerequisites, which need to be recorded so that students are not able to bypass the prerequisites.

There are various campuses within the state. For example, there is a San Francisco campus and a Los Angeles campus.

Each campus may have its own schools. For example, the Los Angeles campus has a School of Business, a School of Liberal Arts, and a School of Technology.

Each school offers multiple programs of study. For example, the School of Business may offer degrees in management, marketing, accounting, etc.

Students are required to be enrolled in a specific program of study. Each program of study has a set of core courses that need to be completed in addition to elective courses.

The university identifies each student by name, date of birth, student ID, and program of study.

Using the results from requirements gathering, write a report in which you:

Analyze the requirements and write a proposal for the university’s new database and system. You will need to organize al of the required data elements in a manner understandable to management. Your proposal should include the following:

Provide an entity-relationship model (ERM) that will fully describe the new data structure. Be sure to include all data elements.

Describe the assumptions or limitations for each relationship. For example, students are only allowed to be enrolled in one degree program at a time; faculty are confined to teaching courses within their subject matter area.

In your ER diagram, depict the primary key and foreign keys for each entity.

Suggest at least three Web applications that need to be developed for the new data management strategy.

Depending on the required time and resources for a project of this magnitude, the university has indicated they are open to outsourcing the project. Perform some research and look for vendors who develop registrar and school management database systems.

Suggest three vendors that could develop and implement a school-management database system. Explain the benefits of choosing from one of these vendors.

Compare and contrast the key benefits for each system. Examples might be full customization, a cloud-based model, scalability, strong support.

Avoid writing in an “essay” style. You are not writing an academic research paper; you are writing a proposal for a simulated real-world scenario.

Length: 3-4 pages

Answer 1

As per your requirement, Fly-By-Night University (FBNU) mains office needs to maintain student records and their course information.

Based on the following requirements we will have the following Entities in the ER Diagram: (underlined attributes are primary keys ):-

1. Student - Student_ID, Student_Name, CourseCode, Programme_of_Study, Date_of_Birth

2. Courses - CourseCode, Campus_ID, Prerequities, School_ID, Title (derived attributes)

3. School - School_ID, Programme_of_Study

4. Faculty - Faculty_ID, Prof_Name, Dean, CourseCode, Subject_of_Study

5. FacultyGroup - Faculty_ID, Campus_ID, School_ID, Subject_of_Study (Foreign Key)

6. Campus - Campus_ID, School_ID (Foreign Key)

Based on your requirements:

1. A campus may have its own schools