FIGURE P8.31 CH08_SALECO2 DATABASE TABLES Database name: Ch08_SaleCo2 Table name: CUSTOMER Table name: INVOICE CUS CooE CuS LNAMECUS PNAME CuS NMAL CUSAREACOCE CU PHONE CuS BALANCE OIE Rumas CO1 Dure W NUNGER | CUS_CO DATE 100 19014 16--1 1001 16Jan-18 TOTAL TA otAL Ahet Lre Kay 544 04-126 000 1070 19012 16n-t 10011 17an-18 10018 153S 0013 Obenki KCO14 Odundo Myren COS O 56 76 00 0.00 221 19 16 4-210 222-1 403 2-12 1004 100s 280 7044 James Gege 1000 10014 17an-18 10017 wane 15 10015 1tlan18 200 00 Fart 210 000 Are Clate 1001 t 1008 431 de 615 207-00 Table name: LINE WNUMEES DENUMBERCOCE| LHE UNTS UE PRICE UHE TOTAL Table name: PRODUCT 1499 149 1001 1DERO Power pairte, 15 pa, Seorz 13-02 per bde 140 900 p e 00 1000 499 130eo-17 140 1000 1.223/OPD 13Nv-17 15a1a 12 1749 000 21344 1000 3 13022 749 14 90 19.00 70.44 207 108 92 1000 1490 19 om H 10n,0 z Y DO gnew. 12n 15-n-1 23 43 199 20e-17 24ec1 1004 1006 22OHE 1 PVCZDRT 1 SM 1077 2 22OTY 9.06 ar 12 22ORD BIO conder I0 20He O hanmer 21LAA Seanner, 12 54778-2 R tie, 1 e WEO Heu chan saw, 10. PVCDRT PVC pn, 3Sin, 6 20-n-18 12 1006 10 2125 1006 1006 1006 1000 1007 20--18 23 10 995 109 90 14 40 150ec-17 20 00 2144 1 13COP 29 98 499 2935 2. 1490 2 0S 2400 1 PVCCAT 2 WRSTT 490 68 119 6 1006 S18277 125n eow, 25 SN2E 25A wd. sorew.e ARSTS Seeiming, t, nesh 12 75 000 21225 000 21201 10 25 1006 1000 100 Table name: VENDOR VCOE VNAME VCONTACT VAREACODEV PHONE V STATE VORDER 2125 y, e 2126 upeles, he. 21201 DE Seply 21344 Gome B 22T Dome Saphy 23119 Randets u 24004 Brackenan Bros 20 ORDVA, n 44 DAK, he. 20 Darl Suple 2S Rico Syster D Srathen Pushing Singh Deega 22-3 TN 215-6 FL 616 616 TM Sath GA Ander Brning 101 615 206-1410 124 TN Brh 104 22000 FL Breythe TN PL 31. Create a trigger named trg_line_total to write the LINE_TOTAL value in the LINE table every time you add a new LINE row. (The LINE_TOTAL value is the product of the LINE_UNITS and LINE_PRICE values.)
FIGURE P8.31 CH08_SALECO2 DATABASE TABLES Database name: Ch08_SaleCo2 Table name: CUSTOMER Table name: INVOICE CUS CooE CuS LNAMECUS PNAME CuS NMAL CUSAREACOCE CU PHONE CuS BALANCE OIE Rumas CO1 Dure W NUNGER | CUS_CO DATE 100 19014 16--1 1001 16Jan-18 TOTAL TA otAL Ahet Lre Kay 544 04-126 000 1070 19012 16n-t 10011 17an-18 10018 153S 0013 Obenki KCO14 Odundo Myren COS O 56 76 00 0.00 221 19 16 4-210 222-1 403 2-12 1004 100s 280 7044 James Gege 1000 10014 17an-18 10017 wane 15 10015 1tlan18 200 00 Fart 210 000 Are Clate 1001 t 1008 431 de 615 207-00 Table name: LINE WNUMEES DENUMBERCOCE| LHE UNTS UE PRICE UHE TOTAL Table name: PRODUCT 1499 149 1001 1DERO Power pairte, 15 pa, Seorz 13-02 per bde 140 900 p e 00 1000 499 130eo-17 140 1000 1.223/OPD 13Nv-17 15a1a 12 1749 000 21344 1000 3 13022 749 14 90 19.00 70.44 207 108 92 1000 1490 19 om H 10n,0 z Y DO gnew. 12n 15-n-1 23 43 199 20e-17 24ec1 1004 1006 22OHE 1 PVCZDRT 1 SM 1077 2 22OTY 9.06 ar 12 22ORD BIO conder I0 20He O hanmer 21LAA Seanner, 12 54778-2 R tie, 1 e WEO Heu chan saw, 10. PVCDRT PVC pn, 3Sin, 6 20-n-18 12 1006 10 2125 1006 1006 1006 1000 1007 20--18 23 10 995 109 90 14 40 150ec-17 20 00 2144 1 13COP 29 98 499 2935 2. 1490 2 0S 2400 1 PVCCAT 2 WRSTT 490 68 119 6 1006 S18277 125n eow, 25 SN2E 25A wd. sorew.e ARSTS Seeiming, t, nesh 12 75 000 21225 000 21201 10 25 1006 1000 100 Table name: VENDOR VCOE VNAME VCONTACT VAREACODEV PHONE V STATE VORDER 2125 y, e 2126 upeles, he. 21201 DE Seply 21344 Gome B 22T Dome Saphy 23119 Randets u 24004 Brackenan Bros 20 ORDVA, n 44 DAK, he. 20 Darl Suple 2S Rico Syster D Srathen Pushing Singh Deega 22-3 TN 215-6 FL 616 616 TM Sath GA Ander Brning 101 615 206-1410 124 TN Brh 104 22000 FL Breythe TN PL 31. Create a trigger named trg_line_total to write the LINE_TOTAL value in the LINE table every time you add a new LINE row. (The LINE_TOTAL value is the product of the LINE_UNITS and LINE_PRICE values.)
Chapter6: Additional Database Objects
Section: Chapter Questions
Problem 19MC
Related questions
Question
![FIGURE P8.31 CH08_SALECO2 DATABASE TABLES
Database name: Ch08_SaleCo2
Table name: CUSTOMER
Table name: INVOICE
CUS CooE CuS LNAMECUS PNAME CuS NMAL CUSAREACOCE CU PHONE CuS BALANCE
OIE Rumas
CO1 Dure
W NUNGER | CUS_CO DATE
100 19014 16--1
1001 16Jan-18
TOTAL TA otAL
Ahet
Lre
Kay
544
04-126
000
1070
19012 16n-t
10011 17an-18
10018
153S
0013 Obenki
KCO14 Odundo Myren
COS O
56 76
00
0.00
221 19
16
4-210
222-1
403
2-12
1004
100s
280
7044
James
Gege
1000
10014 17an-18
10017 wane
15
10015 1tlan18
200
00 Fart
210
000
Are
Clate
1001 t
1008
431 de
615
207-00
Table name: LINE
WNUMEES DENUMBERCOCE| LHE UNTS UE PRICE UHE TOTAL
Table name: PRODUCT
1499
149
1001
1DERO Power pairte, 15 pa, Seorz
13-02 per bde
140 900 p e
00
1000
499
130eo-17
140
1000
1.223/OPD
13Nv-17
15a1a
12
1749
000 21344
1000
3 13022
749
14 90
19.00
70.44
207
108 92
1000
1490
19 om H 10n,0
z Y DO gnew. 12n
15-n-1
23
43
199
20e-17
24ec1
1004
1006
22OHE
1 PVCZDRT
1 SM 1077
2 22OTY
9.06
ar
12
22ORD BIO conder I0
20He O hanmer
21LAA Seanner, 12
54778-2 R tie, 1 e
WEO Heu chan saw, 10.
PVCDRT PVC pn, 3Sin, 6
20-n-18
12
1006
10 2125
1006
1006
1006
1000
1007
20--18
23
10
995
109 90
14 40
150ec-17
20
00 2144
1 13COP
29 98
499
2935
2.
1490
2
0S 2400
1 PVCCAT
2 WRSTT
490
68
119 6
1006
S18277 125n eow, 25
SN2E 25A wd. sorew.e
ARSTS Seeiming, t, nesh
12
75
000 21225
000 21201
10 25
1006
1000
100
Table name: VENDOR
VCOE VNAME VCONTACT VAREACODEV PHONE V STATE VORDER
2125 y, e
2126 upeles, he.
21201 DE Seply
21344 Gome B
22T Dome Saphy
23119 Randets u
24004 Brackenan Bros
20 ORDVA, n
44 DAK, he.
20 Darl Suple
2S Rico Syster D
Srathen
Pushing
Singh
Deega
22-3 TN
215-6 FL
616
616
TM
Sath
GA
Ander
Brning
101
615
206-1410
124
TN
Brh
104
22000
FL
Breythe
TN
PL
31. Create a trigger named trg_line_total to write the LINE_TOTAL value in the LINE
table every time you add a new LINE row. (The LINE_TOTAL value is the product
of the LINE_UNITS and LINE_PRICE values.)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F8f2dccbc-af9f-4667-bdec-c44100a89b79%2F3ee117b8-b05a-4a8a-9e65-661cbe3e4519%2Fhjqq1jp_processed.png&w=3840&q=75)
Transcribed Image Text:FIGURE P8.31 CH08_SALECO2 DATABASE TABLES
Database name: Ch08_SaleCo2
Table name: CUSTOMER
Table name: INVOICE
CUS CooE CuS LNAMECUS PNAME CuS NMAL CUSAREACOCE CU PHONE CuS BALANCE
OIE Rumas
CO1 Dure
W NUNGER | CUS_CO DATE
100 19014 16--1
1001 16Jan-18
TOTAL TA otAL
Ahet
Lre
Kay
544
04-126
000
1070
19012 16n-t
10011 17an-18
10018
153S
0013 Obenki
KCO14 Odundo Myren
COS O
56 76
00
0.00
221 19
16
4-210
222-1
403
2-12
1004
100s
280
7044
James
Gege
1000
10014 17an-18
10017 wane
15
10015 1tlan18
200
00 Fart
210
000
Are
Clate
1001 t
1008
431 de
615
207-00
Table name: LINE
WNUMEES DENUMBERCOCE| LHE UNTS UE PRICE UHE TOTAL
Table name: PRODUCT
1499
149
1001
1DERO Power pairte, 15 pa, Seorz
13-02 per bde
140 900 p e
00
1000
499
130eo-17
140
1000
1.223/OPD
13Nv-17
15a1a
12
1749
000 21344
1000
3 13022
749
14 90
19.00
70.44
207
108 92
1000
1490
19 om H 10n,0
z Y DO gnew. 12n
15-n-1
23
43
199
20e-17
24ec1
1004
1006
22OHE
1 PVCZDRT
1 SM 1077
2 22OTY
9.06
ar
12
22ORD BIO conder I0
20He O hanmer
21LAA Seanner, 12
54778-2 R tie, 1 e
WEO Heu chan saw, 10.
PVCDRT PVC pn, 3Sin, 6
20-n-18
12
1006
10 2125
1006
1006
1006
1000
1007
20--18
23
10
995
109 90
14 40
150ec-17
20
00 2144
1 13COP
29 98
499
2935
2.
1490
2
0S 2400
1 PVCCAT
2 WRSTT
490
68
119 6
1006
S18277 125n eow, 25
SN2E 25A wd. sorew.e
ARSTS Seeiming, t, nesh
12
75
000 21225
000 21201
10 25
1006
1000
100
Table name: VENDOR
VCOE VNAME VCONTACT VAREACODEV PHONE V STATE VORDER
2125 y, e
2126 upeles, he.
21201 DE Seply
21344 Gome B
22T Dome Saphy
23119 Randets u
24004 Brackenan Bros
20 ORDVA, n
44 DAK, he.
20 Darl Suple
2S Rico Syster D
Srathen
Pushing
Singh
Deega
22-3 TN
215-6 FL
616
616
TM
Sath
GA
Ander
Brning
101
615
206-1410
124
TN
Brh
104
22000
FL
Breythe
TN
PL
31. Create a trigger named trg_line_total to write the LINE_TOTAL value in the LINE
table every time you add a new LINE row. (The LINE_TOTAL value is the product
of the LINE_UNITS and LINE_PRICE values.)
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr