Database Management Systems

The database in use currently at my employer is RetailIQ developed by IQMetrix. This database consists of many distinct pieces of information for the business. The piece that affects me the most is the node database and the inventory database. The client database holds all of our customers person-to-person information like phone numbers, addresses and sales history. The inventory database allows me to mark off what items I return on hand at my corporation as well as my other locations. It also gives me the items that atomic number 18 on order and pitch not been received yet. both(prenominal) of these databases atomic number 18 critical to the everyday operation of our business. RetailIQ also houses our POS which is a huge part of our operation considering we are a sell 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 butt joint track customer purchases, make follow up calls and transfer promotional material to everyone in the system. I have the efficacy to run promotional campaigns and to only select customers at bathroom a certain zip code or city. I have run into some issues with this off the shelf share that beguilems simple but was unfortunately over looked.

The first is equilibrium in the database, meaning when a new customer is entered in it does not correct punctuation and it also is not gaffe sensitive. This leads to duplicate customers and polar sales histories. When I have different sales histories and duplicate signalises it means that I am campaign to the same people more than once. ! In turn, squander specie and possibly angering the customer because they have already been contacted once. at that crop are also human errors like adding the wrong see to the database, because we have to match the records of T-Mobile we need to enter the account carriers relieve oneself. This means that just when a person has a phone on someone 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, visit our page: write my paper