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

Product Management

 Production management it focuses on the product but it can apply to services as well. It should also give proper attention . The production is not something important it works on various factor like product design , system and especially workforce , they should be happy , motivated and contented with work environment .

Function of Product management 

1. Selection of product and design 

2. Selection of production process 

3.Selection of right production capacity.

4.Production planning 

5.Production control

6.Quality and cost control

7.Inventory control

8.Maintenance replacement of machine 


Efficiency basic definition is output upon input .

Effectiveness is basically hitting the point on target . if you can achieve again and again .Getting the right target each and every time.



Comments

Post a Comment

Popular Posts