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: $($a$)$ monthly payments, $($b$)$

semi$-$annual payments, or $($c$)$ 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, 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 price also varies

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. Students 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 handle sales transactions

and accept payments.

Required:

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:

Cash account #

Cash account balance

Credit card number for this sale

Date sale paid

Employee$/$instructor #

Employee name

Employee rank

Instructor type

Inventory item #

Inventory item description

Inventory item price

Inventory item quantity on hand $($ QOH