Oracle Assignment Solution [英] Oracle Assignment Solution
问题描述
亲爱的所有人，
我需要紧急解决大学的任务，我是新学员因此请帮助解决这个问题。如果你有任何帮助，我将非常感谢你我担心这个问题
Dear All,
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
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)
推荐答案
这不是问题！这是作业。我们不会为你工作;这是因为我们帮助别人，真正帮助，让别人完成你的工作并不是真的有用。
我们学到东西或获得必要经验的机会有点有限，因为我们通常还有许多其他事情要做，而且仅仅因为我们的生命太短暂。不要错过任何机会！
-SA
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.
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!
—SA
请停止发布您的家庭作业，做一些工作，如果你遇到问题，请提出具体问题。
Please stop posting your homework assignments, do some work and if you get stuck ask specific questions.
创建数据库MCAAM;
使用MCAAM;
1 NF规范化：
创建表MCAAssignmentMangement（
Student_enrolment bigint，
Student_name varchar（100），
Student_marks int，
Assignment_id varchar（100），
Assignment_name varchar（100），
Assignment_code varchar（50），
Assignment_counsellor varchar（100），
学期int，
Counsellor_Evaluating int，
Counsellor_name varchar（100），
Studycenter_id int，
Studycenter_name varchar（100）
）;
select * from MCAAssignmentMangement;
2nd NF Normalization：
创建表MCAAssignmentDeti als（
Student_enrolment bigint，
Student_marks int，
Assignment_name varchar（100），
Assignment_code varchar（50 ），
Assignment_counsellor varchar（100），
Studycenter_id int，
Studycenter_name varchar（100）
）;
3Rd NF标准化：
创建表格AssignmentDetials（
Student_enrolment bigint，
Student_marks int，
Assignment_code varchar（50），
Assignment_counsellor varchar（100），
Studycenter_id int
）;
i）
SELECT COUNT（Assignment_code）
来自MCAAssignmentMangement的
WHERE Assignment_code> 0;
ii）
从MCAAssignmentMangement中选择Assignment_counsellor
其中Counsellor_Evaluating> 1;
iii）
从MCAAssignmentMangement中选择Student_enrolment，Student_name，其中Student_marks> 40和学期= 1;
iv）
从MCAAssignmentMangement中选择Student_enrolment，Student_name，其中Student_marks> = 90％AND Assgnemt_code = MCS011;
v）
SELECT COUNT（*）
来自MCAAssignmentMangement
WHERE Assignment_code = MCSL045;
Create database MCAAM;
Use MCAAM;
1 NF Normalization:
Create table MCAAssignmentMangement(
Student_enrolment bigint,
Student_name varchar(100),
Student_marks int,
Assignment_id varchar(100),
Assignment_name varchar(100),
Assignment_code varchar(50),
Assignment_counsellor varchar(100),
Semester int,
Counsellor_Evaluating int,
Counsellor_name varchar(100),
Studycenter_id int,
Studycenter_name varchar(100)
);
select * from MCAAssignmentMangement;
2nd NF Normalization:
Create Table MCAAssignmentDetials(
Student_enrolment bigint,
Student_marks int,
Assignment_name varchar(100),
Assignment_code varchar(50),
Assignment_counsellor varchar(100),
Studycenter_id int,
Studycenter_name varchar(100)
);
3Rd NF Normalization:
Create table AssignmentDetials(
Student_enrolment bigint,
Student_marks int,
Assignment_code varchar(50),
Assignment_counsellor varchar(100),
Studycenter_id int
);
i)
SELECT COUNT(Assignment_code)
FROM MCAAssignmentMangement
WHERE Assignment_code>0;
ii)
Select Assignment_counsellor from MCAAssignmentMangement
Where Counsellor_Evaluating>1;
iii)
Select Student_enrolment, Student_name from MCAAssignmentMangement where Student_marks > 40 AND Semester = 1;
iv)
Select Student_enrolment, Student_name from MCAAssignmentMangement where Student_marks >= 90% AND Assgnemt_code=MCS011;
v)
SELECT COUNT(*)
FROM MCAAssignmentMangement
WHERE Assignment_code = MCSL045;
这篇关于Oracle Assignment Solution的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
