Task 1: Create the database

1. Write an CREATE.sql file to create the schema pictured in figure 1.

• You should have create statements for each of the tables with all their attributes and keys. Data types are indicated in the figure.
• Also create a user that your PHP can use to access the database. This will require both a create and grant statement.
• Add at least 3 classes and at least 15 grades using at least 2 insert statements in your script.

Figure 1

1. Test your create script on your VM and adjust as necessary until full functional.

Task 2: Create the front end

1. Write a database.php to connect to your database on your VM using the credentials created in your script.

• Hint! We modified a database.php last week in assignment 9. There are examples in chapters 4 and 19. You can use either PDO or mysqli for this assignment.
• This connection script should include a try/catch for connection. If an error occurs, you will want to include an error or database_error.php script that displays that error to the user. Again, we worked with such a script in assignment 9 or you can find examples in your book. Make sure to include such a script in your application.

1. Write index.php. This script should select values from the database and display those values to the user using html. You have 2 options to fulfill this requirement:

• Option 1: Display all grades recorded in the database, grouped and summarized by class. This means that I expect a percentage figured and displayed for each grade, but an overall grade to be calculated and displayed as well. All courses would be displayed on a single html page in separate tables.

1. This option will look similar to an example in chapter 4 where you have multiple foreach statements.

• Option 2: Start the user experience by displaying a form where the user would choose a class. On submit of the form, display the grades for that class including the percentage for each assignment and the overall percentage.

1. This option will require you to make index.php a form with a submit action pointing to an additional file that displays results: grades.php.
2. This will also require you to bind parameters, using the value(s) entered in the form.

Task 3: Test your application and style as wanted

1. Test your application by calculating the grades for the records you inserted.

• If you encounter errors, adjust your code and continue to test until you have a functioning application.

1. Add any style you wish to dress up your application. In the last assignment, we used a template to help make our application look professional. At a minimum, I will expect a main.css file.

• Make sure to include any credit statements needed in your html and all needed style files in your final submission.

Task 4: Submission with Git

• Your repo should include at a minimum:

1. create.sql
2. Database.php
3. Database_error.php
4. Index.php
5. Grades.php (optional)
6. Main.css (and any other style files)

Transcribed Image Text:

assignment grade id description pt possible pt_earn class id int, ai, pk varchar(45) int decimal int, fk class id dept num section name semester year class int, ai, pk char(4) int char(2) varchar(45) char(2) int assignment grade id description pt possible pt_earn class id int, ai, pk varchar(45) int decimal int, fk class id dept num section name semester year class int, ai, pk char(4) int char(2) varchar(45) char(2) int