2. Data definition with SQL In this exercise, you will create two tables for the data model shown below and insert some

[answerhappygod]

2 Data Definition With Sql In This Exercise You Will Create Two Tables For The Data Model Shown Below And Insert Some 1 (133.09 KiB) Viewed 31 times

Create the following tables in the SQL database that you created in the previous lab session.
1. Create the CUSTOMER table according to the following specifications:
Customer number: integer – Primary Key
Customer First Name and Last Name: variable-length character data up to 30 characters
Customer balance: number with six digits on the left of the decimal place and two digits to the right of the decimal place.
2. Data definition with SQL In this exercise, you will create two tables for the data model shown below and insert some data into tables. Create the following tables in the SQL database that you created in the previous lab session. CUSTOMER CUST_NUM INVOICE INV_NUM CUST_LNAME CUST_NUM CUST_FNAME INV_DATE CUST_BALANCE INV_AMOUNT 1. Create the CUSTOMER table according to the following specifications: ● Customer number: integer - Primary Key • Customer First Name and Last Name: variable-length character data up to 30 characters Customer balance: number with six digits on the left of the decimal place and two digits to the right of the decimal place.