Question: Please help me check if my answer is right for this Databse task.A public relations company wants a database developed to track its clients' special

Please help me check if my answer is right for this Databse task.A public relations company wants a database developed to track its clients'
special events, and attendees at these events. The public relations company also
maintains a file of contacts - people who receive mailings or are invited to events.
These people have areas of interest (such as Business, Arts, Sports etc.), and they
are affiliated with organizations of one of the following types: Print Media, TV
Media, Radio Media, Other, Non-media Corporation or Non-Media Non Profit.
The public relations company gets information about the events, invites the
potential attendees and maintains a list of who will be attending each event.
Create a set of tables for the company in 3NF. Represent your answer in DBDL.(i.e.
give table name and fields. Underline the primary key.) Draw an entity-relationship
diagram. (10 pts.)
Note: for all ER-Diagrams on this test, it is not necessary to list the attributes, just use
rectangles with appropriate connecting lines to document Entities and Relationships.
Identify any assumptions you made that will assist in my understanding of your
solution. (Must be included)
Event(EventID, ClientID, EventDetails, EventDate)
Client(ClientID, ClientName, ClientContactInfo)
Contact(ContactID, ContactName, ContactAffiliation, ContactInterestArea,
ContactOrganizationType)
Attendance(EventID, ContactID)
Please help me check if my answer is right for

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!