Internet-based discount computer supply service

Assignment Help Operation Management
Reference no: EM132234866

A group of entrepreneurs are establishing a new nation-wide, Internet-based discount computer supply service. The service, which will be named Discount Computer Parts, will work as other similar "shop-by-Internet" services.

Specifically, the entrepreneurs foresee the following "typical" scenario. Individuals will be required to purchase yearly memberships for a nominal fee which entitle them to use the shopping service. A member initiates a sale by accessing Discount Computer Parts’ Web page and verifying their membership status with their membership number. This process will be supported through a database system of membership information that is accessed automatically by the Web page software. The system will present the current information stored in the database so that the user may verify that the database is correct. Membership information includes member identification number, name, billing address, shipping address (often the same as the billing address), telephone number, fax number, and email address.

Each member is categorized as either "good standing" (i.e., good payment history), "questionable" (i.e., 3 late payments), or "prohibited" (i.e., no longer allowed to order due to non-payment of any order). New members start with a "good standing" rating. "Prohibited" members move into the "questionable" category upon payment of any outstanding balance. Once they have promptly paid three new orders, they move into “good standing” again.

Once membership has been verified, the member may order whatever items are desired from one of many Web pages that can be accessed. Of course, all inventory displayed in the Web pages will be in a database system.

Inventory in the database system will be categorized by hardware, software, and document­tation (for educational materials). Each item has an inventory number, price, manufacturer's name, and current stock level. A sale will automatically generate a shipping order which will be used (1) at a warehouse to fill the order, (2) at the company to provide a record of the sale, and (3) at the shipping center to provide a shipping label. Each inventory item has a minimum stock level.

Sales information must include all relevant member information, the product(s) ordered and shipped (product numbers, quantities, etc.), the order date and the shipping date, and the price at which the product was sold. Some products may be backordered due to insufficient inventories. When backorders occur, an additional "backorder record" must be generated to ensure the order is eventually filled. The backorder record should contain essentially the same information as a sales transaction record.

Discount Computer Parts also intends to support members after sales by providing a toll-free technical consultant telephone number. These consultants need to have access to membership data and sales data to confirm that telephone calls are from valid members and that the members are requesting information relevant to their recent purchases. A customer service log maintains records of calls, including the date and time of the call, which employee handled the call, the nature of the call, and the resolution of the call.

Employee data includes the normal name, address, title, wage or salary, and a unique employee number.

The entrepreneurs want you to prepare a data model of their situation as a basis for discussing the implementation of the database.

Your tasks:

Draw a data model for this business.

Identify the associative entities and subtype entities (if any)

Identify any ID-dependent entities.

Reference no: EM132234866

Questions Cloud

How technology improved their business operations : Show examples of how technology improved their business operations.
Normal economic conditions : You estimate that your cattle farm will generate $0.25 million of profits on sales of $5 million under normal economic conditions and that the degree
Strengths and weaknesses of the company marketing efforts : Analyze the strengths and weaknesses of the company’s marketing efforts.
Evaluate your pricing plans with those of any competitors : Evaluate your pricing plans with those of any competitors that may be providing identical or similar products or services.
Internet-based discount computer supply service : A group of entrepreneurs are establishing a new nation-wide, Internet-based discount computer supply service.
What is your opinion of whistleblowing : If you were aware of criminal activity in your organization but knew that reporting it would probably cost you your job, what would you do?
How much principal will be outstanding : You want to buy a house for $425,000. You plan to make a down payment of $75,000. If you take out a 30-year mortgage at a 4.8% APR
Packard commission from project management : Explain the Packard Commission from a project management point of view.
What is the approximate forward exchange rate : What is the approximate forward exchange rate for 180 days?

Reviews

Write a Review

 

Operation Management Questions & Answers

  Stewardship differ from traditional leadership philosophies

How do the concepts of servant leadership and stewardship differ from traditional leadership philosophies?

  What would you do as a hospital ceo to keep your patient

Many Americans are now traveling outside of the U. S. for elective medical procedures. What does this mean in terms of service area competitor analysis?

  Ace defaults on its payments to its lender

Jody goes to the Ace Dealership and purchases a car with cash that she received in her divorce settlement. Ace Dealership has an inventory of 200 cars. Jody picks a brand new car that she loves and drives home. Ace defaults on its payments to its len..

  When did you play the role of a change recipient

When did you play the role of a change recipient?

  Setting compensation according to labor markets

What are some advantages and disadvantages of setting compensation according to the labor markets in the countries where the employees live and work?

  How does this artifact interact with you in personal lives

IDS 404: What theoretical framework from Chapter 2 frames or constructs your reading of this artifact through the humanities lens?

  What is the key to google competitive advantage

Why has Google’s business grown so rapidly? What is the key to Google’s competitive advantage?

  Engine started out with different keyword auction approaches

Although different search engines started out with different keyword auction approaches,

  Explain how to operationalise

Select one organisational behaviour concept and explain how to operationalise it through an additional human resource process other than the one(s) it is linked to in the matrix.

  Explain the basis for the persuasiveness of these tactics

Explain the basis for the persuasiveness of these tactics and provide instance of explain how these tactics could be improved. Describe which groups of people are most susceptible to the tactics you analyze.

  Studying and applying organizational behavior concepts

What is the goal in studying and applying organizational behavior concepts? Pick one of the four organizational behavior disciplines and use a brief example to describe how it relates to this goal.?

  Design your health promotion campaign

Assume you are making a professional presentation to gain community support for your health communications campaign.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd