CJA 364 Assignment 3 University Database Analyze the university’s requirements and provide a propos

This preview shows page 1 - 2 out of 7 pages.

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Accounting Information Systems
The document you are viewing contains questions related to this textbook.
Chapter 5 / Exercise P5-11
Accounting Information Systems
Dull/Gelinas
Expert Verified
CIS 515 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.
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Accounting Information Systems
The document you are viewing contains questions related to this textbook.
Chapter 5 / Exercise P5-11
Accounting Information Systems
Dull/Gelinas
Expert Verified

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture