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

Methods of Venture Financing

1. Equity - Contribution does not exceed 49% of the total equity capital.

2. Quasi Equity - A form of finance that combines some of the benefits of equity and debt 

3. Conditional loan - It is repayable in the form of royalty after the venture is able to generate sales . 

4. Income Note - It is hybrid security which combines the features of both conventional loan and conditional loan .It has to pay both interest and royalty on sales , but at substantially low rates.

5. Other financing Methods - It is particularly in private sector , have started introducing innovative financial securities like participating debentures , introduced by TCFC is an example.


Comments

Popular Posts