CIS 515 STUDY Learn Do Live /cis515study.com CIS 515 STUDY Learn Do Live /cis515study.com | Page 7

This Tutorial contains 2 Papers
CIS 515 WEEK 3 ASSIGNMENT 3 UNIVERSITY DATABASE
Assignment 3: University Database
Due Week 3 and worth 90 points
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,