I've included my code in the picture below. Best of luck.
Answer:
CREATE FUNCTION exam_eligible_students
RETURN NUMBER AS
num_students NUMBER(15);
BEGIN
SELECT COUNT(STUDENT_ID)
INTO num_students
FROM STUDENT_ATTENDANCE
WHERE ELIGIBILITY_FOR_EXAMS = 'Y';
RETURN (num_students);
END;
Explanation:
exam_eligible_students is a made of name for the FUNCTION to be called.
num_students is a made up name for the RETURN to be called. The RETURN name is referenced in the INTO statement and as the name of the the return in the RETURN line in ().
Answer:
Different business or firm tend to enforce different Information Systems based completely on their main business operations, in order to best leverage data as an organizations asset. Some of these Information System are as follow:
a) Transaction Processing System
(TPS):
A small organization tends to process transactions that might result from day-to-day activities, such as purchase orders, creation of paychecks and thus require using TPS.
b) Management Information System(MIS):
Managers and owners of small organizations tend to incline towards industry-specific MIS, in order to get historical and current operational data, such as inventories data and sales.
c) Decision Support System
(DSS):
A DSS to allow managers and owners of small organizations to use predefined report in order to support problem-resolution decisions and operations planning.
You want 10-12 too?.............
Media is the surface or material that an artist works on