Question: Convert the conceptual design to a collection of SQL CREATE statements. Make sure all primary and foreign keys are represented. please do use MySQL Workbench
Convert the conceptual design to a collection of SQL CREATE statements. Make sure all primary and foreign keys are represented.
please do use MySQL Workbench

Schema 3: Cleaning company The BusyBee Cleaning Company specializes in providing cleaning services for both domestic and commercial clients. Each type of client has a set of requirements. For example, The Cardboard Box Company requires cleaning services from Monday to Friday 7am until 9am and 5pm until 7pm each day, but P. Nuttall only requires cleaning services on a Wednesday from 10am until 1pm. These requirements are specific to a company and the simplest representation for them is free-form text. Whenever a new client is taken on, a BusyBee administrator (a member of the administrative staff) assesses how many cleaning hours are required for the premises prior to assigning any staff to the job. Note that this is the ideal number, it may differ in practice. In addition, the administrator also assesses whether any specialist equipment is required and when. For example, three industrial floor cleaners may needed on two out of five occasions for one commercial client. There are two types of workers at the Busy Bee company: cleaning staff and administrative staff. The cleaning staff work in groups of six, with one of the six cleaners given additional supervisory responsibilities when on a job. The cleaning groups are assigned to complete specific cleaning jobs for clients. The cleaning supervisor oversees the quality of the cleaning work done for a client. The administrative staff manage the day-to-day office work including simple office work, answering phones, maintaining the cleaning schedule and ensuring the specialist equipment is properly maintained. Schema 3: Cleaning company The BusyBee Cleaning Company specializes in providing cleaning services for both domestic and commercial clients. Each type of client has a set of requirements. For example, The Cardboard Box Company requires cleaning services from Monday to Friday 7am until 9am and 5pm until 7pm each day, but P. Nuttall only requires cleaning services on a Wednesday from 10am until 1pm. These requirements are specific to a company and the simplest representation for them is free-form text. Whenever a new client is taken on, a BusyBee administrator (a member of the administrative staff) assesses how many cleaning hours are required for the premises prior to assigning any staff to the job. Note that this is the ideal number, it may differ in practice. In addition, the administrator also assesses whether any specialist equipment is required and when. For example, three industrial floor cleaners may needed on two out of five occasions for one commercial client. There are two types of workers at the Busy Bee company: cleaning staff and administrative staff. The cleaning staff work in groups of six, with one of the six cleaners given additional supervisory responsibilities when on a job. The cleaning groups are assigned to complete specific cleaning jobs for clients. The cleaning supervisor oversees the quality of the cleaning work done for a client. The administrative staff manage the day-to-day office work including simple office work, answering phones, maintaining the cleaning schedule and ensuring the specialist equipment is properly maintained
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
