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:

1. populate each table with 10 entries using er diagram below: command(s).

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

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!