Task Three: College DatabaseA prestigious college has not too long ago carried out a consolidation technique that can require it to centralize their pupil information. As a way to transfer ahead, the native college might want to develop a knowledge mannequin that can retain pupil information and carry out numerous information extract remodel and cargo (ETL) processes. Think about that you’ve been employed as a database marketing consultant to help within the growth of a knowledge design technique for the scholar information. You met with numerous college subject material consultants and have decided the next after performing numerous enterprise evaluation processes:School teams are divided by core competencies that the college affords. For instance, there are teams such because the Artwork School, Pc Know-how School, Language School, and Science School. Every school member has an assigned Dean and is designated to show at one explicit campus and faculty. They can train as many programs as required.Programs are categorized by course code and title. Sure programs have stipulations and the college has requested for this to be cataloged as nicely.There are numerous colleges inside every campus. For instance, the Los Angeles campus holds the next colleges: Faculty of Science, Faculty of Legislation, and Faculty of Pc Know-how. Moreover, every college affords totally different skilled examine applications equivalent to Forensic Pc Science, Marine Biology, Enterprise Administration, and Civil Engineering to call just a few. The examine path for college kids requires that they be enrolled in a particular skilled examine program. The skilled examine program requires the scholars to finish a particular set of core programs. The college additionally requires that a web-based grade guide be out there. The web grade guide ought to present grades awarded to college students for particular programs and the time period they accomplished the course.The college identifies every pupil by his or her identify, date of start, social, examine program.Utilizing these findings, write a 3 to 4 (Three-Four) web page paper during which you:Analyze the college’s necessities and supply a proposal to prepare all of the required information components. The proposal ought to embody the next: Present an Entity Relationship Mannequin (ERM) that can describe the information construction that can retailer all information components. Observe: The graphically depicted answer isn’t included within the required web page size.Describe any assumptions or limitations for every relationship. For instance, professors are capable of train multiple course or college students can solely be enrolled in a single program.Create the first key and overseas keys utilizing a UML Class diagram for every desk.Recommend a minimum of 4 (Four) kinds of enterprise intelligence experiences that might assist the college in course administration, pupil enrollment, or historic monitoring. Assist your reply by offering particular enterprise features that these experiences might help executives of the college.Instead for growth of the database, you’re contemplating outsourcing the features above. Analysis the Web and different media sources for distributors who develop registrar and faculty administration database techniques. Recommend three (Three) distributors that developed and are using environment friendly registrar and faculty administration database techniques and help your causes to select from one (1) of those three (Three) distributors.Evaluate and distinction the important thing elements that every system affords. Examples of system elements embody however not restricted to cloud based mostly, pricing mannequin, open supply, and so forth.Use a minimum of three (Three) high quality sources on this task. Observe: Wikipedia and related Web sites don’t qualify as high quality sources.Your task should comply with these formatting necessities:Be typed, double spaced, utilizing Instances New Roman font (dimension 12), with one-inch margins on all sides; citations and references should comply with APA or school-specific format. Verify along with your professor for any further directions.Embody a canopy web page containing the title of the task, the scholar’s identify, the professor’s identify, the course title, and the date. The quilt web page and the reference web page usually are not included within the required task web page size.Embody charts or diagrams created in Excel, Visio, MS Venture, or one in every of their equivalents equivalent to Open Venture, Dia, and OpenOffice. The finished diagrams / charts should be imported into the Phrase doc earlier than the paper is submitted.The precise course studying outcomes related to this task are:Describe the position of databases and database administration techniques in managing organizational information and knowledge.Acknowledge the historic growth of database administration techniques and logical information fashions.Design and implement a database answer to resolve a proposed enterprise downside.Use know-how and knowledge sources to analysis points within the strategic implications and administration of database techniques.Write clearly and concisely about matters associated to the strategic planning for database techniques utilizing correct writing mechanics and technical type conventions.