Question: MYSQL coding help Attached are pictures of the database, tables and content within the database. Task 1: Insert Records to Image Table Construct the SQL

MYSQL coding help

Attached are pictures of the database, tables and content within the database.

MYSQL coding help Attached are pictures of the database, tables and content

within the database. Task 1: Insert Records to Image Table Construct the

SQL statement to insert 5 new records in the image table. Task

2: Insert Records to Message-Image Table Construct the SQL statement to insert

5 new records in the message_image intersection table. Note: You are required

to add at least one record where at least one of Michael

Task 1: Insert Records to Image Table Construct the SQL statement to insert 5 new records in the image table.

Task 2: Insert Records to Message-Image Table Construct the SQL statement to insert 5 new records in the message_image intersection table. Note: You are required to add at least one record where at least one of Michael Phelp's messages includes at least one image. Also, you are required to add at least one message that has multiple images.

Task 3: Find All of the Messages that Michael Phelps Sent Construct the SQL statement to find all of the messages that Michael Phelps sent. Note: You must use the WHERE clause to set the conditions for this query. Display the following columns: - Sender's first name - Sender's last name - Receiver's first name - Receiver's last name - Message ID - Message - Message Timestamp

Task 4: Find the Number of Messages Sent for Every Person Construct the SQL statement to find the number of messages sent for every person. Note: You must use the WHERE clause to set the conditions for this query. Display the following columns: - Count of messages - Person ID - First Name - Last Name

Task 15: Find All of the Messages that Have At Least One Image Attached Using INNER JOINs Construct the SQL statement to find all of the messages that have at least one image attached using INNER JOINs. Note: For messages with multiple images, display only the first image for the message. Display the following columns: - Message ID - Message - Message Timestamp - First Image Name - First Image Location

mysql> SHOW TABLES; I Tables in messaging I contact list image I message I message image I person 5 rows in set (0.00 sec)

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!