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

Advantages of Venture Capital

 1. Expansion of company - Venture capital provides large funding that a company needs to expand its business.It has the ability for company expansion that would not be possible through bank loans or other methods.

2. Expertise joining the company - VC provide valuable expertise , advice and industry.These experts have deep knowledge of specific market standards and they can help avoid business from many downsides that are usually associated with startups.

3. Better Management - Its not always that being an entrepreneur one is also a good business manager. However . since VC holds a percentage of equity in the business.

4. No obligation to repay - There is an obligation to repay to investors as it would be in case of bank loans. Investors take the investment risk on their own .

5. Value added services - VC provide HR consultant , who are specialist in hiring the best staff for your business .

Comments

Popular Posts