Use the database tables in Figure P8.16 as the basis for Problems 16-30. FIGURE P8.16 CH08_SIMPLECO...

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

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