(Solved) : Objective Exercise Give Practice Common Sql Commands Connect Vm Gcp Using Mysql Client Cre Q41375798 . . .

The objective of this exercise is to give you practice with some common SQL commands. Connect to your VM on GCP, and using th

The objective of this exercise is to give you practice with some common SQL commands. Connect to your VM on GCP, and using the MySQL client, create a database Events. Events will be used to store records of event and attendee information. You will create two tables, event and attendee, where event is the parent to attendee. Since an event can have multiple attendees, the relationship between event and attendee is 1 to N. Each event record has an ID, which serves as the primary key. To relate the two tables, you will define event ID as the foreign key in the Attendee table. The tables should include the following attributes: Event: Event ID, date, venue, contact email Attendee: Name, phone number, email, event ID Create the two tables using the MySQL client. No attribute may be NULL. Also make sure that the primary and foreign keys are correctly specified, and the data types you select for the attributes are appropriate. Create the schema based on the description provided above. Take a screenshot of the SQL commands you used to accomplish this. Now perform the following steps: 1. Create 3 or more event records. 2. Create 9 or more attendee records. To ensure data integrity, only use event IDs that are valid (i.e. ones that are defined in the Event table). Each event should have a minimum of 2 attendees. 3. Execute a select all query on each of the tables and take a screenshot that shows the query and result. 4. Execute a query that shows all attendees whose name starts with some letter of the alphabet that produces at least one record. Take a screenshot that shows the query and result. 5. Execute a query that shows the venues where events held (no other attributes should be included). Take a screenshot that shows the query and result. 6. Execute a query that shows the event IDs and a count of attendees for each event. Take a screenshot that shows the query and result. 7. Execute a query that shows all attendees for a given event. Take a screenshot that shows the query and result. Show transcribed image text The objective of this exercise is to give you practice with some common SQL commands. Connect to your VM on GCP, and using the MySQL client, create a database Events. Events will be used to store records of event and attendee information. You will create two tables, event and attendee, where event is the parent to attendee. Since an event can have multiple attendees, the relationship between event and attendee is 1 to N. Each event record has an ID, which serves as the primary key. To relate the two tables, you will define event ID as the foreign key in the Attendee table. The tables should include the following attributes: Event: Event ID, date, venue, contact email Attendee: Name, phone number, email, event ID Create the two tables using the MySQL client. No attribute may be NULL. Also make sure that the primary and foreign keys are correctly specified, and the data types you select for the attributes are appropriate. Create the schema based on the description provided above. Take a screenshot of the SQL commands you used to accomplish this. Now perform the following steps: 1. Create 3 or more event records. 2. Create 9 or more attendee records. To ensure data integrity, only use event IDs that are valid (i.e. ones that are defined in the Event table). Each event should have a minimum of 2 attendees. 3. Execute a select all query on each of the tables and take a screenshot that shows the query and result. 4. Execute a query that shows all attendees whose name starts with some letter of the alphabet that produces at least one record. Take a screenshot that shows the query and result. 5. Execute a query that shows the venues where events held (no other attributes should be included). Take a screenshot that shows the query and result. 6. Execute a query that shows the event IDs and a count of attendees for each event. Take a screenshot that shows the query and result. 7. Execute a query that shows all attendees for a given event. Take a screenshot that shows the query and result.

Expert Answer


Answer to The objective of this exercise is to give you practice with some common SQL commands. Connect to your VM on GCP, and usi…