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

Reverse Logistics

Reverse Logistics - It is the process of moving the product from its point of consumption to its point of origin. It involves flow from customer to the company .

Reversing the entire logistics process. It is no more manufacture to customer , its from customer to origin.

What are the reasons in which reverse logistics takes place in the company ?

-Return of Product 

-Defects of Product 

-Exchange of Product 


Scope of Reverse logistics -

1. Return of unsold goods - There a lot of times supplier will take back the unsold goods on some conditions or it can go to different market .

2. Refusal of product - When product is refused by customer 

3. Refilling and reusable packaging -Refill packaging , sanitise the bottle and refill the bottle 

4. Product recalls - If there is manufacturing defect 

5. Reverse logistics for demonstration - If there is any exhibition then there is reverse logistics , this is very rare but this can happen.

6. Waste disposal procedure - electronic or medical , They call back product , they often tell you drop your electronic product here , there is some sort of reverse logistics.


Labels:

Comments

Post a Comment

Popular Posts