Malik$$s Gaming., develops and sells licenses of customized video game applications to customers

through a social media network using marketing consultants. They deal in unique license sales $($no

resales$).$ Some video games that Malik$$s Gaming sells are fully created in house, while other

games are purchased from trusted vendors and sold to Malik Gaming$$s customers. They have

hired you to help design a database that reflect the following data needs.

Malik$$s Gaming strives to provide the best possible customer service. To encourage strong

salesperson and customer relationships, potential customers are assigned to a salesperson and

only that one salesperson assists the customer with each sale. Malik$$s Gaming has two categories

of employees and uses a different coding scheme to identify each Cashier and Salesperson

$($Cashier#$,$ SalesPerson#$).$

Malik$$s Gaming maintains list prices for apps sold, but each salesperson is allowed to give a

reasonable discount off the list price $($although the discount affects the salesperson commission$).$

Each sale can include one or more video game licenses and each sale is registered to a single

customer.

Customers can pay off each sale in one of three ways:

$1.$ Payment can be made immediately $($using an online payment method$).$

$2.$ Payment can be made on the $15$th of the following month $($via check or online payment

method$).$

$3.$ Monthly payments can be made over the subsequent six months $($via check or online

payment method$).$

A Cashier processes each payment, and each customer payment is applied to one or more

specific sales invoices. Malik$$s Gaming uses a single bank $($and no plans to change$),$ but they

have a number of different cash accounts in their bank. Each customer payment is deposited in full

into one cash account.

Requirements:

Malik$$s Gaming Page $2$

$1.)$ Draw the conceptual model $$ the E$-$R diagram that models the transaction processing needs

described for Malik$$s Gaming, Inc. On this version, show the cashier and salesperson employee

entities as separate entities $($and separate relations$).$ Show the maximum and minimum

cardinalities for all relationships