Description

For this project you will bo implementing the ridesharing company database model you doveloped in the previous homework assignments. You will be adding tables to your database and PHP scripts that add support for ridesharing. The final product of this project ae $2$ static hernl page displaying required information Example output of this pago is shown in the end of this file. Your table could use random texts generated from online database creation sule.

Requirements

Use portable server to develop tho project.

Add to your database

a$.$ Create the appropriate tables in your database for the following $($make suro there are no spacos in any of the table or attribute names$)$:

Customers $-$ name and phone number.

ii$.$ Drivers $-$ A driver needs to have $3$ name, phone number etc.

ii$.$ Trips $-$ have necessary atributes such as date, time, duration, cost, and information on pickup location and drop off locations.

iv$.$ Cars $-$ contain car information on m$$del$,$ year, mileage etc.

v$.$ Have at least one many$-$to$-$many relationship in your database $($this could bo customer to trips relationship table, etc.$)$

vi$.$ The tables created should conform to the relational database formalization standards $($at least third normal form$).$

b$.$ The $\frac{E}{R}$ Hw$2$ should help here. In this project, you may need to add or drop certain attributes.

c$.$ Add EXACTLY $100$ Customers to your dalabase. You must have EXACTLX $20$ Drivers and EXACTLY $200$ Trips

d$.$ Add data to your database to include ridesharing information as follow.

i$.$ You must have a record of EVERY trip by every customer

ii$.$ You must have a record of when the trip was made.

ii$.$ You must have record on who drove which customer and with which car $($maybe on different umes$)$

iv$.$ At least $10$ Customers made $2$ or more trips $($maybo on diffcrent occasions$)$ v$.$ At least $10$ Drivers have driven multiple trips.

vi$.$ These should be at least one entry for every customer in the Trips table $($likely more than one entry per customet$)$

You may find it helpful to use a random SQL dala generator such as:

$($Preferred$)$

w$.$generatodala com

You will create a PHP file named "Womenplun". This PHP file load your database tables and display the content of all the tables you created for thus project including all the keys and foreign keys if any $($og the result of select "from Trips$)$

You will create a PHP file named "tripswahp". This PHP file processes the database information and displays the information about the trips by customers.

a$.$ Your codo must include mechanisms to communicate with the MySQL database and sead the information on trip activities.

b$.$ Do NOT hard code any of the database data in your HTML$.$ In other words, your codo MUST communicale with the database and retrieve the data

c$.$ You must display the information about ALL the trips made. Order your output by Customes names as shown in the attached example.

d$.$ You must include the following information for each trip:

i$.$ Name of the Customers $($not the id$)$ ii$.$ Drrver Names $($not the id$)$ iis. Description of the car $($not the car id$)$

iv$.$ When the trip was made

Check that your code is working on portable server. trosphr is shown in the next page. The bomeshe display would bo the same as if you are displaying them in MySQL inserfacc including all the original isble attributes.

What to Submit:

The schema for all the tables $($screen capture$).$

Screenshots of home.php and trips.php outputs including "Tocalhost" on the top. If one screen is not enough, capture multiple screenshots to include all the outputs.

All the html$/$ghp and database creation $(-$sql$)$ files

Grading Criteria

File accessible via appropriate URL.

Code correctly connects to the database

Appropriate data is displayed for each order

Appropriate data is displajed for each table in home pace Points $25$ pts will be deducted if not subrnitting all the required files

Total

Display example for trips.php page:

Customer FirstName LastName

Drove by FirstName LastName

On Car Name on: $\frac{11}{13}\frac{?}{16}$

Drove by FirstName LastName

On Car Name on $12/1/16$

I use mysql for this assignment.