Today, Bob is using Excel spreadsheet to keep track of his customers. His busine

Question

Today, Bob is using Excel spreadsheet to keep track of his customers. His business is now growing and now he is asking for your help on how to switch to a more scalable solution, like a database.

This is what is known so far:

Over the last 6 months Bob has managed to capture information about 2,500 customers. Bob's business is growing 3% every month.

Bob has 25 employees located all around the world. They all need to be able to access customer data regardless of their location and computing platform (i.e. PC, Mac, Smartphone etc.,)

Everyone in the company needs to be able to run variety of queries on their customers

Bob's primary concerns are data integrity and availability (uptime)

Money is not an issue as long as there is proper justification for the expense

Phew - Now, looking at the database managemen, how would you go about helping Bob?

give a lot of details and example at least 300 words, and 5 references.
                  

Explanation / Answer

Database :

First of all we need to figure out what kind of data he wants to store and quantity of Data.

So if you have relatinal dependecy in Customer data like payroll or library then it is better to go for mysql. There are various advantages of this. It is already bench marked and many of the organizations are already using mysql. It is very usefull to store user related information also called as Identity manegment system.

It also provides ACID properties which includes integrity and consistency for availablity you can configure master slave set of mysql. Also here you can do access control also like which employee will be aable to access which table. You can revoke permissin any time. Also it is easy to use and you can find resources easily.

Let me know if you require more details.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.