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 Planning

Investment planning is if somebody is coming to you to invest so you suggest various investment .

A person should have a insurance in his or her portfolio. 

Tax planning there are various investments which gives you tax benefit like LIC .

If a client has taken loan that is also a tax benefit on interest.

We should include some investment which has tax benefit.

Asset allocation - the percentage of allotted investment is good as per the requirement of client.

Lets take an example

- There is a client of age 25 , young and does not have any liability. 

- Have 5 Lakh rs to invest 

- Searching of investment 

Which investment options you can suggest ?

->  Government securities/ bonds/ debt  100000

-> Real Estate Property 100000

-> Fno / Equities 200000

-> Cryptocurrency / commodity / currency 50000

-> Insurance and tax saving plans 50000

Comments

Popular Posts