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)

推荐答案

Quote：

创建数据库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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！