CIS 515 Assignment 3 University Database




CIS 515 Assignment 3 University DatabaseUsing these findings, write a three to four (3-4) page paper in which you: 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. Create the primary key and foreign keys using a UML Class diagram for each table. Suggest at least four (4) types of business intelligence…