Question: Create a database with three tables as illustrated in the diagram.Populate the tables with realistic data, with at least 5 rows of data in each

Create a database with three tables as illustrated in the diagram.Populate the tables with realistic data, with at least 5 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 inICT3612/103/0/20246updating 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:1) The first SELECT query must make use of the ORDER BY clause2) The second SELECT query must make use of the LIKE operator3) The third SELECT query must make use of an inner join that joins two tables4) The fourth SELECT query must make use of a LIMIT clause5) 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!