CIS 515 STUDY Future Starts Here/cis515study.com CIS 515 STUDY Future Starts Here/cis515study.com | Page 8

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 Ange