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 ,