Question: If you haven?t done so, create the WPC database, tables, and relationships described in this chapter, using the SQL DBMS of your choice. Be sure

If you haven?t done so, create the WPC database, tables, and relationships described in this chapter, using the SQL DBMS of your choice. Be sure to populate the tables with the data shown in Figure 3-2.?

? FIGURE 3-2 Sample Data for the WPC Database DepartmentName BudgetCode OfficeNumber Phone

? Administration -100-10 BLDG01-300 360-285-8100 Legal -200-10 BLDG01-200 360-285-8200 Accounting -300-10 BLDG01-100 360-285-8300

FIGURE 3-2 Sample Data for the WPC Database DepartmentName BudgetCode OfficeNumber Phone Administration -100-10 BLDG01-300 360-285-8100 Legal -200-10 BLDG01-200 360-285-8200 Accounting -300-10 BLDG01-100 360-285-8300 Finance BC-400-10 BLDG01-140 360-285-8400 Human Resources -500-10 BLDG01-180 360-285-8500 Production -600-10 BLDG02-100 360-287-8600 Marketing -700-10 BLDG02-200 360-287-8700 InfoSystems -800-10 BLDG02-270 360-287-8800 (a) DEPARTMENT Table FIGURE 3-2 Continued Employee Number FirstName LastName Department Phone Email 1 Mary Jacobs Administration 360-285-8110 Mary.Jacobs@WPC.com Rosalie 360-285-8120 Rosalie. Jackson@WPC.com Jackson Bandalone Legal Administration Richard 360-285-8210 Richard.Bandalone@WPC.com 4 Tom Caruthers Accounting 360-285-8310 Tom.Caruthers@WPC.com Heather 360-285-8320 Heather. Jones@WPC.com Jones Abernathy Finance Accounting 6. ary 360-285-8410 Mary.Abernathy@WPC.com George Smith Human Resources 360-285-8510 George.Smith@WPC.com Tom Jackson Jones 8. Production 360-287-8610 Tom. Jackson@WPC.com George Production 360-287-8620 George Jones@WPC.com 9. Ken Numoto Marketing InfoSystems 10 360-287-8710 Ken.Numoto@WPC.com 11 James Nestor James. Nestor@WPC.com Rick Brown InfoSystems 360-287-8820 Rick.Brown@WPC.com 12 (b) EMPLOYEE Table ProjectID ProjectName Department Marketing Hours StartDate EndDate 1000 2012 Q3 Product Plan 135.00 10-MAY-12 15-JUN-12 1100 2012 Q3 Portfolio Analysis Finance 120.00 05-JUL-12 25-JUL-12 1200 2012 Q3 Tax Preparation Accounting 145.00 10-AUG-12 15-OCT-12 1300 2012 Q4 Product Plan Marketing 150.00 10-AUG-12 15-SEP-12 1400 2012 Q4 Portfolio Analysis Finance 140.00 05-OCT-12 (c) PROJECT Table + in

Step by Step Solution

★★★★★

3.41 Rating (170 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

DEPARTMENT DATA SELECT FROM DEPARTMENT ASSIGMENT DATA S... View full answer

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 Database Concepts Questions!

In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL...

The owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises, you will use the data in the Colonial Adventure...

In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. (If you use a computer to complete these exercises, use a copy of the...

The following is a set of tables for the Art Course database shown in Figure 1-10. For the data for these tables, use the data shown in Figure 1-10. CUSTOMER (CustomerNumber, CustomerLastName,...

If you haven't done so, create the WPC database, tables, and relationships described in this chapter, using the SQL DBMS of your choice. Be sure to populate the tables with the data shown in Figure...

3.52 Write and run an SQL query to list all students and courses they are registered for. Include, in this order, CustomerNumber, CustomerLastName, CustomerFirstName, Phone, CourseNumber, and...

The following is a set of tables for the Art Course database shown in Figure 1-10. For the data for these tables, use the data shown in Figure 1-10. CUSTOMER (CustomerNumber, CustomerLastName,...

, The following exercises are intended for use with a DBMS other than Microsoft Access. If you are using Microsoft Access, see the equivalent questions in the "Working with Microsoft Access"...

the question is listed in proper order The following is a set of tables for the Art Course database shown in Figure 1- 12. For the data for these tables, use the data shown in Figure 1-12. CUSTOMER...

Case Analysis 15-15BSN Bicycles I (Creating a Database from Scratch with Microsoft Access) Bill Barnes and Tom Freeman opened their BSN bicycle shop in 2010. Not counting Jakea friend who helps out...

Using the data for Johnson & Johnson (NYSE:JNJ), presented below: Johnson & Johnson Selected Financial Data For the Years 2014 to 2018 Fiscal Year 2018 2017 2016 2015 2014 Sales $ 81,534 $ 76,481 $...

Your group works for Warner Music Group (www.wmg.com), a large music record label whose sales are declining largely due to digital piracy. Your supervisor assigns you the task of developing a...

Mike and Laura are married and want to develop a budget that will meet their financial goals. How much can the couple spend erting out each month? \ table [ [ Personal Monthly Budget using 5 0 - 3 0...

What is the limitation on a deductible IRA contribution for 2016?

Define the term database. AppendixLO1

Name the four components of a database system. AppendixLO1

What is the purpose of this book? AppendixLO1

The Gecko Company and the Gordon Company are two firms that have the same business risk but different dividend policies. Gecko pays no dividend, whereas Gordon has an expected dividend yield of 6...

3. Calculate the financial ratios for the company in 2019 and 2020. (2 marks) Note: Purchases were %70 of the cost of goods sold in both years. 2019 2020 Financial Ratios Current ratio Quick ratio...

Joe starts a savings account with $ 500,000 in a bank that pays him an interest rate of 2% per month. Every end of the month he deposits $ 200,000, for 12 months. If at the end of month 6 he makes an...