Practical Question 2: Student Performance
Visualization
🔹 Step 1: Create Table
CREATE TABLE STUDENT_MARKS (
STUDENT_ID NUMBER,
STUDENT_NAME VARCHAR2(50),
COURSE VARCHAR2(50),
SUBJECT VARCHAR2(50),
MARKS NUMBER,
EXAM_DATE DATE
);
🔹 Step 2: Insert Sample Data
INSERT INTO STUDENT_MARKS VALUES (1,'Anu','BSc','Maths',85,TO_DATE('2025-01-
01','YYYY-MM-DD'));
INSERT INTO STUDENT_MARKS VALUES (2,'Ravi','BCA','CS',90,TO_DATE('2025-01-
02','YYYY-MM-DD'));
INSERT INTO STUDENT_MARKS VALUES
(3,'Priya','BCom','Accounts',75,TO_DATE('2025-01-03','YYYY-MM-DD'));
🔹 Step 3: Report Page
Create Interactive Report
Table: STUDENT_MARKS
🔹 Step 4: Charts
📊 Column Chart: Marks by Student
SELECT STUDENT_NAME, MARKS
FROM STUDENT_MARKS;
📌 Diagram:
Marks
|
| ███
| ███ ████
| ███ ████ ██
|___Anu Ravi Priya
📈 Line Chart: Marks Trend
SELECT EXAM_DATE, MARKS
FROM STUDENT_MARKS
ORDER BY EXAM_DATE;
📌 Diagram:
Marks
|
| *
| * *
| * *
|____________ Date
🔹 Step 5: Summary Cards
Highest Marks
SELECT MAX(MARKS) FROM STUDENT_MARKS;
Average Marks
SELECT AVG(MARKS) FROM STUDENT_MARKS;
📌 Diagram:
----------------------
| Highest: 95 |
----------------------
| Average: 78 |
----------------------
🔹 Step 6: Search / Filter
Add search bar
Filter query:
WHERE COURSE = :P1_COURSE
OR STUDENT_NAME = :P1_NAME;