I. Write the SQL statements to create database objects. la. Create a table with the details shown below: [2.5 Marks ] Table-Name: Doctors_Student_id [Example Doctors_123124] \begin{tabular}{|1|1|1|} Thline \multicolumn{1}{]c[}{ Column Name } & \multicolumn{1}{|c|}{ Data Type } & \multicolumn{1}{[c]}{ Constraint (Column Level) } \hline DoctorID & Number(4) & Should not be empty and not repeated Thline DoctorName & Varchar2(25) & \hline Salary & Number (6) & Should be more than or equal to 5000 \hline \end{tabular lb. When do we use Column-level and Table-level constraints? Explain with example each. [0.5 Mark] 1c. Enter any two (2) records into the Doctors table. [0.5 Mark] 1d. Modify the Doctors table by applying the following constraints: [1.5 Marks] \begin{tabular}{|1|1|} \hline Column Name & Constraint \hline Salary & Delete the constraint Thline Doctor Name & Should not be empty W \hline \end{tabular) 2a. Create a view "View_Dept 6090 " which will display columns EmpNo, EName and Salary, by selecting the employee_id, First_Name and salary from Employees table, whose department_id is either 60 or 90 or the First_name contains letter 'a'. Assign or set a constraint to control the access of data, by ensuring that modifications (DMLoperations) are not allowed. [4.5 Marks] $2 b$. Explain the purpose of creating views in your own words. [0.5 Mark] CS.VS. 1001