## (solution) Simplified Entity Relationship Diagram &amp; 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 &amp; 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

Name

PhoneNumber

City

State

Zip POTENTIAL_

EventID

EventID

LocationID

Description

Date

Cost LOCATION

LocationID

Name

Contact

PhoneNumber

City

State

Zip

Solution details:

STATUS

QUALITY

Approved

Sep 13, 2020

EXPERT

Tutor