Answered step by step
Verified Expert Solution
Link Copied!

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:
1. Payment can be made immediately (using an online payment method).
2. Payment can be made on the 15th 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. 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
1.) Draw the conceptual model the E-R 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data And Databases

Authors: Jeff Mapua

1st Edition

1978502257, 978-1978502253

More Books

Students also viewed these Databases questions