I need urgent solutin for the given assignment at college,I'm new learner therefore please help in this concern.I'll really appreciate you if you do any kind of help me in this concern
(a) Create an appropriate database using Oracle for a study centre management system. (Perform Normalization till the required levels)
(b) Perform following queries using SQL:
(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.
This is not a question! This is the assignment. And we don't do you work for you; and this is because we help people, really help, and having your work done by others is not really helpful.—SA
Our chances to learn something or get essential experience are somewhat limited, because we usually have a lot of other things to do, and just because our life is too short. Don't miss a chance!
Please stop posting your homework assignments, do some work and if you get stuck ask specific questions.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)