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 Entity-Relatinship 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:
1. For each client, the system must store the clients unique ID, name, address, phone, email, and all events
the client hosts.
2. Each event must have a unique ID, date, time, venue, number of guests, and event type recorded.
3. Each vendor's information must be stored, including the unique ID, name, address, phone, email, and
services provided.
4. The database should include service details such as the service name and price per person.
5. Staff members responsible for managing events should have their unique ID, name, and salary stored in the
database.
Business rules:
1. Clients can host multiple events.
2. Each event is hosted by one client and managed by one staff member.
3. Vendors provide multiple services, each provided by one vendor.
4. Different vendors can provide various services for the same event.
5. Services can be provided to multiple events.
 Construct an Entity-Relatinship diagram for the following system: System Description: An

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!