MIS

QUESTION: 01 Perform this question over the MySQL Workbench and PASTE screenshots of the required queries.

1. Write a query to create a database entitled CompanyXYZ. 2. Write a query to create a table Manager_Data with M_No, M_Name, Gender, Phone_No and salary. 3. Write a query to add records in the table Manager_Data. (Max 5 records) (Show all the added records in the form of table) 4. Write a query to find the salary of a Manager where age is <= 24 and salary >= 20000 from Manager_Data table. 5. Write a query to get the names of the Managers between a and m. 6. Create another table entitled Department. 7. Add records in the Department table. 8. Create another table entitled Project. 9. Add records in the Project table. 10. Join the three created tables (Manager_data, Department, Project) with the help of inner join. And show results in the form of table.