Database Design of customer management system and database of Customer Management System

Database Design of customer management system and database of Customer Management System

The Database Design of the customer management system is developed using the SQL Server 2008 database. The customer management system (Customermanagement) contains a total of seven tables, which are described as follows:

1. Store the manager table of the Administrator account and password

 

The manager table for storing the Administrator account and password is as follows:

 

2. customer table for storing customer data

 

Customer table document for storing customer data

 

Iii. inform table for storing complaint information

 

Inform table document storing complaint information

 

4. Store service servers tables

 

Store service servers table documents

 

5. nation table for storing the name family information

 

Nation table document for storing the name family information

 

6. List of province information stored in the province table

 

Province table document for saving province Information

 

7. city table for storing city information

 

City table document for storing city information

 

After the CustomerManagement database is created and seven data tables are created, a relatively complete database will appear: