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

Describe the four steps in the training process

Describe the four steps in the training process. In your view, how important has the training process been at organizations you have worked (if you have not worked, then pleas

Types of hazardous materials warning systems

Describe the two types of hazardous materials warning systems and their advantages/disadvantages to first responders. What changes/improvements, if any, would you suggest to

Consider as best for the consumers

Discuss what you would consider as "best for the consumers" in light of the overwhelming number of regulatory mandates and agencies involved in providing health care to our ci

Cause partial productivity of particular input to be reduced

Research the construction industry to learn what the inputs are that are used by such a homebuilder to build homes (the homes are obviously the output that is being produced b

Comments written in performance appraisals

I have actually seen the following comments written in performance appraisals: “She’s a good religious lady. She has high morals and values with decisions.” “She doesn’t hear

Demonstrate ethical scholarship in appropriate

Write in a clear, concise, and organized manner. Your response should demonstrate ethical scholarship in appropriate and accurate representation and attribution of sources (

Growth stage into the mature phase of the life cycle

As an industry moves from the growth stage into the mature phase of the life cycle, and consolidation (i.e. acquisitions of smaller players by larger players) begins, explain

Secondary risks are generating high impact threats

As the risk owner, you have identified an action for a risk and now have also identified secondary risks based on that action. These secondary risks are generating high impact


Write a Review

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