The Insert Command

U1: Add a new tuple to the EMPLOYEE relation.

 
U1: 		 INSERT INTO  		 EMPLOYEE

		 VALUES 		 (`Richard',`K',`Marini',653298653',
`30-DEC-52','98 Oak

		 		 Forest,Katy,TX',`M',37000,`987654321',4)

U1A: Attributes not specified are set to NULL.

 
U1A: 		 INSERT INTO  		 EMPLOYEE(FNAME,LNAME,SSN)

		 VALUES 		 (`Richard',`K',`Marini',653298653')

• Referential Integrity Not Enforced
• Multiple Tuples in Insert