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

Difference between Risk and Return

INTRODUCTION

 There can be many such risk but suddenly your workers go on strike that is such risk coming up , one of your employee may not be comfortable with any topic and you don’t care ,t hen it may create risk in future.

Audit reports happening and many times we see faults which is not creating severe impact by not removing risk.

Risk is really uncertain 

Difference between risk and Uncertainty 

Probability of losing and wining something worthy is risk     Uncertainty implies a situation        where                                                                                 the future events are not yet known

Risk can be measured                                       Uncertainty cannot be measured 

Risk Chances of outcome is known                   Uncertainty Outcome is not known                

Uncertainty is not Controlled                                      Risk is controllable 

Risk can be reduced                                             Uncertainty cannot be reduced 

Probability are assigned in risk                                Probability is not assigned 


Labels:

Comments

Post a Comment

Popular Posts