Answer Happy

PLS PROVIDE SCREENSHOTS. Use Mysql Console to execute the questions/queries below. Write SQL statements to - 1. Create a database - LabExam Take screen shots of the SQL syntax (2 Marks) 2. In the 'LabExam' database - Create three [3] tables - User, Vaccine and bridge table between User and the Vaccine. User is a parent table that stores user's data, Vaccine is also a parent table that stores available vaccines data. And the bridge tables store's info on the user and the vaccine/she/she received. All the three tables must have proper constraints. Each table must have at least 4 attributes. [user_id in the user table must be auto increment]. Take screen shots of the SQL syntax to create the tables and of the table structures. (21 Marks) 3. Make the user_id start from 10001. Take screen shots of the SQL syntax. (2 Marks) 4. Insert 3 records in each table. One record in "user' table must have your details - your Name, gender etc Take screen shots of the insert statement and output of the all the three [3] tables with data. (3 Marks) 5. Alter the table student to add another column 'user status' with not null constraint. Take screen shots of the SQL syntax and the output. (3 Marks) 6. To update the status of all the user to either 'received' or 'pending'. Take screen shots of the SQL syntax and the output. (2 Marks) 7. To display the total number of vaccine shots each user has taken [using group by] Take screen shots of the SQL syntax and the output. (5 Marks) 8. To display user name and the corresponding vaccine name [using group by] Take screen shots of the SQL syntax and the output. (5 Marks)