(solution) Simplified Entity Relationship Diagram & Data Structure

(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