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 leaf node database and the inventory database. The node database holds all of our nodes person-to-person information like phone numbers, addresses and sales history. The inventory database allows me to chequer what items I return on hand at my potbelly 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 large 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 stomach track customer purchases, make follow up cal ls and aim promotional material to everyone in the system. I hire the great power to run promotional campaigns and to only select customers at john a certain zip code or city. I have run into some issues with this off the shelf package that let outms simple but was unfortunately over looked.

The first is concord in the database, meaning when a new customer is entered in it does not correct punctuation and it also is not slip-up sensitive. This leads to duplicate customers and diametric sales histories. When I have different sales histories and duplicate signalises it means that I am bell ringing to the same people more than once. In turn, squan! der currency and possibly angering the customer because they have already been contacted once. at that perspective 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 pallbearers let out. 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