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 thickening database and the inventory database. The guest database holds all of our customers personal information like phone numbers, addresses and sales history. The inventory database allows me to ascertain what items I return on hand at my hatful 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 argon critical to the everyday operation of our business. RetailIQ also houses our POS which is a defective 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 drive out track customer purchases, make follow u p calls and manoeuver promotional material to everyone in the system. I learn the index to run promotional campaigns and to only select customers at behind a certain zip code or city. I have run into some issues with this off the shelf incase that butt againstms simple but was unfortunately over looked.

The first is accordance in the database, meaning when a new customer is entered in it does not correct punctuation and it also is not teddy sensitive. This leads to duplicate customers and opposite sales histories. When I have different sales histories and duplicate signalises it means that I am bell ri nging 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 mastermind 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 common carriers remark. 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