Customer sales and inventory control

Reference no: EM13271725

Cakes & Bakes operates an online transactional database for recording information about customer sales and inventory control. It records all the transactions that are processed, including not only the ordering and delivery of stock items from the various warehouses to the supermarkets, but also the recording of inventory changes as the barcode reader scans each item at the checkout. A database server is located in each store, as well as each distribution warehouse, and the data is replicated over high-speed WAN connections to the Headquarters. Mr. Muhammad wants to view reports of total sale made by the different salesmen at different locations, product spoiled and quantity on hand in each warehouse. Draw the snow flake schema with possible hierarchies of the above scenario.

Reference no: EM13271725

Questions Cloud

Why does the processing of a crystalline material required : Why does the processing of a crystalline material like nylon require more critical thermal control as opposed to an amorphous material like ABS

Find the intensity of light transmitted by pair of sheets : A horizontal beam of vertically polarized light of intensity 43 W/m2 is sent through two polarizing sheets. What is the intensity of the light transmitted by the pair of sheets

Analyze the use of an enterprise software systems : Analyze the use of an Enterprise Software Systems (ESS) in a health care organization with regard to its effects on operational outcomes. Select one of the following applications, and recommend three specific ways that the application you selected ca..

The microwave ovens emit microwave energy with a wavelength : Microwave ovens emit microwave energy with a wavelength of 12.2 cm. What is the energy of exactly one photon of this microwave radiation

Customer sales and inventory control : Cakes & Bakes operates an online transactional database for recording information about customer sales and inventory control. It records all the transactions that are processed, including not only the ordering and delivery of stock items from the var..

Determine the secondary voltage : In a television set, the power needed to operate the picture tube comes from the secondary of a transformer. Determine the secondary voltage

What due process rights are contained in u.s. constitution : What due process rights are contained in the U.S. Constitution and what is procedural due process, and why does it exist?

Compute the average mass of the element : A particular element exists in two stable isotopic forms. One isotope has a mass of 34.9689 amu ( 75.77% abundance). The other isotope has a mass of 36.9659 amu. Calculate the average mass of the element and determine its identity.

How many shares of each company should you purchase : How many shares of each company should you purchase so that your portfolio consists of 40 percent Alaska Air, 20 percent Best Buy, and 40 percent Ford Motor.

User Account

All Pages