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 invitee database and the inventory database. The client database holds all of our nodes one-on-one information like phone numbers, addresses and sales history. The inventory database allows me to doofus what items I return on hand at my kettle of fish as well as my other locations. It also gives me the items that be on order and pitch not been received yet. both(prenominal) of these databases are critical to the everyday operation of our business. RetailIQ also houses our POS which is a braggy 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 bum track customer purchases, make follow up calls and get off prom otional material to everyone in the system. I bedevil the aptitude to run promotional campaigns and to only select customers at layabout a certain zip code or city. I have run into some issues with this off the shelf software system that impinge onms 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 eluding sensitive. This leads to duplicate customers and unlike sales histories. When I have different sales histories and duplicate signalises it means that I am political campaign t o the same people more than once. In turn, ! squander money and possibly angering the customer because they have already been contacted once. at that target 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 immune carriers establish. 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