Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please read the following, then prepare the ERD: Conference City (CC) is a company which organises conferences mainly in the computing area. Due to the

Please read the following, then prepare the ERD: Conference City (CC) is a company which organises conferences mainly in the computing area. Due to the success of their business, they have decided to implement a relational database to help with the conference organisation. For each conference they need to keep records of the conference code, conference dates, conference name, days duration and venue. CC are required to keep track of all past attendees identified by participant_id, as they are sent advertising material on topics which may interest them. Thus details such as name, phone and address are required. To help target the advertising material, CC needs to track details of who attended each conference and the number of days attended. They also keep track of all speakers who have spoken, or are potential speakers for their conferences. Information included is speaker_id, name, phone, topic_id and topic_name. For each conference where they speak CC gives them a rating. CC also have a list of casual catering staff who can be booked to provide catering services. CC needs to store their id_no, name, phone, position (eg. chef) and the hours worked at each conference. And lastly, CC has a list of the venues, identified by venue_id, which includes maximum seating capacity, seating style, fax, phone. Your tables should should provide the data for the following reports: - Details of attendees at each conference. - Details of who speaks at each conference including date, time, duration and audience rating. - Details of caterers employed at each conference and hours worked.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David M Kroenke, David J Auer

6th Edition

0132742926, 978-0132742924

More Books

Students also viewed these Databases questions