Consider the following data base schema:

Student(studentID, sname, major, level, #deptid)

Class(classNum, cname, Time, room, #teacherID)

Enrolled(#studentID, #classNum)

Teacher(teacherID, fname, #deptid)

Write procedure that take class number as parameter then display student identifier, student name and level for all students in the class.