Question: Using the WP database, create an SQL script named WP-Insert-New-Data.sql to answer Exercise 7.102. 7.102 Using the sample data for the COMPUTER table shown in

Using the WP database, create an SQL script named

Using the WP database, create an SQL script named WP-Insert-New-Data.sql to answer Exercise 7.102. 7.102 Using the sample data for the COMPUTER table shown in Figure 7-47 and the COMPUTER ASSIGNMENT table shown in Figure 7-48, write INSERT statements to add this data to these tables in the WP database. Run these INSERT statements to populate the tables. HP SerialNumber Make Model Processor Type Processor Speed MainMemory DiskSize 9871234 HP ProDesk 600 GS Intel i5-4690 3.50 16.0 GBytes 1.0 TBytes 9871235 ProDesk 600 G3 Intel i5-4690 3.50 16.0 GBytes 1.0 TBytes 9871236 HP ProDesk 600 G3 Intel i5-4690 3.50 16.0 GBytes 1.0 TBytes 9871237 HP ProDesk 600 G3 Intel i5-4690 3.50 16.0 GBytes 1.0 TBytes 9871238 HP ProDesk 600 G3 Intel i5-4690 3.50 16.0 GBytes 1.0 TBytes 9871239 HP ProDesk 600 G3 Intel i5-4690 3.50 16.0 GBytes 1.0 TBytes 9871240 HP ProDesk 600 G3 Intel i5-4690 3.50 16.0 GBytes 1.0 TBytes 9871241 HP ProDesk 600 G3 Intel i5-4690 3.50 16.0 GBytes 1.0 TBytes 9871242 HP ProDesk 600 GS Intel i5-4690 3.50 16.0 GBytes 1.0 TBytes 9871243 HP ProDesk 600 GS Intel i5-4690 3.50 16.0 GBytes 1.0 TBytes 6541001 Dell OptiPlex 7040 Intel i7-6700 3.40 32.0 GBytes 2.0 TBytes 6541002 Dell OptiPlex 7040 Intel i7-6700 3.40 32.0 GBytes 2.0 TBytes 6541003 Dell OptiPlex 7040 Intel i7-6700 3.40 32.0 GBytes 2.0 TBytes 6541004 Dell OptiPlex 7040 Intel i7-6700 3.40 32.0 GBytes 2.0 TBytes 6541005 Dell OptiPlex 7040 Intel i7-6700 3.40 32.0 GBytes 2.0 TBytes 6541006 Dell OptiPlex 7040 Intel i7-6700 3.40 32.0 GBytes 2.0 TBytes 6541007 Dell OptiPlex 7040 Intel i7-6700 3.40 32.0 GBytes 2.0 TBytes 6541008 Dell OptiPlex 7040 Intel i7-6700 3.40 32.0 GBytes 2.0 TBytes 6541009 Dell OptiPlex 7040 Intel i7-6700 3.40 32.0 GBytes 2.0 TBytes 6541010 Dell OptiPlex 7040 Intel i7-6700 3.40 32.0 GBytes 2.0 TBytes FIGURE 7-47 WP Database COMPUTER Table Data FIGURE 7.48 WP Database COMPUTER ASSIGNMENT Table Data SerialNumber Employee Number DateAssigned DateReassigned 9871234 12 15-Sep-18 21-Oct-18 9871235 13 15-Sep-18 21-Oct-18 9871236 14 15-Sep-18 21-Oct-18 9871237 15 21-Oct-18 9871238 6 15-Sep-18 15-Sep-18 15-Sep-18 21-Oct-18 9871239 7 21-Oct-18 9871240 B 15-Sep-18 21-Oct-18 9871241 9 21-Oct-18 15-Sep-18 15-Sep-18 9871242 16 21-Oct-12 9871243 17 15-Sep-18 21-Oct-18 6541001 12 21-Oct-18 6841002 13 21-Oct-18 6541003 14 21-Oct-18 6541004 15 21-Oct-18 6541005 6 21-Oct-18 6541006 7 21-Oct-18 6541007 B 21-Oct-18 6541008 21-Oct-18 6541009 16 21-Oct-18 6541010 17 21-Oct-18 9871234 1 21-Oct-18 9871235 2 21-Oct-18 9871236 3 21-Oct-18 9871237 4 21-Oct-18 9871238 5 21-Oct-18 9871239 10 21-Oct-18 9871240 11 21-Oct-18 9871241 18 21-Oct-18 9871242 19 21-Oct-18 9871243 20 21-Oct-18

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

S10_Chap7_RQ_WPC-Database Lab This assignment is from the Kroenke book Chap 7 Review Questions (RQ). Create a new folder, WPC-Database, in the Projects folder, found in the SQL Server Management...

Create WPC DB Views Chapter 7 Kroenke This assignment requires that you to follow Review Questions (RQ), which have been repeated below. You will write some of the code to create a database, named...

The following question is already on Chegg, but hasn't been answered yet. Here's the link: 9780134601663 Database Concepts (8th Edition) Chapter 3, Problem 3AWE Please provide the steps for this...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

TASK 1: MAKE UPDATES AND CORRECTIONS Based on Part 1 Comments-20 Points: 1. Update the data model: Make any required changes to your design based on the comments provided for Part 1 of the project....

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

Practicing Product Development As you worked through the learning activities for this week, you learned about the process that can be used to develop an application for a client. Now it is your turn...

I need a 10 page paper for my MIS class. Please do not copy and paste as my school is getting stricter on plagiarism. I have attached the assignment and the sample \fData Analytic Thinking 1 Data...

Study Guide Healthcare Statistics By Jacqueline K. Wilson, RHIA About the Author Jacqueline K. Wilson is a Registered Health Information Administrator (RHIA) who has more than ten years of experience...

can i get a solution to this question please. Value: Document (include your file name) 15% of final grade How to complete: 1. Read the following Anniversary Party scheduling problem: As the project...

two courses in a month and have a total of 60 students enrolled in those two courses. Data concerning the company's cost formulas appear below: Instructor wages Classroom supplies Utilities Campus...

If the cost of refinancing their house is $ 3,860, how long would Doug and Lynn have to remain in their home in order to recover the cost? (Ignore any interest on the savings in answering this...

Problem 7-65 Contribution Margin, Break-Even Sales, Margin of Safety Suppose that Kicker had the following sales and cost experience (in thousands of dollars) for May of the current year and for May...

Nicholas earned $500,000 and used it to purchase land in joint tenancy with a right of survivorship with Nevaeh. Has Nicholas made a taxable gift to Nevaeh and, if so, in what amount