Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started