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 $($money

data type not allowed$)$

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

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