CUSTOMER Code LName FName Initial AreaCode Phone C001 Peters Johny J 021 889-1234 C002 Nkosi Thabo P 011 234-9966 C003 C
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
CUSTOMER Code LName FName Initial AreaCode Phone C001 Peters Johny J 021 889-1234 C002 Nkosi Thabo P 011 234-9966 C003 C
Figure 3. Provide the statements you used to
populate each of the tables
CUSTOMER Code LName FName Initial AreaCode Phone C001 Peters Johny J 021 889-1234 C002 Nkosi Thabo P 011 234-9966 C003 Christie Agatha 012 627-7530 INVOICE Number Date C Code 00011 2022-03-01 C001 00012 2022-03-09 C003 LINE Number Units Price Number P_Code 1 1 200.00 0011 SL_01 2 10 10.00 0011 PR 01 3 2 1200.00 0011 PR_03 1 2 725 0012 SL_02 PRODUCT Code Description Price Vendor SL 01 Fingerprint kit 250.00 Simple Sleuth PR_01 Fake blood 10.00 Props unlimited SL_02 Magnitying glass 725.00 Eye Glass PR_02 Ropo 125.00 Mountain Climbers PR_03 Prop Gun 1456.00 UnReal Figure 3: Relations and their state