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

Supply Chain Management

 Supply chain Management -Is a relatable new term however replacing logistics with supply chain in real life . Supply chain management is more comprehensive term acting more like umbrella under which logistics, material handling ,transportation or oder processing come under.

EXAMPLE

Lets assume you want to cook or prepare make Biryani and just decide for lunch its 9:40am and you have other things to do and don't have time to go market .

What will you do ?

Whatever spices is required we ordered it and prepared and it was nice , what comes in your mind and you want your neighbour family to deliver them.  

What all steps comes into picture for delivering it within 2 km distance ?

Packaging the Biryani and you will go personally with some transportation and through the entire journey you are ensuring your item is not leaked . 

Here we are not seeing movement but trying to combine all the steps together to complete the order or deliver.

Meaning -It is a comprehensive system used to transfer goods and services from raw materials to final customers through a systematic flow of information and physical distribution of goods and services . It is network of persons , firms , facilities , activities and technologies used for production and sale of goods and services.

Labels:

Comments

Post a Comment

Popular Posts