Use the database tables in Figure P8.16 as the basis for Problems 16-30. FIGURE P8.16 CH08_SIMPLECO...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the database tables in Figure P8.16 as the basis for Problems 16-30. FIGURE P8.16 CH08_SIMPLECO DATABASE TABLES Table name: CUSTOMER CUST_NUM CUST_LNAME CUST_FNAME CUST_BALANCE 1000 Smith 1001 Ortega Jeanne Juan 1050.11 840.92 Database name: Ch08_SimpleCo Table name: INVOICE INV_NUM CUST_NUM INV_DATE INV_AMOUNT 1000 23-Mar-16 1001 23-Mar-16 1001 1000 12-Apr-16 30-Mar-16 1000 23-Apr-16 8000 8001 8002 8003 8004 16. Create the CUSTOMER table structure illustrated in Figure P8.16. The customer number should store integer values. The name attributes should support variable length character data up to 30 characters each. The customer balance should sup- port up to six digits on the left of the decimal place and two digits to the right of the decimal place. 17. Create the INVOICE table structure illustrated in Figure P8.16. The invoice number should store integer values. The invoice date should store date values. The invoice amount should support up to 8 digits to the left of the decimal place and two digits to the right of the decimal place. 18. Write the set of SQL commands necessary to insert the data into the CUSTOMER table you created in Problem 16, as illustrated in Figure P8.16. 19. Write the set of SQL commands necessary to insert the data into the INVOICE table you created in Problem 17, as illustrated in Figure P8.16. 235.89 312.82 528.10 194.78 619.44 Use the database tables in Figure P8.16 as the basis for Problems 16-30. FIGURE P8.16 CH08_SIMPLECO DATABASE TABLES Table name: CUSTOMER CUST_NUM CUST_LNAME CUST_FNAME CUST_BALANCE 1000 Smith 1001 Ortega Jeanne Juan 1050.11 840.92 Database name: Ch08_SimpleCo Table name: INVOICE INV_NUM CUST_NUM INV_DATE INV_AMOUNT 1000 23-Mar-16 1001 23-Mar-16 1001 1000 12-Apr-16 30-Mar-16 1000 23-Apr-16 8000 8001 8002 8003 8004 16. Create the CUSTOMER table structure illustrated in Figure P8.16. The customer number should store integer values. The name attributes should support variable length character data up to 30 characters each. The customer balance should sup- port up to six digits on the left of the decimal place and two digits to the right of the decimal place. 17. Create the INVOICE table structure illustrated in Figure P8.16. The invoice number should store integer values. The invoice date should store date values. The invoice amount should support up to 8 digits to the left of the decimal place and two digits to the right of the decimal place. 18. Write the set of SQL commands necessary to insert the data into the CUSTOMER table you created in Problem 16, as illustrated in Figure P8.16. 19. Write the set of SQL commands necessary to insert the data into the INVOICE table you created in Problem 17, as illustrated in Figure P8.16. 235.89 312.82 528.10 194.78 619.44
Expert Answer:
Answer rating: 100% (QA)
CREATE TABLE statement is used to create a new table in a database Syntax CREATE TABLE tablename col... View the full answer
Related Book For
College Mathematics for Business Economics Life Sciences and Social Sciences
ISBN: 978-0321614001
12th edition
Authors: Raymond A. Barnett, Michael R. Ziegler, Karl E. Byleen
Posted Date:
Students also viewed these databases questions
-
Consider the following simultaneous-move game: "Divide-the-Dollars". There are two players, Alice and Bob, who must decide how they want to divide $4. Alice can write down how much she wants for...
-
Juan Ortega believes that both the beginning and ending balances in retained earnings are shown in the stockholders equity section. Is Juan correct? Discuss.
-
Create and edit tables for What SUP (use the Ch9-02 file) a. Create a new table for What SUP that includes fields BuyerID, BuyerName, and BuyerPhone. The first field (BuyerID) is a Number data type;...
-
machine element is made of an alloy with Yield strength of 200 Mpa and fracture strain is 0.08. A machine element is characterized by the normal stress components as shown in the figure. The Answer...
-
A house is losing heat at a rate of 1800 kJ/h per C temperature difference between the indoor and the outdoor temperatures. Express the rate of heat loss from this house per (a) K, (b) F, and (c) R...
-
rowdy hill (40% shareholder) received the following amounts from company-salary 25,000, company paid health ins 2100-distribution of 4000- and travel reimbursement (accountable plan) of 2100 . what...
-
A major way in which business process engineering has undermined controls in organizations is that it has: a. Reduced the effectiveness of data communications controls b. Reduced separation of duties...
-
Donovan Steel has two profit centers: Ingots and Stainless Steel. These profit centers rely on services supplied by two service departments: electricity and water. The profit centers consumption of...
-
Selected accounts with a credit amount omitted are presented as follows: Work in Process Apr. 1 Balance 7,000 Apr. 30 Goods finished X 880 30 30 30 Direct materials 78,400 Direct labor 195,000 30...
-
Reconsider Prob. 253. Assuming a linear pressure increase during the compression, estimate the energy needed to compress the water isothermally. Data from Problem 53. A frictionless piston-cylinder...
-
In a square room with area of 25 m2 , a bulb of light at distance of 2 m from the wall yields a power density of 200 Wm-2 at point A as illustrated in figure below. If the bulb is an isotropic...
-
Why is it usually necessary to combine flowcharts with narrative descriptions of internal controls?
-
Samples to test internal controls are intended to provide a basis for an auditor to conclude whether a. The controls are operating effectively. b. The financial statements are materially misstated....
-
What role do supervisory bodies have in the regulation of auditors?
-
Name several advantages and disadvantages of internal control questionnaires.
-
An advantage of statistical sampling over nonstatistical sampling is that statistical sampling helps an auditor to a. Eliminate the risk of nonsampling errors. b. Reduce audit risk and materiality to...
-
This task is for the mortgage broking industry Outline relevant legislative and regulatory requirements Outline relevant awards and certified agreements Explain performance measurement systems...
-
Shreemaya Hotel in !adore was facing a problem of low demand for its rooms due to off season. The Managing Director (MD) of the hotel, Mrs. Sakina was very worried. She called upon the Marketing...
-
A family is thinking about buying a new house costing $120,000. The family must pay 20% down, and the rest is to be amortized over 30 years in equal monthly payments. If money costs 7.5% compounded...
-
The total accumulated costs C(i)and revenues R(t)(in thousands of dollars), respectively, for a coal mine satisfy C'(t) = 3 and R' (t) = 15e-01t where t is the number of years that the mine has been...
-
(A) Identify the basic and non basic variables.
-
Discuss the difference between historical and forecasted (or pro forma) financial statements. How are these different sets of financial statements used by managers and shareholders for...
-
Most balance sheets are defined as classified balance sheets in that both the assets and liabilities are dichotomized into the categories of current and noncurrent. [In those industries in which the...
-
Consider the following accounting principles: 1. Entity principle 2. Revenue recognition principle 3. Matching concept Define these accounting principles. Discuss how these principles relate to one...
Study smarter with the SolutionInn App