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

Production Management Basics

 What are the objectives?

Production and quality manager , is how you manage the quality of services that you are giving to your customers.

Input ----- Process ----- Output

there will be multiple input which goes through process and create a output.

Input- can be facility , customer , suppliers, transport etc.
Process- includes work in progress , we manage the process flow, there is planning and scheduling .Making sure there is lesser wastage.
Output- Customer satisfaction , no negative environmental impact,Unit cost (reducing cost and increasing profitability)

In the process of making chapati there is some equipment used to make like burner there is input , a process is gone to make that chapati(other chapati in the slab waiting to be put in burner).Improving the process in such a way it increases the productivity -System Improvement 
Output will be making a perfect chapati and satisfying the hunger of the person (customer). 





Comments

Post a Comment

Popular Posts