$1.$ Create a database called holy$\_$grounds

$2.$ Create the following tables based on the client$$s requirements:

a$.$ coffee$\_$inventory: This table will store information about all items in inventory.

i$.$ sku: An alphanumeric SKU

ii$.$ name: The brand and name of the coffee

iii. roast$\_$type: The type of roast of each coffee $($Dark$,$Medium$,$ or $$Light$)$

iv$.$ lbs$\_$on$\_$hand: Total pounds of coffee on hand $($can be fractional$)$

v$.$ organic: Only $2$ values, either organic or not

vi$.$ price$\_$per$\_$lb: price per pound of each coffee as a fractional value

b$.$ sales$\_$transactions: This table contains records of each purchase made

i$.$ receipt$\_$id: A number automatically assigned when a transaction is made. While this is a smaller company, they do have multiple locations and online sales. They complete a total of approximately $250$ million transactions a year between these different revenue streams. This client likes to keep receipt records for multiple years.

ii$.$ sale$\_$amount: Amount of each purchase as a fractional value

iii. sale$\_$type: The type of purchase made $($Online$$ or $$In$-$Store$)$

iv$.$ transaction$\_$date: The date and time a transaction occurs

c$.$ Stores: This table hold information about all company stores where coffee is sold

i$.$ store$\_$id: a numeric identifier automatically assigned when each store is opened

ii$.$ store$\_$manager: The first and last name of each store manager.

iii. store$\_$phone: Each store$$s phone number using format: $($xxx$)$ xxx$-$xxxx

iv$.$ store$\_$address: The store$$s physical address including street name and number

v$.$ city: city in which the store is located

vi$.$ zip: The store$$s $5-$digit zip code

vii. state: two letter state abbreviation