online exsam

Ballester, Francis

Ford, Sam

Francis, Rizia

Horstman, Clayton

Nikdoost, Allen

O’Connor, Kris

Questions

Module 7

1. Define Pseudocode

13. Create an algorithm for identifying complaints in a satisfaction survey (assume a 10-point scale, with answers of 3 or less considered a complaint)

Module 9

5. Create SQL statement to identify courses that are taught by Mark Zhulin and James Sealy.

6. List the first and last name of each student followed by the faculty ID from the student table and the faculty name of their faculty advisor.

Answers

Module 7:

1. Pseudo code is simplified program design language, designed primarily for human reading.

13. Algorithm for identifying complaints:

i. When answer is less than 4, flag response as a complaint.

ii. Ask “Why dissatisfied?”

Module 9:

5. SELECT * FROM COURSE_SECTION WHERE F_ID = '3' OR F_ID = '5';

6. SELECT student.s_first, student.s_last, student.f_id, faculty.f_last FROM student inner join faculty on student.f_id=faculty.f_id;