1.) Create a functio n to implement the following requirements: Retrieve the ins
ID: 3599707 • Letter: 1
Question
1.) Create a function to implement the following requirements:
Retrieve the instructor’s name who teaches a given course.
Function name: Course_Instructor
Input parameter: course_name
Return: Instructor name
When you populate the database, insert data such that the function can return an instructor name.
2.) A stored procedure to output the names of the TAs for a given instructor. The instructor can teach multiple courses, so retrieve the TAs for all his/her courses.
Name of the procedure: Get_TA
Input parameter: instructor ID.
Output: print TAs’ names
3.) A stored procedure to output all the students enrolled in a given course. (use select statement, as shown in the examples of MySQL procedure slides)
Name of the procedure: GetStudentCourse
Input parameter: Course Number
output : Print SSN, Student_Name, Address and Email_ID (use select statement, as shown in the examples of MySQL procedure slides)
RE GISTRAR SSN Student NamAddress Email ID STUDENT SSN SalyTEACHING ASSISTANT SSN CourseNo GradeENROLLED CourseNo Course_Name N No of Students Instructor ID Re TA ID COCRSE Tide Instructor ID Instructor_Name INS TRUCTOR CourseNoURL WEB BASED COURSE CourseNoRoom_No_Ref building_RefClass_time NON WEB BASED COURSE Building loor CLASS ROOM Figure 1. Relational SchemaExplanation / Answer
package com;
public class ArraySortedPolynomial implements PolynomialInterface
{
ArraySortedPolynomial()
{
}
ArraySortedPolynomial(String pol)
{
}
@Override
public PolynomialInterface add(PolynomialInterface other) {
// TODO Auto-generated method stub
return null;
}
@Override
public PolynomialInterface subtract(PolynomialInterface other) {
// TODO Auto-generated method stub
return null;
}
}
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.