Separate inventory database

Assignment Help Data Structure & Algorithms
Reference no: EM1380293

Question: A 20-year old corporation, SewWorld, comprised of 6-locations in three states, sells sewing machines, sewing related software, and accessories. Each store sells between 3-5 different brands of sewing machines. Currently the stores run independently with separate inventory databases, budgets, and expenses. Because the stores run independent inventory databases, their inventory information is sometimes inaccurate. This leads to a loss of customers who did not want to wait for a product and went elsewhere. Also, when stores share inventory, more times than not, the information is never entered into the independent databases. This results in one store showing a missing item while another store is showing in excess.

Each store has a manager who is responsible for the day-to-day operation of that store and is paid a portion of his/her store's profits. Though there are computers with inventory/sales programs, the managers must mail reports and back-up floppy disks to the corporate office each week to keep inventory, sales, payroll, and commission information up-to-date. Due to this process, some disks are lost in the mail, and inventory, sales, payroll, and commission information is slow to gather and inefficient.

The company sells some of the vendor's products online, but the high-end machines must be sold by a local authorized dealer because they require some amount of training and face-to-face support.

The owner of SewWorld has realized their information system and internal processes creates inaccuracy, loss, inefficiency, and diminished productivity. The owner has decided it's necessary for the success of SewWorldto transition to a professional management team. The owner has hired you to do an analysis regarding SewWorld's information systems and what needs to be done to compete. Your main goal is to bring the information systems' issues in-line. You're also open to accepting a full-time position with SewWorld if the need arises.

SewWorld's current infrastructure may be described as follows:

Each store is equipped with 2-6 microcomputers, used for running an off-the-shelf point of sale (POS) software or responding to e-mail.

All data is stored locally on the microcomputers themselves as no store owns a server.

Stores are not configured with a Local Area Network (LAN) nor are any stores interconnected by a Wide Area Network (WAN).

Each location has one dial-up Internet account and one e-mail address for the store manager.

Details: One of the first things you need to do is convince the current owner of SewWorld that he needs to collect and use data. Here's what you want to get across to him: data is the facts, figures, and details collected about an organization. The data becomes information when it is put into meaningful context. Information systems help create greater knowledge and wisdom about the organization if the consumer of the information can manage and manipulate the data in appropriate ways for their enterprise.

Develop a PowerPoint presentation to share with the owner. The presentation should be structured with the following topics addressed:

Review some of the tools you use whether at home or school that helps turn the data we are exposed to into information for making decisions.

Elaborate further on the definition of information systems answering the following questions:

What is data?
What is information?
What is knowledge?
How does an information system increase a company's competitive position?

Identify what kinds of business information SewWorld would likely be interested in storing, retaining, and reporting on.
Research an ERP (Enterprise Resource Planning) software application that would be a good fit for SewWorld. Explain how the ERP application would address SewWorld's Transaction Processing System (TPS), Management Information System (MIS), and Executive Information System (EIS) needs.

 

Reference no: EM1380293

Questions Cloud

Creating a single table to hold the information : Think about a typical sales invoice that would include the given information. Create a single table to hold all of the information needed to store an invoice including this information.
Creating an idef1x diagram : Construct an IDEF1X diagram that demonstrate only entities and relationships. Name each relationship and specify its cardinalities.
Detailed strategies to recruit : What are the qualifications of a trained Mechanical Engineer and what selection methods are best to assess whether or not an applicant meets or exceeds those qualifications
Create an idef1x entity relationships diagram : The Metropolitan Housing Agency is a non profit corporation that advocates the development and improvement of low income housing.
Separate inventory database : A 20-year old corporation, SewWorld, comprised of 6-locations in three states, sells sewing machines, sewing related software, and accessories. Each store sells between 3-5 different brands of sewing equipments.
Inventory tracking database : Construct a relational database of your choice. The DB should contain no more than six tables. Define three business requirements that this database will provide.
Inventory tracking database : Construct a relational database of your choice. The DB should contain no more than six tables. Define three business requirements that this database will provide.
How does dividend payment affect stock price : What are advantages and disadvantages of stock repurchases relative to traditional dividend payments and how does dividend payment affect stock price? any supporting evidence?
Creating database for a human resources group : Construct a database for a human resources group. List a few different tables and columns to store the HR information.

Reviews

Write a Review

Data Structure & Algorithms Questions & Answers

  Writing a c program

Create a C program that has a declaration in main() to store the following numbers into an array named channels: 2, 4, 5, 7, 9, 11, 13. There should be a function call to display().

  Program for stack by using dynamically allocated array

Write a C++ class which implements stack by using a dynamically allocated array. Initial size of particular stack must be determined when it is created.

  Build b tree for the part table

Build B+ tree for the PART table with n = 6 pointers; illustrate how B+ tree expand (show several intermediate trees) and what final tree will look like.

  Determine expected number of collisions use hash function

Assume we use hash function h to hash n distinct keys into the array T of length m. Suppose simple uniform hashing, determine the expected number of collisions?

  Explain consensus algorithm

"Consensus algorithm": A group of ten people need to decide which one flavor of ice cream they will all order, out of three options.

  Sort array of elements using the quick sort algorithm

"sort an array of 10,000 elements using quick sort algorithm as follows: sort the array using pivot as middle element of the array

  What would ultimate result of algorithm

Single grain of wheat was to be placed on the first square of chess board, two on second, four on third, eight on the fourth, and so on, until all 64 squares had been filled. What would ultimate result of this algorithm have been?

  Developing a new application system

Assume you have been assigned as manager on a assignment to develop a new application system for your business partner. You were given 2-weeks to construct a project plan and high level cost estimates.

  Process of insertion into a heap-implemented priority queue

Explain the process of insertion into a heap-implemented priority queue, and informally explain its complexity and the process of removal from a heap-implemented priority queue, and informally explain its complexity.

  Find the checksum field in a single parity bit scheme

Assume that the information content of a packet is the bit pattern 1111000010100101 and an even parity is being used

  Explain sorting algorithm which is optimal in cost

Explain a sorting algorithm which is optimal with respect to this cost model and uses O(n) space. That is, time used by algorithm should exactly match lower bound

  Use sequential search algortithm to locate the number

These numbers should be stored in an array. Use the sequential search algortithm to locate the number entered by the user. If the number is in the array, the program should display a message.

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