This is an individual coursework. 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:
1. You must store the data in a relational format using MySQL. 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.
2. 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:D
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]