The following three tables store information on students, assigned exercises, and exercise submission in LiveLab. LiveLab is

Question:

The following three tables store information on students, assigned exercises, and exercise submission in LiveLab. LiveLab is an automatic grading system for grading programming exercises.image

The AGSStudent table stores the student information. The ExerciseAssigned table assigns the exercises by an instructor. The AGSLog table stores the grading results. When a student submits an exercise, a record is stored in the AGSLog table. However, there is no record in AGSLog if a student did not submit the exercise.Write a program that adds a new record for each student and an assigned exercise to the student in the AGSLog table if a student has not submitted the exercise. The record should have 0 on score and submitted. For example, if the tables contain the following data in AGSLog before you run this program, the AGSLog table now contains the new records after the program runs.image

image

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: