CSET 3300: Database-Driven Web Applications Homework Assignment 6 Description For this assignment you will be expanding the simple car rental database application you developed in the previous homework assignments. You will be adding tables to your database and PHP scripts that add support for cars and customer payment methods. Requirements 1. Log on to the server using SSH (Windows users can use putty to connect with SSH). The address for the server is 131.183.222.38. 2. Create a directory named cset3300-hw6 inside the public_html directory: a. cd public_html b. mkdir cset3300-hw6 3. Add to your database a. Create the appropriate tables in your database for the following (in addition to the one created in the last assignment): i. Cars, cars have names, although the cars may have unique IDs in the table, each location may have multiple cars that are the same model. as example, location 1 may have 3 Honda Civics available. ii. Customer payment methods (customers may have more than one payment methods, e.g. two credit cards) iii. Customer rent cars from locations. b. The E/R and UML solutions for HW1 and 2 should help here. c. Add EXACTLY 50 customers to your database i. Add at least 1 credit card for each buyer. ii. At least 10 customers should have at least 2 payment methods. d. Add data to your database to include information on purchases. i. You must keep track of EVERY car from every pickup location. ii. You must keep track of when a pickup was made. iii. You must keep track of who pickup up cars from which location and how many cars iv. At least ten customers picked up 2 cars (maybe on different dates) v. You must have EXACTLY 30 cars and EXACTLY 20 pickup locations vi. At least 10 cars have been picked up by multiple customers. vii. Add at least 200 entries into your table for tracking pickup activities. viii. There should be at least one entry for every customer (likely more than one entry per customer) 4. You will create a PHP file named pickups.php. In this file, you will place your HTML and PHP code to display the information about the purchases. a. Your code must include mechanisms to communicate with the MySQL database and read the information on checked out copies. b. Do NOT hard-code any of the database data in your HTML. In other words, your code MUST communicate with the database and retrieve the data dynamically c. You must display the information for ALL the cars that are rented. GROUP your output by car names. d. You must include the following information for each picked up car: i. Name of the car ii. Location(s) that have supplied the car iii. Full name of Customer(s) who picked up the car iv. The payment method(s) of the Customer(s) who picked up the car v. When was the pickup made 5. Edit your home.php to specify which cars are still available for rent at each location. a. NOTE: This is different than in your last assignment. b. Show the number of certain cars that are available at each location. 6. You may either create the php files on your own computer and copy it to the server using SCP (or something like WinSCP for Windows users), or you may create it and edit on the server. The server has both vi, and pico, for basic test editing. 7. Place your PHP files in the public_html/cset3300-hw6 directory. 8. Check that your code is working using a URLs as following: http://131.183.222.38/~your_utad_username/cset3300-hw6/home.php http://131.183.222.38/~your_utad_username/cset3300-hw6/pickups.php substitute your_utad_username with your UTAD username (e.g., jsmith3)