Answered step by step
Verified Expert Solution
Link Copied!
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 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.
image text in transcribed

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_2

Step: 3

blur-text-image_3

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 Machine Performance Modeling Methodologies And Evaluation Strategies Lncs 257

Authors: Francesca Cesarini ,Silvio Salza

1st Edition

3540179429, 978-3540179429

More Books

Students explore these related Databases questions