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

Merchant Banking

 Merchant bakers , lead managers and registrars play a key role and facilitate primary market activities by their advice and guidance.

Services Provided by Merchant Banker -

1. Project Counselling - Study on project is feasible or not 

2. Market survey and forecasting - The company gets a band which is range of amount , it is decided by merchant banker .

3. Estimating the amount of funds required - When i want IPO , there is written which is decided by merchant banker 

4. OTC 

5. Lease Financing 

6. Loans syndication - When we have big loan , they will distribute that loan .

7. Securitisation 

8.Raising funds from capital market 

9. Mergers and amalgamation 

10. Factoring 

Labels:

Comments

Post a Comment

Popular Posts