Project #42403 - Database small project to complete in Visio

 

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 (attached)

 

For this part of the assignment, you will only be modeling part of the info - 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 attached reports:

 

Subject Computer
Due By (Pacific Time) 10/06/2014 08: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