Required information

[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: 1) monthly payments, 2) semi-annual payments, or 3) the black belt program. Each of these programs allows them to take group classes as well 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 private lessons, and the black belt program includes one lesson per week until the student attains black belt rank. Additionally, they 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 price also varies depending on whether the lessons are provided by senior or junior instructors. When a student purchases a package, they are assigned to a particular instructor for the duration of the package. Students pay for anything that they buy at the time of their purchase. While all studio employees are also instructors, only a few employees handle sales transactions and accept payments.

c. Using the information in the description of the Bob White Karate Studio and the attributes listed below, identify the missing primary and foreign keys in the table listing below.

Attributes:

1. Cash account #
2. Cash account balance
3. Credit card number for this sale
4. Date sale paid
5. Employee/instructor #
6. Employee name
7. Employee rank
8. Instructor type
9. Inventory item #
10. Inventory item description
11. Inventory item price
12. Inventory item quantity on hand (QOH)
13. Private lesson package #
14. Private lesson package description
15. Private lesson package price
16. Program #
17. Program description
18. Program price
19. Quantity of instructors of this type
20. Quantity of this inventory item purchased on this sale
21. Sale #
22. Sale amount
23. Sale date
24. Sale paid (Y/N)
25. Student #
26. Student current rank
27. Student name
28. Student original enrollment date

Put the attribute in the appropriate blank in the table list below.

Required information

[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: 1) monthly payments, 2) semi-annual payments, or 3) the black belt program. Each of these programs allows them to take group classes as well 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 private lessons, and the black belt program includes one lesson per week until the student attains black belt rank. Additionally, they 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 price also varies depending on whether the lessons are provided by senior or junior instructors. When a student purchases a package, they are assigned to a particular instructor for the duration of the package. Students pay for anything that they buy at the time of their purchase. While all studio employees are also instructors, only a few employees handle sales transactions and accept payments.

c. Using the information in the description of the Bob White Karate Studio and the attributes listed below, identify the missing primary and foreign keys in the table listing below.

Attributes:

1. Cash account #
2. Cash account balance
3. Credit card number for this sale
4. Date sale paid
5. Employee/instructor #
6. Employee name
7. Employee rank
8. Instructor type
9. Inventory item #
10. Inventory item description
11. Inventory item price
12. Inventory item quantity on hand (QOH)
13. Private lesson package #
14. Private lesson package description
15. Private lesson package price
16. Program #
17. Program description
18. Program price
19. Quantity of instructors of this type
20. Quantity of this inventory item purchased on this sale
21. Sale #
22. Sale amount
23. Sale date
24. Sale paid (Y/N)
25. Student #
26. Student current rank
27. Student name
28. Student original enrollment date

Put the attribute in the appropriate blank in the table list below.

Required information

[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: 1) monthly payments, 2) semi-annual payments, or 3) the black belt program. Each of these programs allows them to take group classes as well 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 private lessons, and the black belt program includes one lesson per week until the student attains black belt rank. Additionally, they 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 price also varies depending on whether the lessons are provided by senior or junior instructors. When a student purchases a package, they are assigned to a particular instructor for the duration of the package. Students pay for anything that they buy at the time of their purchase. While all studio employees are also instructors, only a few employees handle sales transactions and accept payments.

c. Using the information in the description of the Bob White Karate Studio and the attributes listed below, identify the missing primary and foreign keys in the table listing below.

Attributes:

1. Cash account #
2. Cash account balance
3. Credit card number for this sale
4. Date sale paid
5. Employee/instructor #
6. Employee name
7. Employee rank
8. Instructor type
9. Inventory item #
10. Inventory item description
11. Inventory item price
12. Inventory item quantity on hand (QOH)
13. Private lesson package #
14. Private lesson package description
15. Private lesson package price
16. Program #
17. Program description
18. Program price
19. Quantity of instructors of this type
20. Quantity of this inventory item purchased on this sale
21. Sale #
22. Sale amount
23. Sale date
24. Sale paid (Y/N)
25. Student #
26. Student current rank
27. Student name
28. Student original enrollment date

Put the attribute in the appropriate blank in the table list below

	Resources
	Cash			(PK), Cash account balance]
	Inventory	[Inventory item # (PK), Inventory item description, Inventory item price.
	Packages	[Private lesson package # (K), Private lesson package description,						, Instructor
		Type (FK)]
	Programs	[Program # (PK), Program description,					]
	Events
	Sales	[Sale # (PK),	Sale amount, Sale date, Sale paid (Y/N), Credit card number for this sale, Date sale paid, Student #
		(FK),			(FK)], Program # (FK)]
	Agents
	Employees	[Employee/instructor # (PK), Employee name, Employee rank,						(FK)]
	Students	[Student # (PK),			, Student name, Student original enrollment date, Employee/
		Instructor # (FK)]
	Types
	Instructor Types	[Instructor Type (PK),					]
	Linking tables
	Sales-Inventory		+ Inventory item # (PK), Quantity of this inventory item purchased on this sale]
	Sales-Packages	[Sale # +			(PK)]
b. Prepare a UML class diagram with classes, associations, and multiplicities. Then, use your diagram to answer the following questions about this diagram. Use the list of potential class names and multiplicities listed below. Identify the appropriate class name for each letter, A through D, or the appropriate multiplicity to replace the numbers, 1 to 11, in the diagram above. Enter the number of the correct class name or multiplicity next to the letter or number below. Potential class names or multiplicities: Accounts Receivable Inventory (uniforms, sparring gear, etc.) Instructors Packages of Lessons Programs Students 0..0 0..1 1..1 0..* 1..* *..* Not an association for the Karate School diagram so no multiplicity required Enter the number of the class name or multiplicity next to the correct letter or number here. Use the list of potential class names and multiplicities listed below. Identify the appropriate class name for each letter, A through D, or the appropriate multiplicity to replace the numbers, 1 to 11, in the diagram above. Enter the number of the correct class name or multiplicity next to the letter or number below. Potential class names or multiplicities: Accounts Receivable Inventory (uniforms, sparring gear, etc.) Instructors Packages of Lessons Programs Students 0..0 0..1 1..1 0..* 1..* *..* Not an association for the Karate School diagram so no multiplicity required Enter the number of the class name or multiplicity next to the correct letter or number here.