Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i would like an er diagram for this project Clean Services is a company that provides aircraft cleaning services. The company wants us to create

i would like an er diagram for this project
image text in transcribed
Clean Services is a company that provides aircraft cleaning services. The company wants us to create a database system to track the services provided to different airports. The airport has a name, a unique code and location, and multiple contact information. The company manages personnel who clean the planes daily. The company clean three types of categories: A. B, and C. according to their respectivo size from larger to smaller. The cleaning personnel is. organized into groups that clean the planes. With a supervisor for each group. The company wants to track the personnel and the cleaning services per group. Each plane's size is expected to be cleaned in a min and max time, The company wants to store information about the servicesi, service number. plane code, airport code. date, time, and group code. Each worker can have one of two statuset, either available or unavailable. The groups that are cleaning a plane are considered in-service." They are hired to work eight hours per day . The company can move the workers from one group to another. Each group is composed of 7 workers, including the supervisor Each group is assigned to an airport, and the company assigns the groups to clean the planes. The system should allow the company to update the information. The compamy wants: a. To know the number of avaitable workers at a specific time or period b. To know the number of workers in teervice per group c. To list the planes that were cleaned por group and date. d. To know what the rumber of cleanirig oroups is. 9. To know what the supervisor of a specific group is 1. To know what cleaning group cleaned a specific plane. 9) To ldentify the groups that took more time than the ones expected to clean a plane. F. To know the location of a group of in-services, this is the aiport, plane, and gate. I To know the group cleaning a specific plane in a specific aimpot. 1 To list the services provided per aliport

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_2

Step: 3

blur-text-image_step3

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

More Books

Students also viewed these Databases questions

Question

Is hedge accounting permitted for a delta-neutral hedging strategy?

Answered: 1 week ago