hello tutor,

i have homework M275 ,, i need answer for all question plz

thank youM275 – TMA Page 1 of 5 2016-2017 / Summer Faculty of Computer Studies M275 Web Development Using PHP and MySQL Tutor Marked Assignment – Summer Semester 2016/2017 Cut-Off Date: TBA Total Marks: 100 Contents This TMA consists of 3 questions, where you are required to answer all of the questions. The TMA will be corrected by your tutor and you will be provided with a proper feedback file to understand your mistakes and avoid them on the final exam. Plagiarism Warning: As per AOU rules and regulations, all students are required to submit their own TMA work and avoid plagiarism. The AOU has implemented sophisticated techniques for plagiarism detection. You must provide all references in case you use and quote another person's work in your TMA. You will be penalized for any act of plagiarism as per the AOU's rules and regulations. Declaration of No Plagiarism by Student (to be signed and submitted by student with TMA work): I hereby declare that this submitted TMA work is a result of my own efforts and I have not plagiarized any other person's work. I have provided all references of information that I have used and quoted in my TMA work. Name of Student: Signature: Date: M275 – TMA Page 2 of 5 2016-2017 / Summer Question 1 [20 Marks] Using the AOU e-Library or other online sources, search for PHP and PERL and provide about 200 words paragraph discussing (comparison, features, performance, anything you like…). Make sure to list your references from when you gathered the information. Question 2 [50 Marks] This question is based on the “guessing machine” (Chapter 11) that was discussed during the tutorials. You are asked to implement the PHP and HTML code that will complete the program below. The program is mainly a Quiz to try and guess the answers to all the questions. Here is a sample run with explanations: For the first visit, the user will be presented with a Welcome message and the quiz questions. M275 – TMA Page 3 of 5 2016-2017 / Summer The user will select his answers from the “radio” input elements for all the questions and clicks on submit. The system will count the number of correct answers provide feedback and the questions again as follows. If the user was able to know all the answers then the following will be presented: M275 – TMA Page 4 of 5 2016-2017 / Summer Question 3 [30 Marks] Writing SQL queries: Read the section “Using Join” of Chapter 16 in the book (pages 312 -> 314 in the fifth edition) then answer the questions below: Consider the following tables: drivers driverid drivername age carid 12 Fred Racer 23 111 15 Ahmad Taxi 35 312 16 Georges Beetle 50 516 20 Ali Drifter 26 217 M275 – TMA Page 5 of 5 2016-2017 / Summer cars carid cardetails 217 BMW 420i 312 Toyota Avanza 516 VW Beetle 111 Subaru BRZ a- Write an SQL query to create the table drivers b- Write an SQL query to create the table cars c- Write an SQL query to insert 1 set of data into the table drivers d- Write an SQL query to insert 1 set of data into the table cars e- Write an SQL query to retrieve (select) all the driver names whose age is above 25. f- Write an SQL query using JOIN to retrieve (select) all the car details of the cars driven by drivers whose age is less than 30. End of the Questions

Attachments:

• 1510236272-M275_TMA_Summer2016-2017.pdf