Insert the following data in the tables using insert into statements: 1. custome
ID: 3880512 • Letter: I
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
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
Explanation / Answer
note:- If you have any query regarding this then please comment below. please upvote.
1)
INSERT INTO customer VALUES (10010, Ramas, Alfred, A, 615, 8442573);
INSERT INTO customer VALUES (10011, Dunne, Leona, K, 713, 8941238);
INSERT INTO customer VALUES (10012, Smith, Kathy, W, 615, 8942285);
INSERT INTO customer VALUES (10013, Olowski, Paul,F, 615, 2221672);
INSERT INTO customer VALUES (10014, Orlando, Myron, NULL, 615, 2971228);
2)
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);
3)
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);
4)
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, 235);
INSERT INTO product VALUES (12333, hanger, 200 ,10, 232);
5)
INSERT INTO vendor VALUES (232, Bryson, Smith, 615, 2233234);
INSERT INTO vendor VALUES (235, SuperLoo, Anderson, 615, 2158995);