Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
