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

Colour Psychology

 RED - It represents EXCITEMENT , LOVE , POWER , ENERGY , DANGER , ANGER And AGGRESSION 

YELLOW - It represents OPTIMISM , CREATIVITY , HAPPINESS And FRIENDLINESS. Example - Mc Donalds .

GREEN - It is a dominating Colour which represents HEALTH , FRESHNESS , GROWTH , Especially used for Eco - friendly Product . 

ORANGE - It represents SENSE OF WARMTH , INVITING , SUCCESS And CONFIDENCE .

BLUE - It represents CALMNESS , TRUST And PEACE .  For some people it can be a sign of SADNESS And DEPRESSION. It is used by a company called HDFC Bank for trust and Also by Hospitals . By far it most preferred colour for both men and women. 

VIOLET - It represents ROYALTY , CREATIVITY And WEALTH . It is mostly favourite of female users and it provides a sense of creativity .

PINK - It represents COMPASSION , POSITIVITY And GENDER - NEUTRAL . While pink used for Feminine users for  years but it can be Gender neutral as well  but make sure to think twice for a wood working website . 

BROWN - It represents NATURE , COZINESS , DULL , DIRTY . We must check different shades of brown before applying it to your design because a light brown can be clean but a darker shade could look dirty . 

BLACK - It represents ELEGANCE , LUXURY , And SOPHISTICATION , We must use it properly as it can provide SORROW And SADNESS . Commonly it is used in text but you can use as background but make sure to use vibrant colours at foreground . 

WHITE - It represents CLEANLINESS , SIMPLICITY And MINIMALISTIC . Use White a lot to make a minimalistic website . You must have heard of the term White Space , which means leaving some space empty so that the user does not feel overwhelmed . 



 

Comments

Post a Comment

Popular Posts