CIS 515 All Assignments CIS 515 All Assignments | Page 8

Analyze the university’s requirements and provide a proposal to organize all the required data
elements. The proposal should include the following:
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.
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 reports that could help the university in
course mana