Put the attribute in the appropriate blank in the table list below: Required: c. Using the information in the description of the Bob White Karate Studio and the attributes listed below, identily the missing primaxy and foreign keys in the table listing below Aturbutes: 1. Cash account f 2. Cash account baiance 3. Credit card number for this sale 4. Date saie paid 5. Employeeinstructor x 6. Employee name 7. Employee rank 8 Instructor type 9 inventory fiem z 10. Ifventory tem description 11. inventory nem price 12. thventory them quantity on hand (cote 13. Private lessan package 14. Private leswon package description 15. Proate lessen package price 36. Program a 17. Program description 18. Program price 79. Quantity of instructors of tis type 20. Guantity of thes tiventacy nem purchased on the ule 21.5 sie of 22. Sale amburt 22 Sale date 24. Saic paid rrav 25. Stidened 20. Student cunese tars: 2). Stident nang Required information Problem 5-2 [LO 5-2, LO 5-3, LO 5-5, LO 5-6, LO 5-7] [The following information applies to the questions displayed below] The Bob White Karate Studio has been a local fixture for almost 40 years. The studio offers training in American Kenpo Karate to students from 3 years old to 80 years old. Students select one of several programs; (a) monthly payments, (b) semi-annual payments, or (c) the black belt program. Each of these programs allows them to take group classes as weif as one or more private lessons with a qualified black belt instructor, depending on the program selected. For example, the monthly program includes one private lesson, the semi-annual program includes three privote lessons, and the black belt program includes one lesson per week until the student attains black belt rank Additionally, students may purchase additional private lessons, as well as uniforms, sparring gear, and various studio insignia and clothing items, The additional half-hour private lessons are priced as packages, which include 5, 10.20, 40, or 60 lessons, and the pice also vories depending on whether the lessons are provided by senior or junior instructors. When students purchase a package, they are assigned to a particular instructor for the duration of the package. Studentr typically pay for anything they buy at the time of their purchase, but established students are sometimes allowed to purchase on credit in that case, they generally must pay within 2 weeks. While all studio employees are also instructors, only a few employees hande sales transactions and accept payments. Put the attribute in the appropriate blank in the table list below: Required: c. Using the information in the description of the Bob White Karate Studio and the attributes listed below, identily the missing primaxy and foreign keys in the table listing below Aturbutes: 1. Cash account f 2. Cash account baiance 3. Credit card number for this sale 4. Date saie paid 5. Employeeinstructor x 6. Employee name 7. Employee rank 8 Instructor type 9 inventory fiem z 10. Ifventory tem description 11. inventory nem price 12. thventory them quantity on hand (cote 13. Private lessan package 14. Private leswon package description 15. Proate lessen package price 36. Program a 17. Program description 18. Program price 79. Quantity of instructors of tis type 20. Guantity of thes tiventacy nem purchased on the ule 21.5 sie of 22. Sale amburt 22 Sale date 24. Saic paid rrav 25. Stidened 20. Student cunese tars: 2). Stident nang Required information Problem 5-2 [LO 5-2, LO 5-3, LO 5-5, LO 5-6, LO 5-7] [The following information applies to the questions displayed below] The Bob White Karate Studio has been a local fixture for almost 40 years. The studio offers training in American Kenpo Karate to students from 3 years old to 80 years old. Students select one of several programs; (a) monthly payments, (b) semi-annual payments, or (c) the black belt program. Each of these programs allows them to take group classes as weif as one or more private lessons with a qualified black belt instructor, depending on the program selected. For example, the monthly program includes one private lesson, the semi-annual program includes three privote lessons, and the black belt program includes one lesson per week until the student attains black belt rank Additionally, students may purchase additional private lessons, as well as uniforms, sparring gear, and various studio insignia and clothing items, The additional half-hour private lessons are priced as packages, which include 5, 10.20, 40, or 60 lessons, and the pice also vories depending on whether the lessons are provided by senior or junior instructors. When students purchase a package, they are assigned to a particular instructor for the duration of the package. Studentr typically pay for anything they buy at the time of their purchase, but established students are sometimes allowed to purchase on credit in that case, they generally must pay within 2 weeks. While all studio employees are also instructors, only a few employees hande sales transactions and accept payments
