(Solved): NEED HELP ASAP Your report must contain the following: - Assignment: S1 Name: YOUR NAME Section: YO ...

NEED HELP ASAP Your report must contain the following: - Assignment: S1 Name: YOUR NAME Section: YOUR COURSE AND SECTION Task 1 - ERD Model - Based on the specification received create a ERD in MySQL Workbench. - Sign the ERD by writing your name in a text object. - Take a picture of your ERD. - Include in the report file the following: - A heading: Task 1 - ERD Model - The signed screenshot (image) of the ERD - Task 2 - Create database - Start writing the SQL script in MySQL Workbench to perform the following operations: - Include a comment: Task 2 Create database by ... (your name) - If there is a database with the provided name, delete that database. - Add a database with that name. - Mark the created database as the default database for the following operations. - Show all the databases, find the created one in the list - Execute and debug the script in MySQL Workbench until runs without error and performs the above operations. - Include in the report file the following: - A heading: Task 2 - Create database - A screenshot (image) of the source code for this task only (crop the image if necessary) - top of the screen - A screenshot (image) of the results for the performed operations - bottom of the screen Task 3 - Create table ZERO GRADE: You will receive a grade of zero in ANY of the following situations: Not following the instructions from this semester (e.g. following instructions aspects from previous semesters, e.g. the format of your report) Not following your specifications (2-3 elements in your design are not based on this semester requirements but they follow previous semesters requirements or other versions of questions from this semester) Your ERD screenshot(s) are not signed, or are not signed correctly (a textbox added in MySQL Workbench with your name) The names of your entity do not follow the name prefix/suffix rule described below. The names of your attributes do not follow the name prefix/suffix rule described below. The code has very similar parts with another student's submission. Database Specification (this is a fictional scenario) You were contacted by a company named "Happy Time" to create a database with their employees. For an employee you will store the following information: A code (three characters) The first name (a text of up to 18 characters) The middle name (a text of up to 18 characters) The last name (a text of up to 18 characters) The phone number (a text with the pattern "(999) 999-9999") All the employees must have a code, first name, last name and phone number. Create a database, named HR , with a single table following the provided specification. First example of an employee is: Code: 235 First Name: Joe Middle Name: Peter Last Name: Doe Phone: (981) 884-6814 Second example of an employee is: Code: 239 First Name: Mary Last Name: Doe Phone: (981) 083-8913 Ask the following queries: The list of employees last name, first name and phone number. The list of employees with the first name "Joe".