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, Nonmedia Corporation or NonMedia 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 NF Represent your answer in DBDLie
give table name and fields. Underline the primary key. Draw an entityrelationship
diagram. pts
Note: for all ERDiagrams 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
EventEventID ClientID, EventDetails, EventDate
ClientClientID ClientName, ClientContactInfo
ContactContactID ContactName, ContactAffiliation, ContactInterestArea,
ContactOrganizationType
AttendanceEventID ContactID
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
