University Database

University Database

Samantha Jackson

Strategic Planning for Database CIS_515

Dr. Osama Morad

January 25, 2014

The director at a prestigious university has requested that a centralized system be used to as a consolidation strategy to keep track of student records. By doing so the student records will be situated in one central location. In doing so the university will have to develop a data model that will maintain the student records and complete a variety of data (ETL) extract transform and load processes. In meeting with the several of the university subject matter experts, the following information was brought to light and after the experts analyzed and performed various business process (Strayer University, 2014):

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 (Strayer University, 2014).

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...