Question: 1. populate each table with 10 entries using er diagram below: command(s). 3. Using the MySQL CLI, issue the following SQL queries to test the
1. populate each table with 10 entries using er diagram below:

command(s). 3. Using the MySQL CLI, issue the following SQL queries to test the database. Take a screen shot of each one that you use successfully. a. A SELECT query that outputs the entire contents of a table. b. A SELECT query that outputs only two fields (columns) from all of the records in a table. c. A SELECT query that outputs all fields of records that match a condition in a WHERE clause. d. A SELECT query that outputs two fields from all records that match a condition in a LIKE clause. e. A SELECT query that matches a condition in one table and outputs all fields of related records in a second table. The two tables must have a relation or you can use a JOIN statement if desired. f. An UPDATE query that updates all records matching a WHERE condition. g. A DELETE query that removes all records matching a WHERE condition. This query must leave some records remaining in the table. h. An INSERT query that adds a record to one of the table(s) in the database
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
