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: 1 year ago

Preview 1 out of 9 pages

Add to cart

Instant download

Reviews( 0 )

$11.00

Add to cart

Instant download

Can't find what you want? Try our AI powered Search

OR

REQUEST DOCUMENT
33
0

Document information


Connected school, study & course


About the document


Uploaded On

Jul 31, 2021

Number of pages

9

Written in

Seller


seller-icon
Cheryshev

Member since 3 years

102 Documents Sold


Additional information

This document has been written for:

Uploaded

Jul 31, 2021

Downloads

 0

Views

 33

Document Keyword Tags

Recommended For You

Get more on EXAM »

$11.00
What is Browsegrades

In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.

We are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 FAQ
 Questions? Leave a message!

Follow us on
 Twitter

Copyright © Browsegrades · High quality services·