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

Manufacturing Systems

 Manufacturing systems 

1. Mass Manufacturing - It is manufacturing of the components at larger scale. Example - car , different parts are manufactured and later assembled in an assembly line .

No waiting 

limited WIP 

Highly automated 

Large output 

Cost per unit is reduced (economies of scale)

2.Assembly Line - 2 or more components are combined to manufacture a finished product .Each machine directly receives material from the previous machine and passes it directly to the next machine.

3.Process Production - it is carried in uniform and standardised form in the sequence of operations .

it has subtypes

Analytical production - single raw material break down in various finished product.

example crude oil , sugar etc.

Systematic Production -Mixing of 2 or more materials to form a finished product .

example - soap.


Comments

Post a Comment

Popular Posts