Chat with us, powered by LiveChat Develop an entity relationship diagram for the MPA database. Diagram: Using Visio: Begin with the ?Crow's Foot Database Notation' Visio template. Include these five entities: | WriteDen

Develop an entity relationship diagram for the MPA database. Diagram: Using Visio: Begin with the ?Crow’s Foot Database Notation’ Visio template. Include these five entities:

Task: Develop an entity relationship diagram for the MPA database.

Diagram: Using Visio:

  • Begin with the ”Crow's Foot Database Notation" Visio template.
  • Include these five entities: 
    • Student
    • Teacher
    • Event
    • Award
    • Music — see below for attribute ideas
  • All reasonable attributes should be included for each entity.
  • A logical primary key (a unique attribute) must be clearly identified for each entity.
  • Foreign keys must be included to be able to connect the entities properly.
  • Crow's feet must be used to show cardinalities. Crow's feet are  shown in the textbook, Figure 13.3, and the Reading PDF explains how to  create these from ordinary arrows/lines.
  • Example ERDs are found in the Unit 3 Reading PDF.
  • Use consistent case (Pascal, camel, small case, or underscore).

Also consider:

  • Each teacher can have many students.
  • No students have more than one piano teacher.
  • Each student can play many pieces.
  • Each student can participate in events, but they do not have to participate.
  • Not all participants win awards.
  • Teachers must have some credentials (usually a college degree).
  • Attributes for the Music entity would include title, composer, publisher, difficulty, etc.
  • Contact information is crucial for all people involved. Check the Reading PDF regarding addresses.
  • To add an attribute to an entity, click the attribute shape and drag  it onto the stage and right under the entity. It should click into  place.

 Entity Table

Task: Develop one table for detailing either the  Student or the Event entity. (Create only one table, as this is an  example for your client, not details of the entire database.) Provide  this information in a Word table in the same format as the example found  in the Unit 3 Reading PDF.

Table: Include the following for your chosen entity in a Word table:

  • A suitable entity name.
  • Attributes: minimum 6 (take these from your ERD).
  • Designate the primary key.
  • Include the data type for each attribute: choose from those listed in the textbook Figure 8.7.
  • Specify the logical length for each attribute.
  • Include whether or not each attribute is required.
  • Use consistent case (Pascal, camel, small case, or underscore).

    This question was first posted at collepals.com!

    Order this paper at collepals.com for only $10

    Visit Collepals.com Now!

    HOW OUR WEBSITE WORKS

    Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of 
    HIGH QUALITY & PLAGIARISM FREE.

    Step 1

    To make an Order you only need to click ORDER NOW and we will direct you to our Order Page at WriteDen. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
     Deadline range from 6 hours to 30 days.

    Step 2

    Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email.

    Step 3
    Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost.

    Is it Safe to use our services?
    We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper.

    Discounts

    Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

    Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you.