Instructor(Instructor_Id, Instructor_Name, specialization, Address,#Department_Id) Department(Department_Id, Department_Name) Course(Course_code, Course_Title,Credit_hours,Contact_hours,#Department_Id) Teaching(#Instructor_Id, #Course_code) a) Express in SQL the following queries: i. Change to 6 the number of contact hours of the course which has thecode “ITDR2104”. ii. Add a new column named instructorLoad of type Number(2) to thetable instructor. iii. List the details of all the courses having a code that starts with“ITDR”. The output should be sorted in descending order by credithours. iv. Find the number of courses taught by the instructor whose name is“Ahmed”. v. List the names of all departments along with the number of coursesoffered by each department. vi. Find the titles of courses, which are taught by the instructor who isnamed “Ahmed”. b) Create a view named instructor_of_DBCourse to contain the details(Instructor_Name, specialization, Address, Department_Id) ofinstructors who teach the course having the code “ITDR2106”.
Instructor(Instructor_Id, Instructor_Name, specialization, Address,#Department_Id)
Department(Department_Id, Department_Name)
Course(Course_code, Course_Title,Credit_hours,Contact_hours,#Department_Id)
Teaching(#Instructor_Id, #Course_code)
a) Express in SQL the following queries:
i. Change to 6 the number of contact hours of the course which has thecode “ITDR2104”.
ii. Add a new column named instructorLoad of type Number(2) to thetable instructor.
iii. List the details of all the courses having a code that starts with“ITDR”. The output should be sorted in descending order by credithours.
iv. Find the number of courses taught by the instructor whose name is“Ahmed”.
v. List the names of all departments along with the number of coursesoffered by each department.
vi. Find the titles of courses, which are taught by the instructor who isnamed “Ahmed”.
b) Create a view named instructor_of_DBCourse to contain the details(Instructor_Name, specialization, Address, Department_Id) ofinstructors who teach the course having the code “ITDR2106”.
Step by step
Solved in 2 steps
