[1] Write code for a webpage that uses client-side programming to extract dynamic data from two other sites and displays

that information locally. In one case, it should traverse the document of the third-party html, while in the other case, it

should use a provided API. (You may make reasonable assumptions made about the structure of the html or the API.)

The data should refresh upon clicking a Refresh button.

[2] Discuss some practical issues that can arise in the implementation of such an exercise.

 

Section B: 

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 courseId - 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 Id, 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.