Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Construct an Entity - Relatinship diagram for the following system: System Description: An event planning company, specializes in organizing various event types, including weddings, corporate
Construct an EntityRelatinship diagram for the following system:
System Description:
An event planning company, specializes in organizing various event types, including weddings,
corporate conferences, and private parties. Each event entails specific details such as the date, venue, client
information, and associated vendors. Vendors offer services such as catering, decoration, photography, and
entertainment.
Data requirements:
For each client, the system must store the clients unique ID name, address, phone, email, and all events
the client hosts.
Each event must have a unique ID date, time, venue, number of guests, and event type recorded.
Each vendor's information must be stored, including the unique ID name, address, phone, email, and
services provided.
The database should include service details such as the service name and price per person.
Staff members responsible for managing events should have their unique ID name, and salary stored in the
database.
Business rules:
Clients can host multiple events.
Each event is hosted by one client and managed by one staff member.
Vendors provide multiple services, each provided by one vendor.
Different vendors can provide various services for the same event.
Services can be provided to multiple events.
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