In this part of the assignment, you will create an E-R model using the Ivey School of Business Doctoral Tracking Database case, using more data details. Review the Ivey case materials and the additional reports as shown below.

Be sure to read the entire case for context and additional information relating to the student, but remember that the core of your model will be on the first paragraph of page 4:

"Of course, basic information had to be kept on each student: first and last name, student number, home address and telephone, office number and office phone, spouse's name, enrollment status (full-time, part-time, on leave or withdrawn). In addition, the date the student enrolled in the program was recorded in order to monitor the university requirement that the doctoral program be completed in a maximum of seven years, and the names of the student's academic advisor, thesis advisor, the members of the thesis examining committee, and the thesis title all had to be recorded. For future reference, the Ph.D. program office also wanted to record each student's date of convocation, whether the thesis contained international content and what the student's first permanent job was after graduation."

[David Kolterman and Sid Huff. 1997. "Ivey School of Business: The Doctoral Tracking Database" Ivey Management Services, case 9A98E015, page 4]

For this model, consider the following

• You are to model the courses that the school offers. Review the sample reports below to identify the information needed related to courses and tracking student and faculty work related to courses.
• As you are modeling the prerequisites, note that (for this assignment) courses in this program have no more than one prerequisite, although they might be the prerequisite for more than one course.

Finish the Ivey model, making the changes recommended in the evaluation of the first part of the assignment and modeling the rest of the case. You must, at the least, model the data necessary to produce sample reports provided in this document, as well as the reports from the previous part.

It is not necessary to model the complete program requirements to successfully complete this model and you should not include this aspect unless the rest of your model is in very good condition.

Make sure to include all entities that are required to enroll students in courses and track their outcomes for the term enrollment report. Keep in mind that just like here at Empire State College, the same course is offered over many terms sometimes in multiple sections for a given term.

Learning Objectives

• Develop Entity-Relationship modeling skills and use correct formatting; model everything in the description in at least third normal form.
• Model data from a set of requirements (using a standard set of techniques).

Format

For the modeling assignment, use the Visio Database Model Diagram with Crow's Foot notation (because, among other reasons, it is much easier to draw). Within the diagram you must specify all entities, attributes (specifying unique identifiers and optionality), and relationships (including cardinality and optionality). Be sure to resolve all many-to-many relationships. The model should be presented no less than third normal form.

Grading Criteria

1. Represent information appropriately
2. Create a well-designed, normalized ER model following all formatting standards
3. Communicate information appropriately and effectively

Of course, you must follow the format requirements. If you have any questions, ask them in a timely manner.

Use the following sample report fragments to help you understand some of the requirements.

Your model should allow for the generation of the following reports (in addition to those from part 1):

Enrollment Report

Term	Course number / name	Section	Professor	Student
Fa2016	701a Microeconomics	1	Baryshinokov, Mikhail	Alcott, Louisa Mae
				Asimov, Isaac
				Walker, Alice
Fa2016	701a Microeconomics	2	Mitchell, Arthur	cummings, ee
				Singer, Isaac Bashevis
				Vonnegut, Kurt
Fa2016	702a Statistics I	1	Alonso, Alicia	cummings, ee
				Walker, Alice

Course Completion Status Report

Student	Course	Status
Alcott, Louisa Mae	701a Microeconomics	In progress
	702a Statistics I	incomplete
	703a International Business	incomplete
Asimov, Isaac	701a Microeconomics	In progress
	702a Statistics I	Waived
	703a International Business	incomplete
cummings, ee	701a Microeconomics	In progress
	702a Statistics I	In progress
	703a International Business	B+

Course Sequence Report

Course	Prerequisite
712 Statistics II	702 Statistics I
722 Research Apprenticeship II	712 Research Apprenticeship I

Advisor Report

Advisor	Student
Alonso, Alicia	Alcott, Louisa Mae
	Singer, Isaac Bashevis
Baryshinokov, Mikhail	cummings, ee
	Vonnegut, Kurt

Thesis Committee

Student	Committee member	Chair?
cummings, ee	Alonso, Alicia
	Fonteyn, Dame Margot	yes
	Tudor, Antony
Walker, Alice	Fonteyn, Dame Margot
	Balanchine, George
	Graham, Martha	yes