Question

You are designing a simple system for managing grades of students in a computer science course and need to track each student's first name, last name, eight-digit CUNY Id, grade, and courseld - referencing a second table with all the names and numbers of computer science courses. [1] Write the SQL that creates these two tables, including any designation of keys. (Assume that the database itself already exists.) 2] Write the code for a client-side search form that allows a user to input the first name, last name, CUNY ld, and/or course, and submits a request for that data. 3] Write the code for a server-side page which will process such a request, retrieve the records matching the search criteria passed in, and return the results as table-formatted html for display in the browser.

Answer 1

1) 2 tables students_grade and course

create table students_grade ( students_first_name varchar2, last_name varchar2, CUYN_ID varchar2 PRIMARY KEY, Grade Varchar2, CourseID Varchar2 FOREIGN KEY References Course(Course_ID));

Create table course (course_ID varchar2 PRIMARY KEY, course_name varchar2,, No_of_courses);

2) select * from students_grades where students_first_name=&a and last_name=&b and CUYN_ID=&c and course_id=&d;