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

Risk in Corporate World

 The term Risk refers to uncertainty in an outcome. Risk increases your chances of loss and profit both. 

When there is more volatility ( unpredictability ) there will be an increase in uncertainty of an event.

Time is also the factor which affects the risk , the more time is there , the more risk will be there. 

Here is a list of a few types of risks -

1. Business Risk - This risk is related to less profit than expected or loss in the company .

2. Hazard Risk - This risk is related to disruption in workplace or natural hazard in an organisation.

3. Financial Risk - This risk is related to the cashflow which is earned by the company and not satisfying the shareholder , because the shareholder expects return from what they have invested , it may be because the firm carries debt.

4. Operational Risk - The risk association with day to day operations which affects the working of the business .

5. Strategic Risk - the risk related to affecting the strategic decisions of the company , from which the shareholder value is not maximised .Improper decision .

6. Legal Risk- The risk associated with legal or criminal topics which negatively impacts the company .

7. Compliance Risk - The risk related organisations meeting the rules and regulations set by government agencies.

8. Political Risk- The risk that is influenced by political decision which affect the profitability of organisation .

9. Inherent Risk - The risk which is in the business and cannot be controlled by the organisation .

10. Residual Risk - The risk left even after applying controls in the organisation.

Comments

Post a Comment

Popular Posts