University Database

A prestigious university has recently implemented a consolidation strategy that will require it to centralize their student records. In order to move forward, the local university will need to develop a data model that will retain student records and perform various data extract transform and load (ETL) processes. Imagine that you have been hired as a database consultant to assist in the development of a data design strategy for the student records.

You met with various university subject matter experts and have determined the following after performing various business analysis processes:

• Faculty groups are divided by      core competencies that the university offers. For example, there are      groups such as the Art Faculty, Computer Technology Faculty, Language      Faculty, and Science Faculty. Each faculty member has an assigned Dean and      is designated to teach at one particular campus and school. They are able      to teach as many courses as required.
• Courses are categorized by      course code and title. Certain courses have prerequisites and the      university has asked for this to be cataloged as well.
• There are various schools      within each campus. For example, the Los Angeles campus holds the      following schools: School of Science, School of Law, and School of      Computer Technology. Additionally, each school offers different      professional study programs, such as Forensic Computer Science, Marine      Biology, Business Management, and Civil Engineering to name a few.
• The study path for students      requires that they be enrolled in a specific professional study program.      The professional study program requires the students to complete a      specific set of core courses. The university also requires that an online      grade book be available. The online grade book should show grades awarded      to students for specific courses and the term they completed the course.
• The university identifies      each student by his or her name, date of birth, social, and professional      study program.

Using these findings, write a 3–4 page paper in which you:

• Analyze the university’s      requirements and provide a proposal to organize all the required data      elements. The proposal should include the following:
• Provide an Entity      Relationship Model (ERM) that will describe the data structure that will      store all data elements. Note: The graphically depicted solution is not      included in the required page length.
• Describe any assumptions or      limitations for each relationship. For example, professors are able to      teach more than one course or students can only be enrolled in one      program.
• Create the primary key and      foreign keys using a UML Class diagram for each table.
• Suggest at least 4 types of      business intelligence reports that could help the university in course      management, student enrollment, or historical tracking. Support your      answer by providing specific business functions that these reports could      be used for to assist executives of the university.
• As an alternative for      development of the database, you are considering outsourcing the functions      above. Research the Internet and other media sources for vendors who      develop registrar and school management database systems.
• Suggest 3 vendors that      developed and are employing efficient registrar and school management      database systems and support your reasons to choose from 1 of these 3      vendors.
• Compare and contrast the key      aspects that each system offers. Examples of system aspects include but      are not limited to cloud based, pricing model, open source, et cetera.
• Go to the Strayer Library to locate at least 3 quality resources in this      assignment. Note: Wikipedia and similar websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:

• Paper must be typed,      double-spaced, and use Times New Roman font (12-point), with one-inch      margins on all sides; citations and references must follow APA or      school-specific format. Check with your professor for any additional      instructions.
• Include a cover page      containing the title of the assignment, your name, your professor’s name,      the course title, and the date. The cover page and the reference page are      not included in the required assignment page length.
• Include charts or diagrams      created in any chart or drawing tool with which you are familiar. The      completed diagrams or charts must be imported into the Word document      before the paper is submitted.