Skip to main content

Featured

Constraints

NOT NULL CONSTRAINT -    Ensures that a column cannot have a null value. DEFAULT CONSTRAINT -    Provides a default value for a column when none is specified  UNIQUE CONSTRAINT -   Ensures that all values in columns are different  CHECK CONSTRAINT -   Makes sure that all values in a column satisfy certain criteria  PRIMARY KEY CONSTRAINT -   Used to uniquely identify a row in the table  FOREIGN KEY CONSTRAINT -   Used to ensure referential integrity of the data  Primary Key - is used uniquely to identify each row in a table . It can consist of one or more columns on a table . When Multiple columns are used on a table it is called composite key.  Foreign Key - Foreign key is a column or columns that references a column most often primary key of another table . The purpose of foreign key is to maintain referential integrity of the data. Pg admin  Data base - training - right click on training - query click  Always add semi colen to run the query  Int - integer  varchar - variable charact
Post a Comment
Read more
Labels

Customer service

Customer service - It is a series of activities designed to enhance the level of customer satisfaction ie the product or service has met customer expectation . It is direct result of superior logistical performances.

Logistic and customer service meeting is reaching the product to customer at right time without any defectiveness , right person, right time and right place then you can supply your customer demand on time.

If 2 customer on same floor and shift from one to another , then they will shift between 2 , there is no such complaint about logistic people . They patiently wait or in case you don't have money , they wait .

Customer service objectives - 

1. Enhance customer satisfaction 

2. Ensure perfect order 

3. Retain customers 

4. Improve sales 

5. Improve reputation 

6. Improve market position 

7. Improve customer loyalty 

8. Meet customer expectation 

9. Resolves complaints 


Elements of Customer service -

Pre Transaction - It is about having defined customer service policy at organisational level , once decided , pre transaction also about informing customer , rather than keeping it dark.

Organisational structure is about authority , responsibility and training.

System flexibility can you change customer policy according to requirements and environmental conditions.

During transaction - product availability - right place , right time product available 

Sharing order status -- during transaction in case of online purchase.

Consistency in order cycle - -In case of B2B sales they are using your finished product as raw material to them so , ensure consistency is maintained in delivering .

Substitute Products - Used in B2B , is about flexibility , how raw material need to manufacture , when no vendor has it ,in that situation , can you shift to substitute product available to ensure consistency .

Post transaction - after sale service -- toll free number etc

Product trace is after sale , when sent product for technical solution , and customer can track.

Customer grievances redressal -- Complaints resolve , emails etc 

Product Loaning -- If you sent your original product for technical solution , those days you will not have you original product , If you talk about high end car , then this person will left with no car but will have substitute , in those cases , the company can offer substitute product over here . 

Labels:

Comments

Post a Comment

Popular Posts