I need help with it all please if someone can. It is questions 1-9

Module 3 Database Assignment Please answer the following using the invoice and the database tables that follow these pages (each question is worth 2 points except for #9, which is worth 4 points). 1. Based on your readings from the textbook, which attributes are the likely primary keys for each of the 4 tables shown? a. Inventory? b. Sales? c. Customer? d. Sales-Inventory? 2a. Are any of the primary keys that you identified above considered a \"composite\" primary key? 2b. If yes, which one(s)? 3. Based on the database tables you have been provided, which of the Snerd International invoice (shown on page 4 of this assignment) fields are calculated by the ERP program rather than stored in the database? 4. Identify each of the \"foreign\" keys that are included as attributes in the database tables shown. Foreign keys are \"copies\" of the primary key of another table that are included in the linking table. These key fields allow the database to share data among the various tables. Note that any given table can have zero, one or more than one foreign key included among its attributes. I have completed the first one (Inventory table) for you a. Inventory table: no foreign key b. Sales table: ? c. Customer table: ? d. Sales-Inventory table: ? 5a. Will the fulfillment of the invoice shown on page 4 of this assignment result in any stockouts of inventory based on the data in the tables shown? 5b. Briefly explain how you determined the answer to 5a. 6. Which of the database tables shown include standing data (from Module 1, Ch. 3 readings)? 7. The recording of an invoice represents business event processing. Identify the specific database values that recording the invoice would change, if any, in each of the tables listed - a. Inventory table b. Customer table c. Sales table d. Sales-Inventory table (continued on next page) 8. Find a recent receipt from a purchase you made at a chain store (not a \"Mom and Pop\" store) and provide the code used on the receipt to indicate at which store location you made your purchase. Type the code in its exact form and the store name. Using this code, pick the coding scheme that you believe was used to identify the store (see Technology Summary 5.2, pp. 155-156) and explain why you think this is the scheme that was used. 9. (4 pts) When looking specifically at the relationship between the Inventory and the Sales-Inventory table a. which of the tables has the primary key of this relationship (see page 164)? b. which has the foreign key of the relationship? c. Would you describe the relationship between these 2 tables (Inventory and Sales- Inventory in that order) as a 1:N, M:N, N:1 or 1:1? Why? date hired date of birth IABLE 4-16 Database That Needs to Be Extended .= -t 1;r-.jit-ri:*1" * I ile:;f:p:i*l-: I 1"0513 :19" l,.ilonitor LS574 ?E" Msnitnr Qufrn.t'iy'on Hand 1fi62n Laser Printpr LriEl.J Lo{or LaSEr 6Jrrr i.*Et4 Muiti-funcfiEn ,i: I{ LISI PTICE $85.** tf, + $94e.sc 11 $:ss.** 5 s6ee.off 12 $Te9.G* 0 5*.s$ ofE ,( --!:ittt.. . ::-'ier \ niler \\iffe S:r:p: C,i\\ ' !!f5-! 6. Hr+tsiE tlBl f,4;:rr ar4e:a 1,2!7t J. J*ckron 466 W. Ork Tefipe 1361! P. SiELro 24e !. lr!ili l,/teJr 15637 5. llartirrer 28EE s$ring Tempe l82:g 6- i,oa[1s "i74r:A!dihe Teffpe *l aip CcdE - r l:It >. 'ir, tco02 nnEx $5:*s $5,ooo.6s s57&7 55,*CO.S0 A: i! AZ IU/ll./lUIx i.*rl*5 +nlr.r,16{6 10$06 1n?5(,1rnlo w/dr/{s!r. &7 * I -r r ,. . 1**03 11255 22 i.5ol; $1,675.C0 sC.CC $o.m frl 5399.00 i S1,uiS,CC 1S229 1l &ilEntity - Ariuai :iE:]"t ltul---rh*t" 559C.!C SO,CC fi l I 1"Sfr05 IUUUD # Un;i Pric 1 s4e5.e* 1.0574 1. $e43.** lfiAlil t L$822 3 :x.0573 I t "!"fi6t3 1 5btl.+t) IUJ'J 3 $4es.fl* C 5ti,tHl 1080,11. d 51,955.8* $?-io.c* :,. I!nlb*f E*8*.:. ::iinr*: l{ 25 t5 0 li-,.--l-$,.i,,'l,;;l'lir--tr.I::: ::r.j l{ dll ,rf? Ir -rr.ifr:f,E so.,us Saiance - ll gS;-:.0,1 i h {- I^ 16-{6 1ry2/20r.8 1]3]114 'n - ,*rmurt Date -:Salesperson- CustomErS - Amount 9l8l2c1B 2i 15617 slgg.cc rlr.0/2cr-8 .:2 i2971 S1,74a.cC g,i:s/?*!E 24 1iE2g sl-.1E5.tc Iri*0:1. + Cred,l Lirnii B5zSr S{,DDC.** AA * ! I n $7s3.G* $:*s.+* $4ss.e$ Hss.CIs i Snerd International INVOICE Bill to: Customer Number 15637 S. Martinez Date: 11/3/2018 2866 Spring Invoice Number: 10007 Tempe, AZ 85287 Salesperson # 22 Item Number Description List Price Quantity Extended 10574 21\" Monitor $949.00 2 $1,898.00 10624 Multi-function printer $799.00 1 $ 799.00 Subtotal $2,697.00 Tax 188.79 Total Due $2,885.79 Note that customer is entitled to a 2% discount if paid within 10 days of this invoice; otherwise, entire balance is due within 30 days of the invoice date above. Thank you for your business