Oracle Assignment Solution

PART-II: MCS-043
Question 1:
(a) Create an appropriate database using Oracle for a study centre management system. (Perform Normalization till the required levels)
(10 Marks)
(b) Perform following queries using SQL:
(5 Marks)
(i) Find the name of the programmes those are been activated in the given study centre.
(ii) Find the no of students in BCA programme for the current year.
(iii) Display the corresponding Regional Centre Code if the study centre code is given.
(iv) Display the list of all the academic counsellors of MCA programme.
(v) Display the total no. of assignments received in the current session for the MCSL-045 course.
(c) Write appropriate triggers, exceptions and functions for the above study centre management system database schema and describe them briefly.
(5 marks)