Question

Create the student database with the following tables and do the following: mark_details(reg_no,name, mark1, mark2, mark3, total) dept_details (dept_no, dept_name, HOD) stud_details(reg_no,name, dob, address) Using alter command to assign foreign key in mark_details. Display the address of the students who have secured the top three ranks. Write a PL/SQL procedure to update the grade according to the marks secured.

Answer 1

Answer:

Create the student database with the following tables and do the following: mark_details(reg_no,name, mark1, mark2, mark3, total) dept_details (dept_no, dept_name, HOD) stud_details(reg_no,name, dob, address) Using alter command to assign foreign key in mark_details. Display the address of the students who have secured the top three ranks. Write a PL/SQL procedure to update the grade according to the marks secured.

Answer 2

Explanation:

plz send a answer for this question