Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Maliks 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 Maliks Gaming sells are fully created in house, while other games are purchased from trusted vendors and sold to Malik Gamings customers. They have hired you to help design a database that reflect the following data needs.
Maliks 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. Maliks Gaming has two categories of employees and uses a different coding scheme to identify each Cashier and Salesperson Cashier# SalesPerson#
Maliks 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:
Payment can be made immediately using an online payment method
Payment can be made on the th of the following month via check or online payment method
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. Maliks 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.
Question
Draw the conceptual model the ER diagram that models the transaction processing needs described for Maliks 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.
Please Show me the Complete ER Diagram by drawing it with all entities, maximum and minimum cardinalities for all relationships, etc. So I can see it visually instead of listing it
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started