Question Details

(solution) Simplified Entity Relationship Diagram & Data Structure


I need someone to complete this homework assignment for me.

Assignment: Entity Relationship Diagrams      

Scenario:

Dick Scudder, the chairperson of the information technology department at the University of Denver, needs to create a database to keep track of all the courses offered by the department. In addition, Dick would like the database to include each instructor?s basic contact information, such as ID number, name, office location, and phone number. Currently, Dick has nine instructors (seven full-time faculty members and two adjuncts) in the department.

For each course, Dick would like to keep track of the course ID, title, and number of credit hours. When courses are offered, the section of the course receives a Section ID number, and with that number, the department keeps track of which instructor is teaching the course.

Finally, Dick needs to be able to keep track of the IT students and to know which sections of the courses each student has taken and the grade they received. The information he would like to know about each student includes ID number, name, and phone number.

Dick has asked you to create an ERD from the information described above, and then create a normalization structure (DSD) in 3NF.

Assignment:

So, for this assignment, you will identify the entities needed for representing this database and the attributes associated with each entity. Each entity must have a minimum of 2 attributes (although more may be necessary depending on what information is needed to be stored for each entity). You will also create a simplified Entity-Relationship Diagram (ERD) and a simplified Data Structure Diagram showing the relationships between each of the entities.

For the ERD, you should use rectangles to represent the entities with appropriate names. Associative entities (those which are used to represent many-many relationships) will have a diamond inside the rectangle. Use arrows to represent the relationship and direction of the relationship between the entities (a dot on one side of the arrow represents the ?1? side of the relationship and an arrow represents the ?many? side of the relationship).

For the DSD, use rectangles for each entity with a row for the name of the entity (highlighted and underlined), and additional rows for the names of each of the attributes of the entity. Primary Key attributes should be bolded and Foreign Key attributes should be italicized.

A sample is attached below with several pages.


Simplified Entity Relationship Diagram & Data Structure Diagram

 

Example

 

Problem Description:

 

SportTech Events puts on athletic events for local high school athletes. The company

 

needs a database designed to keep track of the sponsor(s) for the event and where the

 

event is located. Each event needs a description, date, and cost. Separate costs are

 

negotiated for each event. The company would also like to have a list of potential

 

sponsors that includes each sponsor?s contact information such as the name, phone

 

number, and address. Each event could have many sponsors, and a particular sponsor

 

may sponsor more than one event. Each location will need an ID, contact person, and

 

phone number. A particular event will use only one location, but a location may be used

 

for multiple events. SportTech asks you to create an ERD from the information described

 

above, and then create a normalization structure in 3NF. Potential

 

Sponsor Sponsor Event Location SPONSOR

 

SponsorID

 

Name

 

PhoneNumber

 

Address

 

City

 

State

 

Zip POTENTIAL_

 

SPONSOR

 

SponsorID

 

EventID

 

IsSponsor

 

SponsorLevel EVENT

 

EventID

 

LocationID

 

Description

 

Date

 

Cost LOCATION

 

LocationID

 

Name

 

Contact

 

PhoneNumber

 

Address

 

City

 

State

 

Zip

 


Solution details:

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 13, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now