Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started