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

Coursework, ERD Diagram of Medical Recruitment Agency?

ERD Diagram of Medical Recruitment Agency?

Remove partial dependancy, , write the relational schema, and draw the new ...

, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created

What is the use of with clause in sql, What is the use of with clause in SQ...

What is the use of with clause in SQL? The with clause gives a way of defining a temporary view whose explanation is available only to the query in which the with clause occurs

Oracle, how oracle can be used

how oracle can be used

HYRISE, how to implement hyrise in C plus plus

how to implement hyrise in C plus plus

What are called index-sequential files, What are called index-sequential fi...

What are called index-sequential files? The files that are ordered sequentially with a primary index on the search key are known as index-sequential files

Extended star schema, Why did SAP introduce the extended star schema? Expla...

Why did SAP introduce the extended star schema? Explain why it is reported to be better than the traditional schema model?

What do you understand by a view, What do you understand by a view? What do...

What do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is

What is known as sequential file organization, What is known as sequential ...

What is known as sequential file organization? In the sequential file organization, the records are kept in sequential order, according to the value of a "search key" of every

Textbook ordering system, Question: Consider the following database rel...

Question: Consider the following database relations for a textbook ordering system used by a college bookshop: Book (b-copy#, bname, ISBN#, author, price, subject) Order (s#

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