Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a Entity Relationship Diagram. Company ZZZ organizes workshops where its trainers give tutorials on different programming languages, systems, platforms, etc. ZZZ wants to maintain

Create a Entity Relationship Diagram.

Company ZZZ organizes workshops where its trainers give tutorials on different programming languages, systems, platforms, etc. ZZZ wants to maintain a database about its employees, their jobs, and workshops organized by the company. In addition, for every workshop ZZZ creates food orders that will be submitted to caterers so that the workshop participants can have breakfast, coffee breaks, lunch break, etc.

Each ZZZ employee has an SSN, first name, last name, email address. The company has many job types (e.g., trainer, lecturer, senior lecturer, intern, etc.) and every job type has an ID, title, salary level, and the description of the duties. Every company employee has a specific job type assigned to her; many employees can have the same job type. Every job type has at least one employee that has this job type.

A workshop is identified by the workshop ID, description, location, start and end dates, number of participants. A workshop is organized by one or more ZZZ employees and an employee can be assigned to zero, one, or many workshops.

For every workshop, depending on the workshop length, ZZZ submits food orders, where every order is identified by the caterer name, food type (e.g., breakfast, coffee break, lunch, etc.), money amount paid. For some workshops (for example, short 2-hour tutorials), ZZZ does not submit any food orders, for other workshop (for example, 2-day workshops), ZZZ submits multiple food orders. As ZZZ employees are self-proclaimed foodies, ZZZ never submits multiple orders to the same caterer during one workshop. If a workshop is cancelled, ZZZ cancels the corresponding food orders and deletes the information about these orders from the database.

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

Step: 3

blur-text-image

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 Design Application Development And Administration

Authors: Mannino Michael

5th Edition

0983332401, 978-0983332404

More Books

Students also viewed these Databases questions

Question

Develop skills for building positive relationships.

Answered: 1 week ago

Question

Describe techniques for resolving conflicts.

Answered: 1 week ago

Question

Give feedback effectively and receive it appropriately.

Answered: 1 week ago