If you haven?t done so, create the WPC database, tables, and relationships described in this chapter, using
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 to populate the tables with the data shown in Figure 3-2.?
?
?
Transcribed Image Text:
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
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 77% (9 reviews)
DEPARTMENT DATA SELECT FROM DEPARTMENT ASSIGMENT DATA S...View the full answer
Answered By
Hassan Imtiaz
The following are details of my Professional Experience. Responsibilities Eight years of demanding teaching experience in the field of finance and business studies at Master’s Level. Completion of the given tasks within given time with quality and efficiency. Marketing professional with practical experience in and solid understanding of a diverse range of management applications, including market analysis, sales and marketing, team building and quality assurance. I have excellent skills to approach deal and sustain corporate clients / customers by demonstrating not only extraordinary communication and interpersonal skills but also high caliber presentation, negotiation and closing skills. Manage and follow up the day-to-day activities. Manage and co-ordinate the inventories. Fulfillment of all the tasks assigned.
The following are details of my Areas of Effectiveness. Finance 1. Corporate Finance 2. Advanced Corporate Finance 3. Management of Financial Institutions 4. International Financial Management 5. Investments 6. Fixed Income 7. Real Estate Investment 8. Entrepreneurial Finance 9. Derivatives 10. Alternative Investments 11. Portfolio Management 12. Financial Statement Analysis And Reporting (US GAAP & IFRS) 13. International Financial Markets 14. Public Finance 15. Personal finance 16. Real estate 17. Financial Planning Quantitative Analysis 1. Time Value Of Money 2. Statistics 3. Probability Distribution 4. Business Statistics 5. Statistical Theory and Methods Economics 1. Principles of Economics 2. Economic Theory 3. Microeconomic Principles 4. Macroeconomic Principles 5. International Monetary Economics 6. Money and Banking 7. Financial Economics 8. Population Economics 9. Behavioral Economics International Business 1. Ethics 2. Business Ethics 3. An introduction to business studies 4. Organization & Management 5. Legal Environment of Business 6. Information Systems in Organizations 7. Operations Management 8. Global Business Policies 9. Industrial Organization 10. Business Strategy 11. Information Management and Technology 12. Company Structure and Organizational Management Accounting & Auditing 1. Financial Accounting 2. Managerial Accounting 3. Accounting for strategy implementation 4. Financial accounting 5. Introduction to bookkeeping and accounting Marketing 1. Marketing Management 2. Professional Development Strategies 3. Business Communications 4. Business planning 5. Commerce & Technology Human resource management 1. General Management 2. Conflict management 3. Leadership 4. Organizational Leadership 5. Supply Chain Management 6. Law 7. Corporate Strategy Creative Writing 1. Analytical Reading & Writing Other Expertise 1. Risk Management 2. Entrepreneurship 3. Management science 4. Organizational behavior 5. Project management 6. Financial Analysis, Research & Companies Valuation 7. And any kind of Excel Queries
4.80+
150+ Reviews
230+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer science 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...
-
You are deciding between two mutually exclusive investment opportunities. Both require the same initial investment of $10 million. Investment A will generate $2 million per year (starting at the end...
-
Refer to Exercise 8.2.4. (a) Construct a 99% confidence interval for LLD. (b) Interpret the confidence interval from part (a) in the context of this setting.
-
Suppose you look back over the past 10 years and identify firms that have increased dividends every year. You notice that these stocks outperformed the broader market over the decade too. Does this...
-
Plants that grow on Swiss cliffs. A rare plant that grows on the limestone cliffs of the Northern Swiss Jura mountains was studied in Alpine Botany (Nov. 2012). The researchers collected data from a...
-
On January 8, 2012, Speedway Delivery Service purchased a truck at a cost of $65,000. Before placing the truck in service, Speedway spent $4,000 painting it, $2,500 replacing tires, and $8,000...
-
Which of the following are benefits of compiling a short-term financial plan? I. knowing ahead of time when your firm will probably require external financing II. being able to estimate how long of a...
-
Birdy Consulting Co. has the following accounts in its ledger: Cash, Accounts Receivable, Supplies, Office Equipment, Accounts Payable, Common Stock, Retained Earnings, Dividends, Fees Earned, Rent...
-
In 2015, transportation equipment owned by Corporation ABC was stolen. The adjusted basis in the equipment was $105,000, and ABC received a $400,000 insurance reimbursement. It immediately paid...
-
Odell pays $8500 for a bond that pays an annual dividend of $300. The bond has a par value of $10 000. If Odell holds the bond until it matures in exactly three years time, what will be his return on...
-
Record the following sales transactions of Custom Kitchens Inc. Nov. 12 Nov. 16 Nov. 24 Made a cash sale to a customer for 34 cabinet doors at a sales price of $72 per door. The cost to Custom...
-
Question 1- Visit the Boots and Hearts Festival website: www.bootsandhearts.com. Using the information you find on the site, make an analysis of the festival's Strengths, Weaknesses, Opportunities...
-
You will be creating a Performance Improvement Plan to address an employee in the attached case study (see below). This is a scenario you may encounter in your future HR profession, so this...
-
For this prompt, consider your academic goals, including (but not limited to) such topics as how you plan to manage your time to fit in your studies; how you will build your skills, as needed; how...
-
1. An introduction of you as a leader (whether or not you see yourself as a leader, whether or not you like being a leader, what kinds of leadership roles you have had, etc.). 2. Summarize your...
-
Briefly, describe the firm in terms of the following items. a. Size in terms of market capitalization, annual revenue, number of employees, location(s). b. Discuss the financial position of the firm....
-
Encapsulate the Name class. Make its fields private and add appropriate accessor methods to the class. Data from Problem 7 Create a class called Name that represents a persons name. The class should...
-
An investor sells a European call on a share for $4. The stock price is $47 and the strike price is $50. Under what circumstances does the investor make a profit? Under what circumstances will the...
-
Based on the following query: SELECT V_CODE, V_NAME, V_CONTACT, V_STATE FROM VENDOR WHERE V_STATE = TN ORDER BY V_NAME; Assume that 10,000 vendors are distributed as shown in Table P11.18. What...
-
Using Table 11.4 as an example, create two alternative access plans.
-
Assume that you have 10,000 different products stored in the PRODUCT table and that you are writing a Web-based interface to list all products with a quantity on hand (P_QOH) that is less than or...
-
ABC Corporation fabrica tres tipos de productos y actualmente utiliza el sistema tradicional de costeo de productos. La gerencia est considerando usar el costeo basado en actividades. A continuacin...
-
Which of the following is not an example of a period cost for a manufacturing plant? a. Assembly line workers' wages b. Office rent c. Depreciation of office machinery d. Office lighting
-
Question 1: Hex Ltd is considering several plant improvements and has allocated $880,000 for this investment. The following options / projects are under consideration. Assume that the net annual cash...
Study smarter with the SolutionInn App