Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
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.

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)
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...
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
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
SEE MORE TEXTBOOKS