logo Use SA10RAM to get 10%* Discount.
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Jacobs WilkinsTechnical writing
(5/5)

859 Answers

Hire Me
expert
Gabriel GaboardiLaw
(5/5)

1000 Answers

Hire Me
expert
StatAnalytica ExpertMathematics
(5/5)

677 Answers

Hire Me
expert
Mette BabstockScience
(5/5)

689 Answers

Hire Me
Business Statistics
(5/5)

Write a critical essay on the comparison of MS Access, SQL Server

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Assignment Title: Individual Essay

 

Description of the assignment, task, content, and structure:

JOMVO Delight Ltd in the last 10 years has been a customer-driven organisation, delivering innovative solutions to the challenges of a fast-developing market and demanding customer base sector. The company utilises fresh and high-quality raw ingredients from proven track record-supply chains networks to sell fresh, local, seasonal foods and buffet to schools and colleges, as well as offering a wide range of quality catering services to academics. They have a telesales operation and on 12th December 2021 set up an online sales system to better understand the relative profitability of its numerous customers. In order to stay relevant and competitive, the organisation is also looking for ways to use data to better understand their customers’ experiences and innovate faster. 

You are a DBMS consultant and, through your friend who is a senior management member of JOMVO Delight, you have been appointed to help assess the situation the company is facing. At your first meeting with the JOMVO Delight executives, the business is explained to you, and you are asked to investigate and employ a database solution as a new developmental process that will address the impair performance.   

Furthermore, the company’s executives have advised you to keep track of the employees’ details including their home address, contact information and rate of pay. You are also, allowed to assess their operations and customer database particularly, the customer’s contact information and their gender, regions, cities, and post codes. And finally, you are required to track the quality of services and incentives offered to customers in terms of standard price and promotions. 

Your tasks are as highlight two parts:

Part 1

Write a critical essay on the comparison of MS Access, SQL Server, and Oracle, and recommend which software you think is best for the JOMVO Delight firm. Clearly, present further convincing evidence that acquiring Database Management skill can further improve their business operations and how your choice of software can help achieve such value. Value should be mostly demonstrated because of extractable intelligence from the DBMS.  

Note: Individual Essay (2000 words excluding references; graphs and charts can be given in appendices) submission must contain a Word/PDF file.

 

Part 2

As a very knowledgeable Business Intelligence consultant, you have also been contacted by another friend of yours who is a senior manager in a global company to help design and appraise an end-to-end business intelligence solution. All you have been given is a CSV Superstore database folder containing information about the company’s global business operations including their sales and profits across regions and cities.    

Using any favorite charts of yours, the board want your group to design an executive Dashboard, and track and display any 3 of the 5 listed KPI’s: 

1) Customer segment 

2) Product category

 

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

Get Free Quote!

368 Experts Online