FIGURE P8.31 CH08_SALECO2 DATABASE TABLES Database name: Ch08_SaleCo2 Table name: CUSTOMER Dcoor CUUNAME CUAME CUSAL AEACOce cuPHOE CUALANCE| Table name: INVOICE TO 16- 1 16 FO 2 1 1004 1011 17n 10 1 17 100 1014 17 10 15 KON Ound Mm s O Ay 222 000 212 Table name: LINE Table name: PRODUCT 2 2O TER Pwr part, 15Seorze 13 p 14g pc R 038 -17 13-17 13--17 2 15 15 2 S 9 2 2a DO ,n 22e , 22 O coe IG 2 O haner 200-17 12 20 20 12 23 10 2 2oty 10 996 1440 54778-2 e 1006 S77 1 ,2 2 2 1 45 Ih 11 2 wRm 329CHE 1000 Sing, ve, Peh Table name: VENDOR V coe VNAE [VCONTACT |VECOVOEV TATE VE 2 L Png Dee Sth Arder 2 D 2 Geme 2 D Shy 231 Ran ue 200 an OROVA 240 , Deete GA 01 N Bthe Sytew Den 31. Create a trigger named trg_line_total to write the LINE_TOTAL value in the LINI table every time you add a new LINE row. (The LINE_TOTAL value is the produc of the LINE_UNITS and LINE_PRICE values.)
FIGURE P8.31 CH08_SALECO2 DATABASE TABLES Database name: Ch08_SaleCo2 Table name: CUSTOMER Dcoor CUUNAME CUAME CUSAL AEACOce cuPHOE CUALANCE| Table name: INVOICE TO 16- 1 16 FO 2 1 1004 1011 17n 10 1 17 100 1014 17 10 15 KON Ound Mm s O Ay 222 000 212 Table name: LINE Table name: PRODUCT 2 2O TER Pwr part, 15Seorze 13 p 14g pc R 038 -17 13-17 13--17 2 15 15 2 S 9 2 2a DO ,n 22e , 22 O coe IG 2 O haner 200-17 12 20 20 12 23 10 2 2oty 10 996 1440 54778-2 e 1006 S77 1 ,2 2 2 1 45 Ih 11 2 wRm 329CHE 1000 Sing, ve, Peh Table name: VENDOR V coe VNAE [VCONTACT |VECOVOEV TATE VE 2 L Png Dee Sth Arder 2 D 2 Geme 2 D Shy 231 Ran ue 200 an OROVA 240 , Deete GA 01 N Bthe Sytew Den 31. Create a trigger named trg_line_total to write the LINE_TOTAL value in the LINI table every time you add a new LINE row. (The LINE_TOTAL value is the produc of the LINE_UNITS and LINE_PRICE values.)
Chapter13: Views
Section: Chapter Questions
Problem 1MC
Related questions
Question
Why my code cannot run?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
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.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning