DATABASE: SQL Data Manipulation Language (DML) : Insert, Update & Delete Statements

What are the Command to insert, update and delete data within the database tables please explain?

 

Transcribed Image Text:

Table Student Attribute Content Data Type Nullable Default Unique Check Constraint FK Referenced Table Stud_ID (PK) Stud_Name Student's id Student's name CHAR (10) No VARCHAR No (50) Stud Gender Student's gender CHAR(1) No Stud_IC Stud Faculty Student's IC Student's faculty CHAR(14) VARCHAR 22 No No (10) Stud_Session Stud Year Stud_PhoneNo Student's session CHAR (9) No Student's year CHAR(2) No Student's contact CHAR (10) No Stud_Email number Student's email VARCHAR No Yes (30) Stud_Address Student's house address VARCHAR NO No (50) RoomID (FK) HostelID (FK) CheckIn Date Checkout_Date Student's room id Hostel that student lived Student's register date Student's check out hostel date CHAR(7) Yes CHAR(4) Yes DATE No DATE Yes NULL stud_gender_chk (Stud Gender 'F' OR == Stud Gender 'M) RoomID HostelID Table Student Attribute Content Data Type Nullable Default Unique Check Constraint FK Referenced Table Stud_ID (PK) Stud_Name Student's id Student's name CHAR (10) No VARCHAR No (50) Stud Gender Student's gender CHAR(1) No Stud_IC Stud Faculty Student's IC Student's faculty CHAR(14) VARCHAR 22 No No (10) Stud_Session Stud Year Stud_PhoneNo Student's session CHAR (9) No Student's year CHAR(2) No Student's contact CHAR (10) No Stud_Email number Student's email VARCHAR No Yes (30) Stud_Address Student's house address VARCHAR NO No (50) RoomID (FK) HostelID (FK) CheckIn Date Checkout_Date Student's room id Hostel that student lived Student's register date Student's check out hostel date CHAR(7) Yes CHAR(4) Yes DATE No DATE Yes NULL stud_gender_chk (Stud Gender 'F' OR == Stud Gender 'M) RoomID HostelID