Question: sk 2 , page name: task 2 . php , chapters: 1 7 , 1 8 and 1 9 , marks: 3 0 Refer to
sk page name: taskphp chapters: and marks: Refer to the diagram in Task aCreate a database with three tables as illustrated in the diagram.Populate the tables with realistic data, with at least rows of data in each table. Note that the SQL data type for each column is not given in the diagram. So you have to decide on this aspect.Write PHP code to connect to the database and display the contents of all three database tables in three different HTML tables on the web page.Below the tables, provide the necessary forms so that the user can: add a row of data to the table Member; modify any rows of data in the table MemberGroup; and delete any rows of data in the table Group. Adding, modifying, and deleting data from the DB tables must result inICTupdating the HTML tables with data as well.There must be a form with five radio buttons where the user can choose to view the results of one of the five different SELECT queries at a time. The label of each radio button must be the matching SQL The results of the queries must be displayed below the radio buttons, independent of the other HTML tables on the web page.Details of these five SELECT queries are given below: The first SELECT query must make use of the ORDER BY clause The second SELECT query must make use of the LIKE operator The third SELECT query must make use of an inner join that joins two tables The fourth SELECT query must make use of a LIMIT clause The fifth SELECT query must make use of the aggregate function MAX.You can decide on the other details of these SELECT queries.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
