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

Exchange Rate

 Exchange Rate - when there is currency appreciation , it has more buying power in relation to another specific country .

When there is currency depreciation , it has less buying power in relation to other specific currency. 

What is devaluation?

Devaluation is deliberately bringing down the value of currency when compared to other country currencies . When the value of currency is brought down , exports receive a boost and imports get discouraged , it helps in reducing the trade deficit .

Types of Exchange Rates 

1. Fixed Exchange Rates - A currency value is being linked to another by an agreed upon exchange rate . It aims to keep the value of currencies stable .

2.Floating Exchange Rate- Exchange Rate of a company is determined through market demand and supply .

3.Managed Float - It is a combination of Fixed and Floating exchange rate system where a government intervene to change the exchange rates to avoid persistent payment deficits and surpluses.

Change in foreign currency will affect the cost of importing their goods .

If their foreign currency is down relative to the currency of the importing country , it will make their currency and their products cheaper for the importing country.

If the foreign currency is up relative to the importing country's currency , it will be more expensive to buy their currency and their products will be expensive for imports.


Comments

Post a Comment

Popular Posts