This essay focuses on Elemental Music Elemental Music was find. The founder of Elemental, Aaron Blake, was a chemist who retire young to pursue his dream of opening a chain of science-theme music stores.

Elemental Music Elemental Music was find

Take-home Assignment 2 Elemental Music Elemental Music was found in Nashville in 2010 as a seller of guitars, bass guitars, amplifiers, effects pedals, strings, and accessories. The founder of Elemental, Aaron Blake, was a chemist who retired young to pursue his dream of opening a chain of science-themed music stores.

At first Aaron managed his business via email and tools like Excel and Visio

, but as Elemental grew and added more employees and stores these processes became inefficient and prone to miscommunication and errors. Aaron now needs a more systematic way to keep track of the company’s data to better manage his business. You have been hire as a BSA consultant to help Aaron design an information system to manage Elemental. Your first step is to model the database at the core of the system using an entity-relationship diagram. After several formal and informal interviews with Aaron and his key employees, you have put together a narrative listing the rules and processes inherent to Elemental’s business:   Elemental wants to keep track of its customer data for its rewards program. An individual becomes a customer the first time he or she purchases something in a store.

(Elemental does not sell products online).

Each time a customer spends money in a store, a sales order is generate. Each sales order can contain one product or many products. Before going on the shelves, Elemental purchases the products that are sell in its stores from different suppliers. Each product comes from one particular supplier, but each supplier can provide many products to Elemental. Each time Elemental wants to purchase products, Elemental generates a purchase order and sends it to the supplier. A purchase order contains at least one product but often contains many products, each with different quantities. When Elemental receives products from suppliers, they are place into inventory.

Inventory is keep in nine different locations: seven retail stores

, and two external warehouses. Aaron needs to keep track of how much inventory of each product exists in each of these nine locations.       The ERD must be complete using a tool like draw.io, Lucidchart, or Microsoft Visio. It should use a template similar to the one we use to create ERD’s in class.

Submission details;

Firstly, submit on time

Secondly, time

Thirdly, honesty