please follow the question: Q3. Read the following description of a database for a painting company, and

please follow the question:

 

Transcribed Image Text:

Q3. Read the following description of a database for a painting company, and then answer Subquestions I through 3. Company U is a painting company that offers interior and exterior painting services depending on the customer's contract. Company U provides services according to the customer's needs. Some customers need to paint the whole building, and some only need to paint a bathroom, kitchen or bedroom. Some customers need water resistant color, and some need 3-year guarantee color. Company U provides high-quality painting colors from its suppliers. A particular type of painting color is obtained from a designated supplier. Company U's staff work on a per-hour basis. A customer can contract one or more jobs, and one or more staff members are assigned to each job. The database uses five tables. The table structure and sample data of each table is shown below. Here, underline () indicates the primary key, and dotted underline (...) indicates the foreign key. (1) Customer table The Customer table contains information about the customers. Customer Address CustomerID | Stamp 1 2 3 (2) Staff table The Staff table contains information associated with the staffs. Rate indicates the payment by the hour. SupplierID 1 2 3 JobID 1 2 3 4 5 (3) Supplier table The Supplier table contains information about the suppliers. JobStaffD 1 2 3 4 CustomerName Maung Maung Aung Aung Hla Hla 5 StaffName Kyaw Kyaw Zaw Zaw Min Min (4) Job table The Job table contains information about the contracted jobs. The total surface area is in units of square meters. 6 7 SupplierName Daw Saw U Win Daw Thein 6 10 20 30 15 (5) JobStaff table The JobStaff table is a joint table between the Job table and Staff table. A job can have many staff members and a staff member can do many jobs. Working Hours JobID 1 Rank In charge I Mandalay Bagan Painter Painter 1 TotalSurfaceArea Customer 112 Suppliet 100 2 3 2 3 3 4 5 PaintQuality Water Resistant Oil Resistant 3-Year Guarantee Stamin Startup 1 2 3 Rate 80 50 50 1 2 2 1 1 3 UnitPrice 100 200 300 2 4 4 5 8 5 8 2 3 1 Subquestion 1 From the answer groups below, select the correct answer to be inserted in each blank in the following SQL statement. The SQL statement named SQL1 outputs the staff names and their total number of jobs for the staff members who have more than two jobs. - SQLI -- SELECT S.StaffID, 5.StaffNam, FROM Job 3, Staff S, JobStaff 35 WHERE 3.JobID= 35.JobID AND S.StaffID 35.StaffID A AS Totaljob Q3. Read the following description of a database for a painting company, and then answer Subquestions I through 3. Company U is a painting company that offers interior and exterior painting services depending on the customer's contract. Company U provides services according to the customer's needs. Some customers need to paint the whole building, and some only need to paint a bathroom, kitchen or bedroom. Some customers need water resistant color, and some need 3-year guarantee color. Company U provides high-quality painting colors from its suppliers. A particular type of painting color is obtained from a designated supplier. Company U's staff work on a per-hour basis. A customer can contract one or more jobs, and one or more staff members are assigned to each job. The database uses five tables. The table structure and sample data of each table is shown below. Here, underline () indicates the primary key, and dotted underline (...) indicates the foreign key. (1) Customer table The Customer table contains information about the customers. Customer Address CustomerID | Stamp 1 2 3 (2) Staff table The Staff table contains information associated with the staffs. Rate indicates the payment by the hour. SupplierID 1 2 3 JobID 1 2 3 4 5 (3) Supplier table The Supplier table contains information about the suppliers. JobStaffD 1 2 3 4 CustomerName Maung Maung Aung Aung Hla Hla 5 StaffName Kyaw Kyaw Zaw Zaw Min Min (4) Job table The Job table contains information about the contracted jobs. The total surface area is in units of square meters. 6 7 SupplierName Daw Saw U Win Daw Thein 6 10 20 30 15 (5) JobStaff table The JobStaff table is a joint table between the Job table and Staff table. A job can have many staff members and a staff member can do many jobs. Working Hours JobID 1 Rank In charge I Mandalay Bagan Painter Painter 1 TotalSurfaceArea Customer 112 Suppliet 100 2 3 2 3 3 4 5 PaintQuality Water Resistant Oil Resistant 3-Year Guarantee Stamin Startup 1 2 3 Rate 80 50 50 1 2 2 1 1 3 UnitPrice 100 200 300 2 4 4 5 8 5 8 2 3 1 Subquestion 1 From the answer groups below, select the correct answer to be inserted in each blank in the following SQL statement. The SQL statement named SQL1 outputs the staff names and their total number of jobs for the staff members who have more than two jobs. - SQLI -- SELECT S.StaffID, 5.StaffNam, FROM Job 3, Staff S, JobStaff 35 WHERE 3.JobID= 35.JobID AND S.StaffID 35.StaffID A AS Totaljob