Database Management Systems Essay

Below is a free essay on "Database Management Systems" from Anti Essays, your source for free research papers, essays, and term paper examples.

The database in use currently at my employer is RetailIQ developed by IQMetrix. This database consists of many different pieces of information for the business. The piece that affects me the most is the customer database and the inventory database. The customer database holds all of our customer’s personal information like phone numbers, addresses and sales history. The inventory database allows me to see what items I have on hand at my location as well as my other locations. It also gives me the items that are on order and have not been received yet. Both of these databases are critical to the everyday operation of our business. RetailIQ also houses our POS which is a big part of our operation considering we are a retail store. This integrates the customer database and the inventory into one point to complete a sale.
The customer database is important to me as a manager because I can track customer purchases, make follow up calls and send promotional material to everyone in the system. I have the ability to run promotional campaigns and to only select customers within a certain zip code or city. I have run into some issues with this off the shelf software that seems simple but was unfortunately over looked. The first is consistency in the database, meaning when a new customer is entered in it does not correct punctuation and it also is not case sensitive. This leads to duplicate customers and different sales histories. When I have different sales histories and duplicate names it means that I am campaigning to the same people more than once. In turn, wasting money and possibly angering the customer because they have already been contacted once. There are also human errors like adding the wrong name to the database, because we have to match the records of T-Mobile we need to enter the account holder’s name. This means that just when a person has a phone on someone else’s account we have to enter the actual account holder’s name not the person paying for the phone....

Read Full Essay

Citations

MLA Citation

"Database Management Systems". Anti Essays. 2 Sep. 2014

<http://www.antiessays.com/free-essays/Database-Management-Systems-72448.html>

APA Citation

Database Management Systems. Anti Essays. Retrieved September 2, 2014, from the World Wide Web: http://www.antiessays.com/free-essays/Database-Management-Systems-72448.html