develop an information system based on a computer sales and maintenance store of your choice.

Information Analysis
Paper, Order, or Assignment Requirements

You are required to develop an information system based on a computer sales and maintenance store of your choice. The store has a number of branches and there are a number of personnel working in each branch. Personnel can be reassigned to other branches to work. The store’s services include computer sales, repair computer parts and installing and upgrading software and hardware.

There are multiple owners of the store and they wish to have an information system that gives them up to date information about the current status of the business. The owners are often in different locations and therefore the system needs to be available from multiple remote locations. Furthermore, the owners have very little technical skill and therefore, the information presented to the owners must be in visual form (e.g. a dashboard).

The store would like to use the system for analysing sales, cost and customer trends. They expect it to be constructed in a way such that a range of queries are available to them. The owner’s most urgent need is to have information concerning the volume of sales of different products and services, the volume of sales in each location, and the performance of their sales personnel.

You may assume the following for simplification purposes:

There are only 6 months of trading data available.
The store has 8 personnel.
The store has 3 branches in the city.
The store provides only 12 different products and services.

Requirements:

You must store the data in Database management systems (DBMS) (e.g. MySQL, MS SQL). You can assume that this database is automatically updated when a sales event occurs. Therefore, you only need to populate the database with static data.
Populate the database with a small amount of data. The data should be meaningful but does not need to be extensive. The following sites may be useful for quickly generating data:
http://www.databasetestdata.com/
http://www.generatedata.com/
Use pivot tables in Excel to visualise the data in the system.
The connectivity will be handled using ODBC (Open Database Connectivity).
You must supply at least five visualisations for your system. An example of a useful interactive visualisation might be the following:
A chart that shows the overall sales per month in the six months of trading. Allow the owner to further select a specific product or services to see its sales over the six months.
A chart that shows the overall sales per employee.
State any assumptions that you make in modelling the business.

You must produce a report with some design documents. Detailed report requirements are described under report section.

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"