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

Procurement Price and Issue Price

1. Procurement Price - What price they actually buy it and give it to public distribution , if rice selling at 35 will be selling at 30 . 

This is because the poor people can also afford it .

Higher than the cost and less than Market price.

It will be more than MSP.

The price at which the government procures from the farmer for PDS (Public Distribution System)

2. Issue Price - is the price at which the government is selling . If procurement is 30 , the issue ( Government is buying at 30 ) is 28 it is because to serve the poor people.

The government is buying at 30 and selling at 28.

Difference between procurement and issue price is subsidy . The subsidy scheme the government offers. 

Issue price is 28 --- procurement is 30 ---- and market price is 35.

The main objective of government to serve the people and to fulfil the needs of the people . 


Comments

Post a Comment

Popular Posts