Question

Insert the following data in the tables using

insert into

statements:

1.

customer:

10010, Johnson, Alfred, A, 615, 8442573

10011, Dunne, Leona, K, 713, 8941238

10012, Smith, Walter, W, 615, 8942285

10013, Roberts, Paul, F, 615, 2221672

10014, Orlando, Myla, 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.

vendor:

232, Bryson, Smith, 615, 2233234

235, Walls, Anderson, 615, 2158995

236, Jason, Schmidt, 651, 2468850

4.

product:

12321, hammer, 189 ,20, 232

65781, chain, 12, 45, 235

34256, tape, 35, 60, 236

12333, hanger, 200 ,10, 232

5.

line:

1001, 12321, 1

1001, 65781, 3

1002, 34256, 6

1003, 12321, 5

1002, 12321, 6

Answer 1

If you have any doubts, please give me comment...

INSERT INTO customer VALUES(10010, 'Johnson', 'Alfred', 'A', 615, 8442573);

INSERT INTO customer VALUES(10011, 'Dunne', 'Leona', 'K', 713, 8941238);

INSERT INTO customer VALUES(10012, 'Smith', 'Walter', 'W', 615, 8942285);

INSERT INTO customer VALUES(10013, 'Roberts', 'Paul', 'F', 615, 2221672);

INSERT INTO customer VALUES(10014, 'Orlando', 'Myla', NULL, 615, 2971228);

INSERT INTO vendor VALUES(232, 'Bryson', 'Smith', 615, 2233234);

INSERT INTO vendor VALUES(235, 'Walls', 'Anderson', 615, 2158995);

INSERT INTO vendor VALUES(236, 'Jason', 'Schmidt', 651, 2468850);

INSERT INTO product VALUES(12321, 'hammer', 189 ,20, 232);

INSERT INTO product VALUES(65781, 'chain', 12, 45, 235);

INSERT INTO product VALUES(34256, 'tape', 35, 60, 236);

INSERT INTO product VALUES(12333, 'hanger', 200 ,10, 232);

INSERT INTO line VALUES(1001, 12321, 1);

INSERT INTO line VALUES(1001, 65781, 3);

INSERT INTO line VALUES(1002, 34256, 6);

INSERT INTO line VALUES(1003, 12321, 5);

INSERT INTO line VALUES(1002, 12321, 6);

INSERT INTO invoice VALUES(1001, 10011, '2008-08-03');

INSERT INTO invoice VALUES(1002, 10014, '2008-08-04');

INSERT INTO invoice VALUES(1003, 10012, '2008-03-20');

INSERT INTO invoice VALUES(1004, 10014, '2008-09-23');