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

  Linear-time algorithm to find odd-length cycle in graph

Give a linear-time algorithm to find an odd-length cycle in a directed graph. You may not suppose that graph is strongly connected.

  Design analgorithm that decides for each node

Design an O(n) algorithm that decides (schedules) for each node at which time slot to start sending data such that the total number of time (slots) is minimized.

  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.

  Explaining elementary operations used in algorithm

How many elementary operations are used in algorithm given below? The elementary operations are comparison operations (such as > and

  Question about passing parameters

Provide an example of when passing parameters through value as opposed to passing them by reference is a better method. Provide an example of when passing parameters through reference

  Algorithm to produce schedule for least completion time

What is the best order for sending people out, if one wants whole competition to be over as early as possible? More precisely, provide efficient algorithm which produces schedule whose completion time is as small as possible.

  Describe implementation of algorithm on simd computer

Describe an implementation of that algorithm on an SIMD computer where the processors are connected to form a linear array

  Create algorithm to calculte and print average earnings

Create the algorithm to calculte and print average earnings, lowest earnings, and highest earnings of group of employees. Each input record will contain name and earnings of one employee.

  Create list of major steps to follow to get input

Create a list of major steps to follow to get input, process, and output desired information (software requirements). Refine the list to include individual refined steps (algorithm).

  Write adjacency-list representation for complete binary tree

Provide the adjacency-list representation for complete binary tree on 7 vertices. Provide the equivalent adjacency - matrix representation. Suppose that vertices are numbered from 1 to 7 as in binary heap?

  Creating a table of xml documents

Make a table of XML documents with a type of XML. Use a primary key so add a field of type INT that is an identity. Insert many records into XML field in this new table.

  Analyze the time-space complexity of algorithms

How a vEB tree can be used to support these three operations and analyze the time/space complexity of your algorithms.

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