• Create a new database and name it Ch07_your name such as Ch07_Chaker
 
• right click the new database node and create a new query, past the text in the file and execute it, tables will be created and records would be inserted.

• write the SQL code that will list all attributes for employee number 104 and 107, save it as Qry_pbm1_your name
 
• Write the SQL code to change the job code to 500 for the person whose employee number (EMP_NUM) is 101. Save the query as Qry_pbm2_your name
 
• Use design mode to add the attributes EMP_PCT and PROJ_NUM to the structure of EMP_1 table. The EMP_PCT is the bonus percentage to be paid to each employee. The new attribute characteristics are: EMP_PCT
• NUMBER(4,2) PROJ_NUM CHAR(3), save the design changes.
 
• Write the SQL code to change the EMP_PCT value to 4.5 for the person whose employee number (EMP_NUM) is 109. Save the code as Qry_Pbm4_your name
 
• Write the SQL code required to list all employees whose last names contains the letter n. Assume case sensitivity

in microsoft sql.