Computer Science > EXAM > CIS165 DATA BASE MANAGEMENT SYSTEMS Final Exam WITH SOLUTIONS (All)

CIS165 DATA BASE MANAGEMENT SYSTEMS Final Exam WITH SOLUTIONS

Document Content and Description Below

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]

Last updated: 2 years ago

Preview 1 out of 9 pages

Buy Now

Instant download

We Accept: