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 10-year U.S. Treasury bond with a face value of $1,000 pays a coupon of 5.5% (2.75% of face value every six months). The reported yield to maturity is 5.2% (a six-month discount rate of 5.2/2 =...
-
Jane Metal Works borrows Thai baht (THB) when the baht is trading at THB 35 (THB/GBP). If the nominal annual interest rate of the loan is 7% and at the end of the year the baht trades at THB 42...
-
The following are the duration times (minutes) of all missions flown by the space shuttle Challenger. 1 7224 8709 8784 10,060 10,089 10,125 11,445 11,476 11,844 Use the given data to construct a...
-
Suppose the production function for high-quality brandy is given by q = K L Where q is the output of brandy per week and L is labor hours per week. In the short run, K is fixed at 100, so the...
-
Why are factory overhead costs greater for defense contractors than they are for computer manufacturers?
-
Mark Make-a-Buck sells jars of beach sand in Florida. His price per jar is $2.50. His historical costs have been: $.40 per item $.10 per item $.30 per item $.20 per item $500 per month $1,000 per...
-
In the current year, Lucile, who is single and has AGI of $90,000 before considering rental (2pts) activities, is active in three separate real estate rental activities and is in the 22% tax bracket....
-
Cost of borrowing is 5% bank lending rate = 5% Salary in 2016 was $600,000 and increased by $100,000 each year. Equipment cost, fixtures and leasehold costs = $750,000 Upgrade costs = $50,000 Create...
-
Karl is a California resident who is Single, has no dependents, and who is claimed as a dependent on another return. Karl must have a California Gross Income amount greater than what amount to have a...
-
Albert made investments of $1000 each for two years. The first one at an interest of 4.8% compounded monthly and the second at 4.9% compounded annually. Calculate the total value of his investment in...
-
A 0.50-kg mass is attached to the end of a 1.0- Im string. The system is whirled in a horizontal circular path. If the maximum tension that the string can withstand is 200 N. What is the maximum...
-
Suppose we want to find a student that qualifies for an internship. For each student, we input the name, the age of student and the final mark obtained for the examination in a while loop. To...
-
On January 2, 2019, Best Corporation issued 3,000 shares of its $15 par-value common stock for cash at $36 a share. Prepare a journal entry to record the issuance of the stock. Journal entry...
-
a) Calculate the goodwill that was paid by Major Ltd on the acquisition of Minor Ltd. [10 marks] b) Prepare the consolidated statement of financial position for Major Ltd at 31 July 20X8. [30 marks]...
-
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.
-
An engine working on the constant volume (Otto) cycle has a compression ratio of 6.5 to 1 , and the compression follows the law \(p V^{1.3}=\mathrm{C}\), the initial pressure and temperature being 1...
-
How can the equation of state in the form of a relationship between pressure, volume and temperature be used to extend limited data on the entropy of a substance. A certain gas, A, has the equation...
-
A gas has the equation of state \[\frac{p v}{\Re T}=\mathrm{a}-\mathrm{b} T\] where \(\mathrm{a}\) and \(\mathrm{b}\) are constants. If the gas is compressed reversibly and isothermally at the...
Study smarter with the SolutionInn App