3. Implement the designed database using MS SQL Server. Implement all tables and relationships using SQL. Save all SQL statements for the creation of all tables and relationships. 4. Enter the data that is in the spreadsheet illustrated in Figure 1 to prove that your database is appropriately designed. • Add ALL of the records that are shown in the spreadsheet above accurately. • You may make assumptions regarding the data types of the attributes that have not been displayed in the spreadsheet. 5. To prove that the database you have implemented will meet the needs of Golden Gardens, you are required to write an SQL statement that will produce the report shown in Figure 1 with all columns as they are illustrated. • Implement and save this SQL statement with the use of a single query. • Do not make use of the WHERE clause within your SQL Statement.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
100%
3. Implement the designed database using MS SQL Server.
• Implement all tables and relationships using SQL.
Save all SQL statements for the creation of all tables and relationships.
4. Enter the data that is in the spreadsheet illustrated in Figure 1 to prove that your
database is appropriately designed.
• Add ALL of the records that are shown in the spreadsheet above accurately.
You may make assumptions regarding the data types of the attributes that
have not been displayed in the spreadsheet.
5. To prove that the database you have implemented will meet the needs of Golden
Gardens, you are required to write an SQL statement that will produce the report
shown in Figure 1 with all columns as they are illustrated.
Implement and save this SQL statement with the use of a single query.
• Do not make use of the WHERE clause within your SQL Statement.
6. Write an SQL query to calculate how much each client must pay every week.
Transcribed Image Text:3. Implement the designed database using MS SQL Server. • Implement all tables and relationships using SQL. Save all SQL statements for the creation of all tables and relationships. 4. Enter the data that is in the spreadsheet illustrated in Figure 1 to prove that your database is appropriately designed. • Add ALL of the records that are shown in the spreadsheet above accurately. You may make assumptions regarding the data types of the attributes that have not been displayed in the spreadsheet. 5. To prove that the database you have implemented will meet the needs of Golden Gardens, you are required to write an SQL statement that will produce the report shown in Figure 1 with all columns as they are illustrated. Implement and save this SQL statement with the use of a single query. • Do not make use of the WHERE clause within your SQL Statement. 6. Write an SQL query to calculate how much each client must pay every week.
JoziCleaners is local cleaning service that is looking to upgrade their current operations by
making use of a database to keep track of the teams, houses, clients and billings of each client
per/week.
Each house is cleaned by one or more teams. A team goes out to a particular house on a certain
day of the week. Each cleaning team has a team leader. Every cleaner eams R150 per day,
except the team leader who earns a unique amount.
The report that the JoziCleaners' manager produced in Microsoft Excel is illustrated as a
spreadsheet in Figure 1 below.
Day
Client
Client Name
Team Members
Team Leader
Leader
Total
Code
ID
Wage
Monday
Aeliana Gebahard
T3
6.
Jaymes Merrickson
R 350
R 850
C10
Alfher Dareia
T1
Geoffrey Glover
R 250
R 750
C8
Felina Diodotus
T2
Elmer Victorson
R 300
R 700
Brutus Sigihild
Sigibert Quirinus
Brutus Sigihild
C9
T4
Norris Mamadou
R 400
R1 000
Tuesday
CS
T3
Jaymes Merrickson
R 350
R 850
C9
T2
5
Elmer Victorson
R 300
R 700
Alfher Dareia
Duncan Gardyner
Geoffrey Glover
C10
T5
5
R450
R 850
C7
Servius Ambrosia
T1
6.
R 250
R750
C10
Alfher Dareia
T2
Elmer Victorson
R 300
R 700
Wednesd
ay
C10
Alfher Dareia
T3
6.
Jaymes Merrickson
R 350
R850
C1
Nikolaos Gallus
T4
7
Norris Mamadou
R 400
R1 000
C3
Amalia Prochoros
T2
5
Elmer Victorson
R 300
R 700
C8
Felina Diodotus
T3
Jaymes Merrickson R 350
R 850
Thursday C2
Hariwini Agrippa
T4
7
Norris Mamadou
R 400
R1 000
C9
Brutus Sigihild
T2
Elmer Victorson
R 300
R 700
CS
Sigibert Quirinus
T2
5
Elmer Victorson
R 300
R 700
C6
Artemisia Hippolytos T3
6.
Jaymes Merrickson
R 350
R850
Friday
C8
Felina Diodotus
T2
5
Elmer Victorson
R 300
R 700
Geoffrey Glover
Geoffrey Glover
C4
Aeliana Gebahard
T1
6.
R 250
R 750
C9
Brutus Sigihild
T1
R 250
R 750
Servius Ambrosia
T4
7
Norris Mamadou
R 400
R1 000
C2
Hariwini Agrippa
T3
6
Jaymes Merrickson
R 350
R850
Figure 1: JoziCleaners' report
Transcribed Image Text:JoziCleaners is local cleaning service that is looking to upgrade their current operations by making use of a database to keep track of the teams, houses, clients and billings of each client per/week. Each house is cleaned by one or more teams. A team goes out to a particular house on a certain day of the week. Each cleaning team has a team leader. Every cleaner eams R150 per day, except the team leader who earns a unique amount. The report that the JoziCleaners' manager produced in Microsoft Excel is illustrated as a spreadsheet in Figure 1 below. Day Client Client Name Team Members Team Leader Leader Total Code ID Wage Monday Aeliana Gebahard T3 6. Jaymes Merrickson R 350 R 850 C10 Alfher Dareia T1 Geoffrey Glover R 250 R 750 C8 Felina Diodotus T2 Elmer Victorson R 300 R 700 Brutus Sigihild Sigibert Quirinus Brutus Sigihild C9 T4 Norris Mamadou R 400 R1 000 Tuesday CS T3 Jaymes Merrickson R 350 R 850 C9 T2 5 Elmer Victorson R 300 R 700 Alfher Dareia Duncan Gardyner Geoffrey Glover C10 T5 5 R450 R 850 C7 Servius Ambrosia T1 6. R 250 R750 C10 Alfher Dareia T2 Elmer Victorson R 300 R 700 Wednesd ay C10 Alfher Dareia T3 6. Jaymes Merrickson R 350 R850 C1 Nikolaos Gallus T4 7 Norris Mamadou R 400 R1 000 C3 Amalia Prochoros T2 5 Elmer Victorson R 300 R 700 C8 Felina Diodotus T3 Jaymes Merrickson R 350 R 850 Thursday C2 Hariwini Agrippa T4 7 Norris Mamadou R 400 R1 000 C9 Brutus Sigihild T2 Elmer Victorson R 300 R 700 CS Sigibert Quirinus T2 5 Elmer Victorson R 300 R 700 C6 Artemisia Hippolytos T3 6. Jaymes Merrickson R 350 R850 Friday C8 Felina Diodotus T2 5 Elmer Victorson R 300 R 700 Geoffrey Glover Geoffrey Glover C4 Aeliana Gebahard T1 6. R 250 R 750 C9 Brutus Sigihild T1 R 250 R 750 Servius Ambrosia T4 7 Norris Mamadou R 400 R1 000 C2 Hariwini Agrippa T3 6 Jaymes Merrickson R 350 R850 Figure 1: JoziCleaners' report
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY