Consider a table named "Employees" with the following columns: "EmployeeID", "FirstName", "LastName", and "Salary".

Write an SQL query to select all employees whose salary is greater than 50000.

What would be your query?

Mention any three features of a database system. Again, write queries to -

EmpDetails

EmpId     EName       ManagerId   DateOfJoining

 121      Mina Rout         321          01/31/2018

 321      John White       986          01/20/2017

 421      Manish Rana     876          27/12/2017

1. Write An SQL query to fetch the names of the employees who have joined in 2017.

2. Write a query to show the manager’s names.

Create a database with the following tables and write queries in MySQL:

SALESMAN{SID, FNAME, LNAME, PRODID, QUAN, AMT}

PRODUCT{PID, PNAME, IN_STOCK}

1. Write an SQL Query to display the first names of the salesperson in the upper case using the alias FIRST_NAME.

2. Write an SQL COMMAND to display the names of the products that are out of stock.

3. Write an SQL Query to display the details of the salesperson whose sale_amount is the second highest.

Bring your own device or BYOD is great for some companies. I don't think every business needs to implement it or should implement it. There are inherent security risks when employees use their own devices for work related matters. They are not always on a secure network and usually have personal e-mail accounts on them as well as internet searches that may not be suitable or appropriate for business. Then there are very small companies that choose to save some money and have employees use their own device. If there are no real security threats and mainly used for email this will probably work out ok for everyone. In my current field it is just easier to use my own device even though we don't have a written policy regarding it. 

I need to expand on the above writing.