The index.php program is supposed to prompt the user for a charter destination code, search the CHARTER table in the ch07_aviaco database running on your local XAMPP stack, and return the destination code and the total hours flown for the given destination code.  However, it does not work due to one or more programming errors.  Download the index.php file, correct the error(s), insert a PHP comment at each place where an error was found and corrected, save the fixed program, and upload the updated index.php program to this question.   The corrected program running a test for Destination Code “ATL” will result in a screen like the following: (NOTE:  The total hours for the ATL destination is 23.1 hours and a destination such as DEN will result in a “Charter Destination Code Not Found” message)

Using the following ERD of a single table, write the Create Table SQL statement to create the table.  Enter the SQL statement below  

Using the Invoice example and table information below. Create an “invoicedb” database schema, with the table(s) with all the fields needed to store all the data in the boxes indicated on the invoice.  Design the database schema so the table(s) are in 3NF.  Define primary and foreign keys where appropriate.    Copy the SQL commands below required to create the Schema and the tables.  

Using the “invoicedb” database schema created in the previous step, write SQL statement(s) needed to load data into the table(s) using the table data in the example image below:   Copy the SQL statement(s) below. 

I affirm that I have reviewed and familiarized myself with the ‘No Excuses’ ListLinks to an external site. for grammar, usage, mechanics, and APA formatting. I understand that these standards will be applied in grading throughout this course.

A parent calls a clinic and reports to a nurse that his 2-month-old infant is hungry more than usual but is projectile vomiting following all of their feedings.  Which of the following responses should the nurse take?

A nurse in a pediatric unit is caring for a 3-year-old who has a blood lead level of 3mcg/dL.  When teaching the child’s parent about the correlation of nutrition with lead poisoning, which of the following pieces of information is appropriate for the nurse to include?

The parents of a newborn diagnosed with cleft lip and palate ask the nurse when their child’s lip and palate will most likely be repaired.  Which is the nurse’s best response?

A couple who went through infertility testing and was told that everything looks normal but still has not conceived. They come to the clinic stressed and depressed. The woman tells the nurse that they seem to argue all the time now and she does not know if all this is worth it. What is the nurse’s best response?

The most reliable contraceptive method listed below?