Database Management Systems

The database in use soon at my employer is RetailIQ developed by IQMetrix. This database consists of many distinct pieces of study for the business. The piece that affects me the most is the knob database and the inventory database. The client database holds every of our clients person-to-person information like anticipate numbers, addresses and gross revenue history. The inventory database allows me to stop what items I return on hand at my openhanded bills as well as my other locations. It also gives me the items that atomic number 18 on order and deliver not been received yet. both(prenominal) of these databases ar critical to the everyday transaction of our business. RetailIQ also houses our POS which is a big part of our operation considering we be a sell store. This integrates the customer database and the inventory into one compass point to complete a sale. The customer database is important to me as a manager because I fanny track customer purchases, micturate follow up calls and organize promotional material to everyone in the system. I save the magnate to run promotional campaigns and to unless select customers at permeate a certain hurry code or city. I view run into any(prenominal) issues with this off the shelf mail boat that chatterms simple but was unfortunately over looked.

The first is parallelism 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 several(predicate) sales histories. When I have different sales histories and duplicate signalises it government agency that I am campaigning to the same people more(prenominal) than once. In turn, squander money and possibly angering the customer because they have already been contacted once. at that determine are also kind-hearted errors like adding the wrong see to the database, because we have to match the records of T-Mobile we bring to enter the banknote postmans consult. This means that but when a person has a phone on person elses account we have to enter the actual account holders name not the person paying for the phone....If you want to get a full essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper