Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please follow the question: Q3. Read the following description of a database for a painting company, and then answer Subquestions I through 3. Company U

please follow the question:

image  

image

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

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

Auditing A Business Risk Approach

Authors: Karla Johnstone, Audrey Gramling, Larry Rittenberg

8th edition

538476230, 978-0538476232

More Books

Students also viewed these Computer Network questions