#Database

Create a design for an Inventory Management System that includes features such as barcode scanning for item entry and exit, as well as warehousing functionalities. Include database design, entities, and system flow description.

Write an SQL query to find the second-highest salary from an employee table. The table contains a column 'salary'.

How did you approach the design of your database for the project? Discuss your considerations regarding efficiency and scalability.