each school offers different professional study programs such as Forensic Computer Science, Marine Biology, Business Management, and Civil Engineering to name a few.
The study path for students requires that they be enrolled in a specific professional study program. The professional study program requires the students to complete a specific set of core courses. The university also requires that an online grade book be available. The online grade book should show grades awarded to students for specific courses and the term they completed the course.
The university identifies each student by his or her name, date of birth, social, and professional study program.
Using 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:
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.