Below is part of a student database for your reference. The primary keys are highlighted in bold. Student (studNo, studlvame, address, mobileNo) Registration (studNo, courseNo, regDate, semester, session) Course (courseNo, courseName, creditHour, level) Project (projNo, projName, courseNo) Assignment (projNo, studNo, startDate, dueDate hours Spent) Fill the empty lines (Line 10, 12, 22, 23, 27) with the appropriate PL/SQL code so as to complete the following anonymous block. The anonymous block displays the list of courses taken by a certain student. Allow the user to enter the STUDENT NAME: 1. ACCEPT studname PROMPT 'Enter the student name:' 2. 3. DECLARE 4. v_cid course.courseno%TYPE; 5. V_sname student.studname%TYPE:= '&studname; 6. V_cname course.coursename%TYPE; 7. 8. CURSOR course_list IS 9. SELECT c.courseno, c.coursename 10. 11. WHERE s.studno = r.studno 12. 13. AND studname = V_sname; 14. 15. BEGIN 16. 17. OPEN course_list; 18. 19. DBMS_OUTPUT.PUT_LINE(List of courses for 'lv_sname); 20. 21. LOOP 22. 23. 24. DBMS_OUTPUT.PUT_LINE(v_cid| lv_cname); 25. 26. END LOOP; 27. 28. 29. END; 30.

Below is part of a student database for your reference. The primary keys are highlighted in bold. Student (studNo, studlvame, address, mobileNo) Registration (studNo, courseNo, regDate, semester, session) Course (courseNo, courseName, creditHour, level) Project (projNo, projName, courseNo) Assignment (projNo, studNo, startDate, dueDate hours Spent) Fill the empty lines (Line 10, 12, 22, 23, 27) with the appropriate PL/SQL code so as to complete the following anonymous block. The anonymous block displays the list of courses taken by a certain student. Allow the user to enter the STUDENT NAME: 1. ACCEPT studname PROMPT 'Enter the student name:' 2. 3. DECLARE 4. v_cid course.courseno%TYPE; 5. V_sname student.studname%TYPE:= '&studname; 6. V_cname course.coursename%TYPE; 7. 8. CURSOR course_list IS 9. SELECT c.courseno, c.coursename 10. 11. WHERE s.studno = r.studno 12. 13. AND studname = V_sname; 14. 15. BEGIN 16. 17. OPEN course_list; 18. 19. DBMS_OUTPUT.PUT_LINE(List of courses for 'lv_sname); 20. 21. LOOP 22. 23. 24. DBMS_OUTPUT.PUT_LINE(v_cid| lv_cname); 25. 26. END LOOP; 27. 28. 29. END; 30.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: FX program Create a JavaFX GUI that allows the user to retrieve records from the product table…

A: It is defined as a Java library used to build Rich Internet Applications. The applications written…

Q: ovide a scenario in which a role is assigned to another role to fulfill a specific need in a…

A: The privilege lets a consumer create or get entry to database sources and privileges are stored…

Q: assume that a database has a table named Stock, with thefollowing columns:Column Name…

A: Select statement is used for selecting data from the database. Syntax: SELECT column1, column2,…

Q: Using the om database: Write a statement that displays these fields: customer’s first name…

A: Let's first understand JOIN :- JOIN IN SQL:- Join combines the records from two tables It…

Q: True or False: Referential integrity constraints ensure the values of a primary key are valid based…

A: Referential integrity constraints in a relational database ensure that the relationships between…

Q: The file that contains information about the tables, fields, records, and properties included in the…

A: The full form of XSD is an extended schema description. The XSD extension file format file is used…

Q: Holiday Travel Vehicles sells new recreational vehicles and travel trailers. When new vehicles…

A: Step 1:Based on the scenario provided, we can identify the following classes along with their…

Question

100%

Below is part of a student database for your reference. The primary keys are highlighted in bold.
Student (studNo, studlvame, address, mobileNo)
Registration (studNo, courseNo, regDate, semester, session)
Course (courseNo, courseName, creditHour, level)
Project (projNo, projName, courseNo)
Assignment (projNo, studNo, startDate, dueDate, hoursSpent)
Fill the empty lines (Line 10, 12, 22, 23, 27) with the appropriate PL/SQL code so as to complete the following anonymous block. The anonymous block displays the
list of courses taken by a certain student. Allow the user to enter the STUDENT NAME:
1.
ACCEPT studname PROMPT 'Enter the student name:'
2.
3.
DECLARE
4.
v_cid
course.courseno%TYPE;
5.
V_sname
student.studname%TYPE:= '&studname;
6.
V_cname
course.coursename%TYPE;
7.
8.
CURSOR course_list IS
9.
SELECT c.courseno, c.coursename
10.
11.
WHERE s.studno = r.studno
12.
13.
AND studname = V_sname;
14.
15.
BEGIN
16.
17.
OPEN course_list;
18.
19.
DBMS_OUTPUT.PUT_LINE(List of courses for 'llv_sname);
20.
21.
LOOP
22.
23.
24.
DBMS_OUTPUT.PUT_LINE(v_cid| 'lv_cname);
25.
26.
END LOOP;
27.
28.
29.
END;
30.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

An index may speed up queries, but it's usually a terrible idea to create an index for every property or combination of properties that might be used as search keys. I'd want to know more about this.
Create a formula that provides the start date of a project as follows: In cell H4, begin to enter a formula using the INDEX Use the Lookup table (range A2:E23) as the array. For the row_num argument, use the MATCH Use the Project ID (cell H2) as the lookup_value for the MATCH function. Use the ID column (range A2:A23) as the lookup_array for the MATCH function. Specify an exact match (0) for the MATCH function. Use the Start Date column (column 4) as the column_num for the INDEX function.
price = 9 num= 2 total = Select the most appropriate replacement field definitions. = num * price print(' {2} tacos at $ {2} 2 tacos at $9 each costs $18. each costs ✓ Select.format(total, price, num)) {3} {1} {0} {2}
JavaFX program Create a JavaFX GUI that allows the user to retrieve records from the product table in the example database. The GUI should allow the user to specify desired fields, desired order, and a where condition. Display only the desired fields in the desired order for the desired where condition.You may display the records in the GUI in any way you wish. database below
What kind of connection does each key have with its respective data type?
Based on the ERD below, display the first name, last name and employee initial of anyone whose first name starts with “A”. (Hint: You will use a “Like” phrase.)
How many different fields should a single form that asks for information include, and what are some of the reasons why those fields should be included?