Question: Insert the following data in the tables using insert into statements: 1. customer: 10010, Ramas, Alfred, A, 615, 8442573 10011, Dunne, Leona, K, 713, 8941238

Insert the following data in the tables using insert into statements:

1. customer:

10010, Ramas, Alfred, A, 615, 8442573

10011, Dunne, Leona, K, 713, 8941238

10012, Smith, Kathy, W, 615, 8942285

10013, Olowski, Paul,F, 615, 2221672

10014, Orlando, Myron, NULL, 615, 2971228

2. invoice:

1001, 10011, 2008-08-03

1002, 10014, 2008-08-04

1003, 10012, 2008-03-20

1004, 10014, 2008-09-23

3. line:

1001, 12321, 1

1001, 65781, 3

1002, 34256, 6

1003, 12321, 5

1002, 12321, 6

4. product:

12321, hammer, 189 ,20, 232

65781, chain, 12, 45, 235

34256, tape, 35, 60, 235

12333, hanger, 200 ,10, 232

5. vendor:

232, Bryson, Smith, 615, 2233234

235, SuperLoo, Anderson, 615, 2158995

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To insert the given data into tables using SQL INSERT INTO statements we need to assume the structur... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Screen shot all table and answer about this database problem Submit SQL commands used to answer Part 1, Part 2, and Part 3. Make sure that your SQL script runs without any errors. Submit screen shots...

Homework #3 Due: see Syllabus Total: 20 Points What to submit: Submit SQL commands used to answer Part 1, Part 2, and Part 3. Make sure that your SQL script runs without any errors. Submit screen...

Submit SQL Script that includes SQL statements to answer Part 1, Part 2, and Part 4. Make sure that your SQL script runs without any errors. Create the following tables. The underlined bold column...

For each relation table: A. A determine the functional dependencies by examining the below data. B. Determine all keys. C. Determine all Superkeys. same pro write the the sales Table name: LINE...

ANSWER Q4, HAVE INCLUDED ALL PARTS FOR REFERENCE BUT JUST ANSWER QUESTION 4: SQL QUERIES Question 1 (5 Points): Creating the database: Create a database using your name. Then create the following...

Insert data into the database ( 2 Points ) Insert the following data in the tables using insert into statements: customer: 1 0 0 1 0 , Ramas, Alfred, A , 6 1 5 , 8 4 4 2 5 7 3 1 0 0 1 1 , Dunne,...

DataBase , please help , i have no time it's with SQL Q7: Write down the INSERT query to add the following records in Customer table. Table name: CUSTOMER CUSCODE CUS LNAME CUS FNAME CUS INITIAL CUS...

Create the ERD. Use the database shown in Figure P3.24 to answer this Problem. ROBCOR is an aircraft charter company that supplies on-demand charter flight services using a fleet of four aircraft....

Create the relational diagram. Use the database shown in Figure P3.24 to answer this Problem. ROBCOR is an aircraft charter company that supplies on-demand charter flight services using a fleet of...

Insert the following data in the tables usinginsert into statements: customer: 10010, Johnson, Albert, A, 612, 8442573 10011, Edwards, Leona, K, 763, 8941238 10012, Smith, Walter, W, 612, 8942285...

The following are true concerning proficiency testing (PT) except An approved PT program must be implemented on all analytes on the regulated analyte list Analytes not on the regulated analyte list...

Sparky Inc. reported income from continuing operations for the year ended December 31, 2014 of $790,000. Sparky has a 30% tax rate. Upon review of additional information that just became available,...

The ability to understand the terms of an agreement is Multiple Choice 0 0 : 3 3 : 3 0 Consideration Maturity Legality Capacity

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...