Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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. Problem 19: Write the set of SQL commands necessary to insert the data into the INVOICE table

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. Problem 19: Write the set of SQL commands necessary to insert the data into the INVOICE table

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

Problem 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.

Problem 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.

Use YYYY-MM-DD format when inserting dates.

### Problems 8.16-8.25 Ensure referential integrity for the `CUSTOMER` table. #### Figure P8.16: CH08_SIMPLECO Database Tables **Table Name: CUSTOMER** | CUST_NUM | CUST_LNAME | CUST_FNAME | CUST_BALANCE | |----------|------------|------------|--------------| | 1000 | Smith | Jeanne | 1050.11 | | 1001 | Ortega | Juan | 840.92 | **Table Name: INVOICE** | INV_NUM | CUST_NUM | INV_DATE | INV_AMOUNT | |---------|----------|----------|------------| | 1000 | 23-Mar-16 | 235.98 | | 1001 | 22-Mar-16 | 512.00 | | 1002 | 23-Mar-16 | 428.00 | | 1003 | 23-Mar-16 | 1001.50 | | 1004 | 23-Apr-16 | 619.44 | ### Task Complete **Problem 17** above. ### Problem 18 Write the SQL commands to insert data into the `CUSTOMER` table, as shown in Figure P8.16. #### SQL Commands ```sql insert into customer values(1000, 'Smith', 'Jeanne', 1050.11); insert into customer values(1001, 'Ortega', 'Juan', 840.92); ``` ### Task Ensure the command structure matches the database requirements. ### Error Notice `ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ",500.22); SELECT * FROM INVOICE' at line 3.` This error suggests there is a syntax issue with the input SQL commands, specifically near a numerical value and a `SELECT` statement.
Transcribed Image Text:### Problems 8.16-8.25 Ensure referential integrity for the `CUSTOMER` table. #### Figure P8.16: CH08_SIMPLECO Database Tables **Table Name: CUSTOMER** | CUST_NUM | CUST_LNAME | CUST_FNAME | CUST_BALANCE | |----------|------------|------------|--------------| | 1000 | Smith | Jeanne | 1050.11 | | 1001 | Ortega | Juan | 840.92 | **Table Name: INVOICE** | INV_NUM | CUST_NUM | INV_DATE | INV_AMOUNT | |---------|----------|----------|------------| | 1000 | 23-Mar-16 | 235.98 | | 1001 | 22-Mar-16 | 512.00 | | 1002 | 23-Mar-16 | 428.00 | | 1003 | 23-Mar-16 | 1001.50 | | 1004 | 23-Apr-16 | 619.44 | ### Task Complete **Problem 17** above. ### Problem 18 Write the SQL commands to insert data into the `CUSTOMER` table, as shown in Figure P8.16. #### SQL Commands ```sql insert into customer values(1000, 'Smith', 'Jeanne', 1050.11); insert into customer values(1001, 'Ortega', 'Juan', 840.92); ``` ### Task Ensure the command structure matches the database requirements. ### Error Notice `ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ",500.22); SELECT * FROM INVOICE' at line 3.` This error suggests there is a syntax issue with the input SQL commands, specifically near a numerical value and a `SELECT` statement.
### Educational Content on Database Tables and SQL Queries #### Problems 8.16-8.25 Overview **Tables and Figures:** - **Database Name: Ch08_SimpleCo** - **Tables Included:** - **CUSTOMER Table:** - **Fields:** CUST_NUM, CUST_LNAME, CUST_FNAME, CUST_BALANCE - **Data Sample:** - (1000, Smith, Jeanne, 1050.11) - (1001, Ortega, Juan, 840.92) - **INVOICE Table:** - **Fields:** INV_NUM, CUST_NUM, INV_DATE, INV_AMOUNT - **Data Sample:** - (8000, 1000, 23-Mar-16, 235.89) - (8001, 1000, 23-Mar-16, 312.82) - (8002, 1001, 30-Mar-16, 528.10) - (8003, 1000, 12-Apr-16, 194.78) - (8004, 1000, 23-Apr-16, 619.44) **Figure P8.16: CH08_SIMPLECO DATABASE TABLES** visualizes the data structure for easy reference. #### Problem 19 Instructions - **Task:** Write the SQL commands required to insert new data into the `INVOICE` table as per the design in Problem 17. - **Date Format:** Use the `YYYY-MM-DD` format when entering dates. #### Example SQL Query The SQL command provided for inserting data into the `INVOICE` table is as follows: ```sql INSERT INTO INVOICE(INV_NUM, CUST_NUM, INV_DATE, INV_AMOUNT) VALUES(8005, 1000, '2016-10-20', 500.22); ``` To view the data in the `INVOICE` table, you can use: ```sql SELECT * FROM INVOICE; ``` #### SQL Viewer - A tool or interface to run SQL queries and visualize results. **Note:** Ensure that you adjust the problem numbers and content as per the context needed for educational dissemination.
Transcribed Image Text:### Educational Content on Database Tables and SQL Queries #### Problems 8.16-8.25 Overview **Tables and Figures:** - **Database Name: Ch08_SimpleCo** - **Tables Included:** - **CUSTOMER Table:** - **Fields:** CUST_NUM, CUST_LNAME, CUST_FNAME, CUST_BALANCE - **Data Sample:** - (1000, Smith, Jeanne, 1050.11) - (1001, Ortega, Juan, 840.92) - **INVOICE Table:** - **Fields:** INV_NUM, CUST_NUM, INV_DATE, INV_AMOUNT - **Data Sample:** - (8000, 1000, 23-Mar-16, 235.89) - (8001, 1000, 23-Mar-16, 312.82) - (8002, 1001, 30-Mar-16, 528.10) - (8003, 1000, 12-Apr-16, 194.78) - (8004, 1000, 23-Apr-16, 619.44) **Figure P8.16: CH08_SIMPLECO DATABASE TABLES** visualizes the data structure for easy reference. #### Problem 19 Instructions - **Task:** Write the SQL commands required to insert new data into the `INVOICE` table as per the design in Problem 17. - **Date Format:** Use the `YYYY-MM-DD` format when entering dates. #### Example SQL Query The SQL command provided for inserting data into the `INVOICE` table is as follows: ```sql INSERT INTO INVOICE(INV_NUM, CUST_NUM, INV_DATE, INV_AMOUNT) VALUES(8005, 1000, '2016-10-20', 500.22); ``` To view the data in the `INVOICE` table, you can use: ```sql SELECT * FROM INVOICE; ``` #### SQL Viewer - A tool or interface to run SQL queries and visualize results. **Note:** Ensure that you adjust the problem numbers and content as per the context needed for educational dissemination.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
SQL Query
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS