SQL Data Definition and Data Manipulation

Due: 11:00pm, Thursday, November 4, 2022

Assignment Description

In the assignment directory there is a file named grade_report.dat that contains grade information for students. Each student record has a line for:

• Student ID
• Last name
• First name
• Course
• Section
• Category (project, homework, exam)
• Grade item
• Grade

Write a PHP program named project6.php to produce a SQL script that has a CREATE statement and an INSERT statement for each student record. The table name should be grade_report with columns named student_id, last_name, first_name, course, section, category, grade_item, and grade. The output file must be named grade_report.sql.

Note: this project is similar to project 3 where we converted data from one structured form to another.

Instructions

To start the assignment, login to your university Linux account and copy the assignment code to a location somewhere under your home directory. The assignment code is located at:

/export/home/public/schwesin/csc242/projects/project6-handout

You need to edit the project6.php file. Do not change the names of the file.

To submit your assignment, execute the following command from within your project6-handout directory:

    ~schwesin/bin/submit csc242 project6

Grading Criteria

• Concise, accurate documentation following the CSC Department documentation guidelines

• Correct implementation of the specification

• The SQL script executes without any errors.

Note: If the code has syntax errors or does not execute properly, you will receive a failing grade for this assignment. If the submission includes material that was not covered in class and the material is not properly cited, then you will receive a failing grade for this assignment.