Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
nt database. The primary keys are highlighted in bold. Student (studNo, studName, address, mobileNo) Registration (studNo, courseNo, regDate, semester, session) Course (courseNo, courseNam

nt database. The primary keys are highlighted in bold. Student (studNo, studName, address, mobileNo) Registration (studNo, courseNo, regDate, semester, session) Course (courseNo, courseNam

Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter8: Working With Advanced Functions
Section: Chapter Questions
Problem 2.9CP
See similar textbooks
icon
Related questions
Question

Below is part of a Student database. The primary keys are highlighted in bold.

Student (studNo, studName, address, mobileNo)

Registration (studNo, courseNo, regDate, semester, session)

Course (courseNo, courseName, creditHour, level)

Project (projNo, projName, courseNo)

 

QUESTION :  

1. Write a PL/SQL PROCEDURE that will list the project names given the course ID.

 

2.  Call the procedure from an anonymous block. Allow the user to enter the course ID (courseno)

Expected output: Enter the course number: 1100 The project(s) for PROGRAMMING course are as follows: 1. Tic Tac Toe 2. Word Generator PL/SQL procedure successfully completed. or Enter the course number: 1103 The project(s) for DATABASE course are as follows: 1. eZakat PL/SQL procedure successfully completed. or Enter the course number: 1707 The project(s) for MATHEMATICS course are as follows: 1. Stochastic BioNet 2. Ensemble Kalman Filter PL/SQL procedure successfully completed.
Transcribed Image Text:Expected output: Enter the course number: 1100 The project(s) for PROGRAMMING course are as follows: 1. Tic Tac Toe 2. Word Generator PL/SQL procedure successfully completed. or Enter the course number: 1103 The project(s) for DATABASE course are as follows: 1. eZakat PL/SQL procedure successfully completed. or Enter the course number: 1707 The project(s) for MATHEMATICS course are as follows: 1. Stochastic BioNet 2. Ensemble Kalman Filter PL/SQL procedure successfully completed.
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Table
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
MIS
MIS
Computer Science
ISBN:
9781337681919
Author:
BIDGOLI
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
SEE MORE TEXTBOOKS