Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 Q2: Record all data of the following invoices in one table eithe unified or vary columns table. You should add your first name to
1 Q2: Record all data of the following invoices in one table eithe unified or vary columns table. You should add your first name to the item description instead of the student word. Sales Invoice 1 Sales Invoice 4 Customer # Sales Person C1 Basem C.Name Date Ahmad 15-Oct-20 Customer # Sales Person C3 Basem C.Name Date Muneer 20-Dec 20 Item# 10 50 Quantity Description 200 Rice Student 50 Tea_Student Total Invoice Unit price Extended Amount 5 1000 20 1000 2000 Item# 80 90 Quantity Description Unit price Extended Amount 200 Lentil Student 8 16001 50 Chickpeas_Student 12 600 Total Invoice 2200 Customer Addres St1 Qabatya Jenin Customer Addres St1 Qabatya Jenin Sales Invoice 2 iles Invoice 5 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Customer # Sales Person C2 Kamal C Name Date Kareem 15 Oct-20 Customer # Sales Person C2 Kamal C.Name Date Kareem 25 Dec 20 Item# 10 20 30 Quantity Description 50 Rice_Student 100 Sugar_Student 40 Coffee Student Total Invoice Unit price Extended Amount 250 4 400 25 1000 1650 Item# 10 80 Quantity Description 150 Rice_Student 100 Lentil_Student 80 Chickpeas Student Total Invoice Unit price Extended Amount 5 750 8 800 12 960 2510 90 Customer Addres St 2 Hewara Nablus Sales Invoice 3 Customer # Sales Person 01 Kamal C.Name Date Ahmad 15-Nov-20 Item# 50 33 34 35 36 37 38 39 40 Quantity Description 60 Tea_Student Total Invoice Unit price Extended Amount 20 1200 1200 Customer Addres St1 Qabatya Jenin 43 44 50 51 52 52 53 54 24 65 59 5/ 58 59 60 60 61 62 63 64 64 65 65 ob 6/ 68 69 70 70 71 72 12 73 74 74 75 75 89 90 91
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started