Szabo - CIS2165 --- DATA BASE MANAGEMENT SYSTEMS
Data Base Design Final Exam (50 pts.)
Name: Rohan Vaikkath___________________
1. A public relations company wants a database developed to track its clients’ special
ev
...
Szabo - CIS2165 --- DATA BASE MANAGEMENT SYSTEMS
Data Base Design Final Exam (50 pts.)
Name: Rohan Vaikkath___________________
1. 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.
Identify any assumptions you made that will assist in my understanding of your
solution. (Must be included)
Solution. (1):
Tables
Event Table:
Event ( event_id , Event_name, Duration, Fees)
Client Table:
Client ( client_id ,Event_id, Client Name, Address, City, Phone)
Foreign key-> Event_id From Event table
Attendee Table:
Attendee ( attendee_ id , Attendee Name, Event_id, Client_id, Event_attendance)
Foreign key-> Event_id From Event table
Foreign key-> Client_id From Client table
Guest table:
Guest(guest_id , Guest_name, Interest, Organization, Phone, Event_id )
Foreign key-> Event_id From Event table
[Show More]