Question: complete the blank corresponding to this code, not a new one STUDENT (sid, firstname, lastname, copa, contactno) ENROLLMENT(sid, cid) COURSE(cid, name, code, type, credit) SECTION(stid,
STUDENT (sid, firstname, lastname, copa, contactno) ENROLLMENT(sid, cid) COURSE(cid, name, code, type, credit) SECTION(stid, classroom day, capacity, cid) By using the given diagram above, a function is defined to count the number of courses in the given classroom like given below. CREATE FUNCTION GET COURSE_COUNT O CLASSROOM IN VARCHAR2) RETURN NUMBER 15 CURSOR COUNTCUR IS SELECT CCID FROM COURSE CSECTIONS WHERE CCIDES.CID AND CLASSROOM = | CLASSROOM V COUNT NUMBER BEGIN END; Complete this function to return the count of number of courses for a given classroom (Note that line numbers may differ. This is just a visualization. Also, you are free to choose different type of alternatives. No need to write the whole function)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
