Assignment 3: University Database | Complete Solution

Assignment 3: University Database

Using these findings, write a three to four (3-4) page paper in which you:
1. Analyze the university’s requirements and provide a proposal to organize all the required data elements. The proposal should include the following:
a. Provide an Entity Relationship Model (ERM) that will describe the data structure that will store all data elements. Note: The graphically depicted solution is not included in the required page length.
b. Describe any assumptions or limitations for each relationship. For example, professors are able to teach more than one course or students can only be enrolled in one program.
2. Create the primary key and foreign keys using a UML Class diagram for each table.
3. Suggest at least four (4) types of business intelligence reports that could help the university in course management, student enrollment, or historical tracking. Support your answer by providing specific business functions that these reports could assist executives of the university.
4. As an alternative for development of the database, you are considering outsourcing the functions above. Research the Internet and other media sources for vendors who develop registrar and school management database systems.
a. Suggest three (3) vendors that developed and are employing efficient registrar and school management database systems and support your reasons to choose from one (1) of these three (3) vendors.
b. Compare and contrast the key aspects that each system offers. Examples of system aspects include but not limited to cloud based, pricing model, open source, etc.
CIS 515 – Assignments and Rubrics
©2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
CIS 515 Student Version 1126 (1139 5-16-2012) Final Page 12 of 38
5. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
· Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
· Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
· Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams / charts must be imported into the Word document before the paper is submitted.
The specific course learning outcomes associated with this assignment are:
· Describe the role of databases and database management systems in managing organizational data and information.
· Recognize the historical development of database management systems and logical data models.
· Design and implement a database solution to solve a proposed business problem.
· Use technology and information resources to research issues in the strategic implications and management of database systems.
· Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions.