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

Securitisation Stages

 1. Identification Stage - There is bank which is in lending process . few entities are only allowed for securitisation , example - 500 CR lending process is there in bank , where there is still many borrowers who need loan , Now if bank does not have enough cash to give loan to those borrowers it will go for securitisation and will identify the type of asset like is it vehicle loan , personal loan or home loan and accordingly start . They basically make tranches . 

Tranches are when there are different variety, similar categories  are grouped .

2. Transfer Stage - In transfer stage the illiquid asset will transfer from bank to SPV and will then SPV will convert it into liquid asset in the form of bond.

3. Issue Stage - Here issue of security by the investors takes place in the form of bond .

4. Redemption - Here nothing but redeemed( investment is repurchased or bought back by the issuer or the company that originally issued it.)

5. Credit Rating - Bonds are made attractive to investors , and therefore rated .

Labels:

Comments

Post a Comment

Popular Posts