use SQL please. A store in Palo Alto decides to go hightech. You are asked to design a database for the store. After brainstorming with the store managers, you come up with the following specification: The store has multiple departments, identified by their names. Each department may have many employees but only one of them is the department manager. Employees are identified by their names. We also need to record their salaries. Each employee may work in only one department. Managers are employees as well, although each of them also gets to manage one department. The store sells various items identified by item IDs. Each item is carried by exactly one department, while each department may carry many items. For each item, we also need to keep a short description and its quantity in stock. The store deals with a number of suppliers identified by their names. We need to record their addresses. Each supplier supplies an item at a particular price. A supplier may supply any number of items, and the same items could be supplied by other suppliers (probably at different prices).

A store in Palo Alto decides to go hightech. You are asked to design a database for the store. After brainstorming with the store managers, you come up with the following specification: The store has multiple departments, identified by their names. Each department may have many employees but only one of them is the department manager. Employees are identified by their names. We also need to record their salaries. Each employee may work in only one department. Managers are employees as well, although each of them also gets to manage one department. The store sells various items identified by item ID's. Each item is carried by exactly one department, while each department may carry many items. For each item, we also need to keep a short description and its quantity in stock. The store deals with a number of suppliers identified by their names. We need to record their addresses. Each supplier supplies an item at a particular price. A supplier may supply any number of items, and the same items could be supplied by other suppliers (probably at different prices). A store in Palo Alto decides to go hightech. You are asked to design a database for the store. After brainstorming with the store managers, you come up with the following specification: The store has multiple departments, identified by their names. Each department may have many employees but only one of them is the department manager. Employees are identified by their names. We also need to record their salaries. Each employee may work in only one department. Managers are employees as well, although each of them also gets to manage one department. The store sells various items identified by item ID's. Each item is carried by exactly one department, while each department may carry many items. For each item, we also need to keep a short description and its quantity in stock. The store deals with a number of suppliers identified by their names. We need to record their addresses. Each supplier supplies an item at a particular price. A supplier may supply any number of items, and the same items could be supplied by other suppliers (probably at different prices)