Sql quaries

Consider a database with the following tables: Employee (FName, LName, SSN, BDate, Salaray, HireDate) Department (DName, DNumber, nbrEmployees) DeptLocation(DNumber, DLocation) Q-1) Write SQL statements that do the following: a) Write the SQL statements required to create the above tables. You have to choose the best data type for each column, and all necessary keys (primary and foreign). [15 points] b) Create a trigger that fires when a new row of data is deleted from the Department Table. It then insert the deleted elements in a table called DepTemp (Suppose that this table is already created). [6 points] c) Create a view that contains DName and Dlocation of department with more than 50 employees [6 points] a) Create a Job that aims the automation of Creation of DemoScript backup. The backup will be in backup set C:\yourname.bak". You need to schedule as follow: [9 points] i. Weekly Full-Back up on each Sunday ii. Then each 2 days a Daily Differential Backup iii. Transaction log should be backed up every 2 hours