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

Data base design for a museum information system, In this practical assignm...

In this practical assignment, we will run through a complete database application development cycle, starting with the schema design, from an initial data import to database applic

Define what Immediate database modification technique uses, Define what Imm...

Define what Immediate database modification technique uses?  Ans: Both undo and redo.

Synonyms, Synonyms It allows short names or alternative names for objects....

Synonyms It allows short names or alternative names for objects. Example :               CREATE SYNONYM D30               FOR EMPD30;   Now if we give command:

xml, basic structure of xm

basic structure of xml

What is object containment, What is object containment? References amon...

What is object containment? References among objects can be used to model dissimilar real-world concepts.

Explain the object-oriented decomposition, Explain the Object-oriented deco...

Explain the Object-oriented decomposition Object-oriented decomposition targets at identifying individual sovereign objects that encapsulate both a state and certain behavio

Speedup query processing, Speedup Query Processing: A query that includes d...

Speedup Query Processing: A query that includes data at various sites can be split into sub-queries. These sub- queries can be implemented in parallel by various sites. Such parall

Functional dependencies and normalization for relational dat, Consider the ...

Consider the 1ollowin8 relation: CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., crui

Relational algebraic operators, Problem Explain at least five relationa...

Problem Explain at least five relational algebraic operators with a suitable example. Note: All the above descriptions should be done by taking at least two examples from ou

Explain what is aggregation, Explain what is Aggregation? Aggregation:...

Explain what is Aggregation? Aggregation: Aggregation is an significant concept in database design whereas composite objects could be modelled during the design of database a

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