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 - ...

Investment Environment

Investment- The basic thing is movement of funds .

- Movement of funds from surplus sector to deficit sector.
- Surplus sector is excess of funds and deficit sector is lower funds .

 - When a person has more money than he or she requires for current consumption , he or she can be a potential investor .

- You should maintain a particular from of pattern 
- It should start with beginning of month but not the end .
- Start your Journey with Blue chip companies 

 --Sacrifice today --gain later ---time horizon

-> Share , bonds and mutual funds are marketable investments 

-> PPF , NSC , LIC are Financial investment 

-> Property, plants and machinery and land is physical investment .

-> Make a portfolio in such a way that all 3 investment options must be there . 

# Characteristics of Investment 

-RETURN 

-RISK 

-LIQUIDITY 

-SAFETY 

-MARKETABILITY 



Comments

Popular Posts