Assignment 3: University Database

  A  prestigious university has recently implemented a concert  strategy that procure claim it to persomalize their ward memorials. In  order to stir presumptuous, the persomal university procure need to enunciate a postulates  type that procure keep ward memorials and effect different postulates draw  transform and advise (ETL) processes. Imagine that you entertain been remunerated as a  database consultant to succor in the enunciatement of a postulates guile  strategy for the ward memorials.  You  met forthcoming a while different university question substance experts and entertain immovtalented  the forthcomingcited forthcoming effecting different trade dissection processes: Faculty  groups are disconnected by heart competencies that the university offers. For  example, there are groups such as the Art Faculty, Computer Technology  Faculty, Language Faculty, and Science Faculty. Each endowment portion has  an assigned Dean and is guileated to tell at one point campus and  school. They are talented to tell as sundry methods as claimd. Courses  are categorized by method decree and designation. Certain methods entertain  prerequisites and the university has asked for this to be cataloged as  well. There  are different grounds forthcoming a whilein each campus. For in, the Los Angeles  campus holds the forthcomingcited grounds: Ground of Science, Ground of Law,  and Ground of Computer Technology. Additionally, each ground offers  different functional consider programs such as Forensic Computer Science,  Marine Biology, Trade Management, and Civil Engineering to spectry a  few.  The  consider pathwayway for wards claims that they be enrolled in a favoring  functional consider program. The functional consider program claims the  students to exhaustive a favoring set of heart methods. The university besides  requires that an online measure bulk be serviceable. The online measure bulk  should profession measures awarded to wards for favoring methods and the engagement  they exhaustived the method. The university identifies each ward by his or her spectry, epoch of family, gregarious, and functional consider program. Using these findings, transcribe a three to filthy (3-4) page tract in which you: Analyze  the university’s claimments and yield a overture to shape all  the claimd postulates elements. The overture should conceive the forthcomingcited: Provide an Entity Interdependence Type (ERM) that procure depict the postulates constitution that procure fund all postulates elements. Note: The graphically depicted separation is not conceived in the claimd page diffusiveness. Describe  any assumptions or limitations for each interdependence. For in,  professors are talented to tell over than one method or wards can singly  be enrolled in one program. Create the elementary key and strange keys using a UML Class diagram for each board. Suggest  at lowest filthy (4) types of trade instruction reports that could  help the university in method government, ward enrollment, or  historical tracking. Foundation your counterpart by providing favoring trade  functions that these reports could succor executives of the university. As  an reorigin for enunciatement of the postulatesbase, you are because  outsourcing the functions overhead. Research the Internet and other media  sources for vendors who enunciate registrar and ground government postulatesbase  systems. Suggest  three (3) vendors that enunciateed and are employing causative registrar  and ground government postulatesbase arrangements and foundation your reasons to  choose from one (1) of these three (3) vendors. Compare  and contrariety the key aspects that each arrangement offers. Examples of  arrangement aspects conceive but not scant to shade grounded, pricing type,  open origin, etc. Use at lowest three (3) condition instrument in this assignment. Note: Wikipedia and congruous Websites do not render-capable as condition instrument. Your assignment must prosper these formatting claimments: Be  typed, double spaced, using Times New Roman font (magnitude 12), forthcoming a while  one-inch margins on all sides; citations and allusions must prosper APA  or ground-favoring format. Check forthcoming a while your zealot for any additional  instructions. Include  a meet page containing the designation of the assignment, the ward’s  name, the zealot’s spectry, the method designation, and the epoch. The meet  page and the allusion page are not conceived in the claimd assignment  page diffusiveness. Include  charts or diagrams created in any chart or sketch tools forthcoming a while which you  are household. The exhaustived diagrams / charts must be indispensable into the  Word muniment precedently the tract is submitted.