Ask DBMS Expert


Home >> DBMS

A twenty year old company, SewWorld, comprised of six 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.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91620728
  • Price:- $20

Priced at Now at $20, Verified Solution

Have any Question?


Related Questions in DBMS

Data mining assignment -in this assignment you are asked to

Data Mining Assignment - In this assignment you are asked to explore the use of neural networks for classification and numeric prediction. You are also asked to carry out a data mining investigation on a real-world data ...

Sql query assignment -for this assignment you are to write

SQL Query Assignment - For this assignment you are to write your answers in a word document. This assignment is in three parts: Part A (reporting queries), Part B (query performance), Part C (query design). For this assi ...

The groceries datasetimagine 10000 receipts sitting on your

The groceries Dataset Imagine 10000 receipts sitting on your table. Each receipt represents a transaction with items that were purchased. The receipt is a representation of stuff that went into a customer's basket. That ...

You are in a real estate business renting apartments to

You are in a real estate business renting apartments to customers. Your job is to define an appropriate schema using SQL DDL in MySQL. The relations are Property(Id, Address, NumberOfUnits), Unit(ApartmentNumber, Propert ...

Objectivethe objective of this lab is to be familiar with a

OBJECTIVE: The objective of this lab is to be familiar with a process in big data modeling. You're required to produce three big data models using the MS PowerPoint software. This tool is available on UMUC Virtual Deskto ...

The relation memberstudentid organizationid roleid stores

The relation Member(StudentId, OrganizationId, RoleId) stores the membership information of student joining organization. For example, ('S1', 'O2', 'R3') indicates that student with Id 'S1' joined the organization with i ...

Relational database exerciseyou have been assigned to a new

Relational Database Exercise: You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future. ...

Relational database design a given the following business

Relational Database Design A) Given the following business rules, identify entity types, attributes (at least two attributes for each entity, including the primary key) and relationships, and then draw an Entity-Relation ...

We can represent a data set as a collection of object nodes

We can represent a data set as a collection of object nodes and a collection of attribute nodes, where there is a link between each object and each attribute, and where the weight of that link is the value of the object ...

Data model development and implementationpurpose of the

Data model development and implementation Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain unde ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As