Need customer management program, Database Management System

Assignment Help:

Project Description:

This is a Customer Management project. Customer data is presented in a text file. The program can load this text data into its database columns. The data mapping is user definable. User will also define a process to run on the data just before loading into database. Process will be as simple as converting the text to lowercase, uppercase and so on or more complex such as covert code into text e.g 01 becomes Mr, 02 becomes Ms and so on.

After load there is a deduplication. The user can select one or more data fields for the system to compare the contents. When the contents match according to a pre-defined percentage then the record is supposed a duplicate of each other. Duplicates are tagged as such and only the master record remains as valid.

Each record in the database is an individual. The ability to search and update records is a requirement.

Campaigns are run by defining a campaign and the criteria which will selects which customers will be selected. This can be tagged back to each customer record so that we know which customer previously in which campaign.

The preferred tools are SQL Server and VB.NET.

Skills required and .NET, SQL, Database Administration, Visual Basic


Related Discussions:- Need customer management program

Higher normal forms, Higher Normal Forms Is there more normal forms beyond...

Higher Normal Forms Is there more normal forms beyond BCNF? Yes, though, these normal forms are not based on the concept of functional dependence. More normalisation is needed if

Which are two ways that entities participate relationship, Which are the tw...

Which are the two ways in which entities can participate in a relationship? Total and partial are the two ways in which entities can participate in a relationship

A file manipulation command that extracts some records, A file manipulation...

A file manipulation command that extracts some of the records from a file is called ? A file manipulation command that extracts some of the records from a file is called SELECT

What are multiple inheritances, What are multiple inheritances? Multipl...

What are multiple inheritances? Multiple inheritances allow a class to inherit variables and methods from many super classes.

Defining internal classes and operations, Defining Internal Classes and Ope...

Defining Internal Classes and Operations When we enlarge algorithms, new classes can be added to the store intermediate results. A complex operation could be looked at, as a c

By which techniquestransaction processing is associated, By which technique...

By which techniquesTransaction processing is associated? Transaction processing is associated by producing detail, summary, or exception reports and recording a business activi

Datamodels, explain thee diffrent types of data models

explain thee diffrent types of data models

Create a new service-based database, In this assignment, you will create a ...

In this assignment, you will create a program that works with multiple tables. In this assignment, you will work with the factory and sales tables. 1. Create a new project nam

Vertical fragmentation, Vertical Fragmentation- Vertical fragmentation grou...

Vertical Fragmentation- Vertical fragmentation groups together only those attributes in a relation that are used jointly by various important transactions. A vertical fragment is d

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd