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

Non - Tariff Barriers

There are certain barriers to protect domestic company , FOREX and Balance of Payment crisis .

There are 2 Types of Policies - 

->Free - Trade Policy = It is a policy with less restriction 

->Protection Policy = There is some restriction 

All country follows both types of policies .

It is because domestic companies are not that much competitive in the global market so countries create restrictions on trade of foreign country to ensure that domestic companies get chance and be competitive enough for the global market . Although these practices are not approved by WTO (World Trade Organisation).

80% Trade restrictions towards Non - Tariff Barrier .

Non-tariff barriers (NTBs) are a form of trade barrier that do not involve the imposition of tariffs (import taxes) on goods and services but still hinder international trade. These barriers are put in place by governments or regulatory authorities to protect domestic industries, ensure safety standards, or address other concerns.

Example - The best example for the same would be US vs China trade war .

Do you know ? USA increased tariff on Chinese products which were imported in the country to protect local market from falling . As we know Chinese products are extremely cheap , therefore competitive in the market also.


Labels:

Comments

Post a Comment

Popular Posts