#Database

Explain the ACID properties in database transactions. Include examples to illustrate each property.

Describe what composite indexing is in databases. Provide examples of how and when it should be used effectively.

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.