DUET PG Score Card 2021
NHAI Recruitment 2021
Bihar Board 12th Dummy Admit Card 2022
RBI Assistant Notification 2021
Jee Advanced 2021 Result
NIACL Assistant Recruitment 2021
SBI PO Online Form 2021

Create a PL/SQL Block Which Will Get Registration Number As Input From the User and Will Display the Name of Dept To Which Student Belongs

Create a PL/SQL Block Which Will Get Registration Number As Input From the User and Will Display the Name of Dept To Which Student Belongs

Name of student table and Dept table must be followed by your registration number.
E.g. Reg_no: 11202377;

Student Table Name: student11202377

Dept Table Name: dept11202377

Create a PL/SQL Block

Step1. Create a Student Table with following attributes:
reg_no (Primary key)
name (Not null)
dept_id
age (Not null)
fees

Step2. Create another Dept Table with following attributes:

Dept_id (Foreign Key referencing to Student(dept_id)
Dept_name(Not Null)
Dept_block(Not Null).
Dept_head

Step3. Create another table which is basically designed to record total fees of student;

Table Name: s_fee11202377 (in your case you have to put your
registration number after the table name)
Attributes of s_fees are:
reg_no, name and total fee;
Condition of total fee:
Total fee= studentfee + examination fee;
Examination fee=4000 if dept=’CSE’
Else Examination fee=2000;

Note: this trigger must be reactive to delete, update and insert statement that executed in the student table;

Sample Data

Step4: Insert data in both the tables as given below:

Create A Pl/Sql Block Which Will Get Registration Number As Input From The User And Will Display The Name Of Dept To Which Student Belongs
Create a Student Table with following attributes
Create A Pl/Sql Block Which Will Get Registration Number As Input From The User And Will Display The Name Of Dept To Which Student Belongs
Create another Dept Table with following attributes

Step5: create a pl/sql block which will get registration number as input from the user and will display the name of dept to which student belongs.

Create a PL/SQL Block Which Will Get Registration Number As Input From the User and Will Display the Name of Dept To Which Student Belongs

Solution:

upload soon.......

Practice: https://www.w3resource.com/mysql-exercises/subquery-exercises/write-a-query-to-display-the-employee-id-first-name-last-names-and-department-names-of-all-employees.php

Candidates having any kind of query so he/she can ask in our comment section. Our Panel will b reverting back as soon as possible. Thank You. For more details visit our website (https://speedjobalert.com/)

Leave a Comment