Question-3 Database management system has become part of many organizations, and this is supported by the article: "Database management systems has become a part of every field right from schools, libraries, medical centres, airlines, chemical plants etcetera". MySQL is example of DBMS which present SQL language to let you access and manipulate databases. Apply your SQL skillset to: STAFF TABLE: Staff No 101 102 103 Payslip Number sName 1011 Kylen 1021 Kim 1031 Jane Employment Date 2001/05/01 2001/05/02 2001/05/03 Salary 2000 4000 3000 3.1 Compare DDL and DML. 3.2 Formulate SQL statements to create a new Table called "TEMP_STAFF" which contains exact same information as "STAFF" table above and specify "Staff No" as Primary Key. 3.3 Formulate SQL statement to retrieve all records for staff members earning at least R4000. 3.4 Formulate SQL code to change the column Employment Date to Start Date. 3.5 Determine SQL key word(s) that enforces referential integrity & use an example to illustrate.

Question-3 Database management system has become part of many organizations, and this is supported by the article: "Database management systems has become a part of every field right from schools, libraries, medical centres, airlines, chemical plants etcetera". MySQL is example of DBMS which present SQL language to let you access and manipulate databases. Apply your SQL skillset to: STAFF TABLE: Staff No 101 102 103 Payslip Number sName 1011 Kylen 1021 Kim 1031 Jane Employment Date 2001/05/01 2001/05/02 2001/05/03 Salary 2000 4000 3000 3.1 Compare DDL and DML. 3.2 Formulate SQL statements to create a new Table called "TEMP_STAFF" which contains exact same information as "STAFF" table above and specify "Staff No" as Primary Key. 3.3 Formulate SQL statement to retrieve all records for staff members earning at least R4000. 3.4 Formulate SQL code to change the column Employment Date to Start Date. 3.5 Determine SQL key word(s) that enforces referential integrity & use an example to illustrate.