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

Advantages of Trade Barriers

 Advantages of Barriers 

1. Domestic Industry Protect - Protect from competition and price fluctuation. Restrictions or taxes on imported goods, increase price and demand will decrease .Quota limit (Restrict on quantity ). It will boost production of domestic .

2. Government getting Revenue - Country get maximum revenue from custom duty.

3. Balance Of Payment Position - Import decrease, FOREX decrease and outflow of Foreign currency is less. In 1991 same happened and Now in Srilanka is facing now . When Import is completely increasing , outflow is increasing . Therefore Restrictions are required to balance Balance Of Payment .

4. Conservation of Foreign Exchange - When import is less, it is reserved . RBI is custodian of FOREX reserves . If outflow of FOREX is less RBI will have enough exchange . Srilanka did not have foreign exchange to pay duty. There is conservation of such restriction is placed.

5. Promote Economic growth - Domestic production will increase which will boost GDP by increase in demand for domestic product. So by putting tariff barrier on imported product it can boost economy.

Labels:

Comments

Post a Comment

Popular Posts