Purchase Solution

Who, What, Where, When, Why, and How of Data Model Design

Not what you're looking for?

Ask Custom Question

Scenario:

Moonlight Distributors is a 10-year-old transportation firm that specializes in pickup and delivery from a wide range of businesses. There is a corporate office in Chicago, IL and three regional offices in Pittsburgh, PA, Omaha, NE, and San Francisco, CA.

Diane, the CEO, has been seeing sales and profits slip for the past three years. Tony from billing says that the problem lies in getting accurate and timely information from the regional offices. Because of all the paper work involved, the three regional managers complain that they can't get the information to Tony any faster.

Every shipment, about 10,000 per month per region, requires a pickup document with the shipper information, a description of the goods to be shipped, where these goods are going, and who is paying the freight. Once the pick up is made and brought back to the terminal, the goods need to be checked against the manifest and then set up for delivery. Once the drivers come back off the delivery route, they fill out delivery documentation including when the goods were signed for.

You are the IT Director for Moonlight, and have been mandated by Diane to create a system that would reduce the overhead at the regional terminals. You suggest putting in a distributed computer system, having computers at each of the regional offices and corporate headquarters. You created a conceptual design for the shipping information system and will eventually link it to the Billing, Finance, and Marketing Systems.

Some of the information that is needed is - status of every pick up and delivery, weekly reports for On-Time-Delivery, a monthly report on new customers, profitability, market share gains and losses, the number of new customers, the volume and charges, and how many problems occurred that cut into profits (such as late delivery, damage delivery, and refused shipments).

Assignment

Your supervisor requested a short memo identifying each of the five W's and the H (Who, What, Where, When, Why, and How) and how each could influence the design of the logical database model. Compose an 600-word e-mail to your supervisor.

Question:

I need help idenfiting the five W's and the H (Who, What, Where, When, Why, and How) of the database.

Attachments
Purchase this Solution
Solution Summary

This solution provides an insight into the who, what, when, where, and why, and how of a data model design.

Purchase this Solution
Free BrainMass Quizzes
Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Javscript Basics

Quiz on basics of javascript programming language.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

View More Free Quizzes
Related BrainMass Solutions

  • Instructional System Design Model (ISDM)

    The ISDM was developed to cover who, what, when, where, why and how of learning and can help institutions make solid decisions based on individual training needs.

  • Smoking Cessation Evaluation

    With regard to data collection it might not be indicated in professional literature but to help in starting, looking at the 5Ws might be useful. Who is the target population? What will you do with that group? When will it be done? Where and How?

  • Requirement management, cotext & process model, event model

    What types of functions do these tools provide and why do we need such things? 2. Context Model/Process Model a) What is the purpose and value of the context model? b) David A.

  • Descriptive Marketing Research and the Six Ws

    · When can your customers expect the product (new line of cookies)? Learn how to automate so you are there for your prospects and customers. Question 6: What else?

  • Database Design

    As a System Analyst, after you gathered systems requirement, how are you going to analyze these data? Are you starting with business process first or start with data directly? Explain each approach and why or why not? 2.

  • Behavioral Model: Iteration

    528799 The Behavioral Model of Iteration is significant in system analysis or design in terms computer science; and this solution discusses its importance. Why is iteration important when creating a behavioral model?

  • Research on Teen Independence

    Research design (you may name the model and then try to explain how the model would be used to create a study) - help! Dear Student, Hi and thank you for your trust.

  • PERFORMANCE TESTS: HR EVALUATION

    WHAT DIFFICULTIES ARE ENCOUNTERED WHEN USING EVALUATION INFORMATION OBTAINED FROM OBSERVERS? WHICH IS THE MOST EFFECTIVE DATA-COLLECTION METHOD? WHY? IS IT POSSIBLE TO USE ALL DATA-COLLECTION METHODS IN THE EVALUATION OF A SINGLE PROGRAM?

  • Ethical Use of Assessments

    403231 Assessment and Ethics What is the appropriate and inappropriate use of assessments in instructional design. Identify guidelines that could be used in evaluating the use or misuse of assessments.

View More Related Solutions