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

Regional Trade Blocks - ASEAN

ASEAN
  •   It is a group of 10 countries . 
  • Association of South east Asian Countries . 
  • It has common market where cross border investment and movement of factors of production is there 
  • It does not have common monetary policies 
  • On 8th August 1967 by signing declaration in Bangkok , Thailand .
  • Cambodia was the last country to join 
Why formed ASEAN ?
  • Countries were having geographical issues 
  • Therefore 10 countries come up to promote Stability and Peace 
  • There were Cultural differences also which is resolved by ASEAN 
    ASEAN comes at 6th Number after USA , China in case of Global Trade.
    ASEAN helps in enhancing regional economic corporation which helps doing                      better investments in and out .
    ASEAN was formed to strengthen Socio-Cultural Integration and protect rights and welfare of people 


3 Types of Community -
-Political Security - Live in peace with democracy and harmony environment 
-Economic Security - It promotes free flow of goods and services (Labour)
-Socio-Cultural Community - On 22nd November 2015 , it came up draft of community and promote high quality life , Equitable quality and Environmental protection 

After every 2 years , 10 Countries come together to discuss on Issues .

Labels:

Comments

Post a Comment

Popular Posts