Project #58013 - M2 Ivey School of Business: Doctoral Tracking Database - Part 2

M2 Ivey School of Business: Doctoral Tracking Database - Part 2

Assignment: create an E-R model using the Ivey School of Business Doctoral Tracking Database case

For this part of the assignment, you will only be modeling part of the information - the basic information that must be kept about each student. Be sure to read the entire case for context and additional information relating to the student, but 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.

Goals:

  • Develop Entity-Relationship modeling skills - use correct format; model everything in the description but nothing that is unclear in the description.
  • Model data from a set of requirements (using a standard set of techniques).

The sample reports, format requirements and a reminder about the grading criteria for the assignment are provided in the documents that follow.

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 (and consistent with the convention you have selected), 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.
  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.

If the model you are creating were implemented, it should allow for the generation of the following reports:

Student Status Report

StudentCurrent enrollment statusYears enrolledAcademic advisor
Alcott, Louisa Mae full-time 5 Graham, Martha
Asimov, Isaac part-time 3 Baryshinokov, Mikhail
Bronte, Emily withdrawn 1 Robbins, Jerome
cummings, e e full-time 7 Mitchell, Arthur
Eliot, Thomas Sterns on leave 5 Jooss, Kir
Shelly, Mary Wollstonecraft on leave
3
Mitchell, Arthur
Singer, Isaac Bashevis full-time 4 Nureyev, Rudolf
Vonnegut, Kurt part-time 2 Astaire, Fred
Walker, Alice full-time 4 Astaire, Fred

Thesis Committee Report

StudentThesis titleThesis advisorThesis committee members
Alcott, Louisa Mae Little Women Holm, Hayna Astaire, Fred
      Baryshinokov, Mikhail
      Graham, Martha
      Kelly, Gene
Asimov, Isaac I, Robot Jooss, Kir de Mille, Agnes
      Graham, Martha
      Nureyev, Rudolf
      Robbins, Jerome
Eliot, Thomas Stern Is 5 Alonso, Alicia Dunham, Katherine
      Fonteyn, Dame Margot
      Nureyev, Rudolf
      Vestris, Gaetano
Shelly, Mary Wollstonecraft Frankenstein, or the Modern Prometheus Mitchell, Arthur Astaire, Fred
      Baryshinokov, Mikhail
      Pavlova, Anna Matveyevna
      Robinson, Bill (Bojangles)

Subject Computer
Due By (Pacific Time) 02/17/2015 10:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy