# CSC $565$ Database Management Systems

# Module $2$ Assignment $2$ Basic SQL DDL and modification

# for this assignment, use the database named by your username

# use xliu;

#$1.$ Create a department table

#$2.$ Create an instructor table

#$3.$ Populate each table with $3$ records. You can make up your data.

#$4.$ Write a SQL command to give a $5\%$ salary raise to instructors in a specific department you pick.

#$5.$ Write a SQL command to give a $5\%$ salary raise to instructors in the department that has the highest budget. $($hint: you may use sub queries for this problem$)$

#$6.$ Delete all instructors of a spcific department you choose;