Describes the movement of inventory

Assignment Help Database Management System
Reference no: EM13192622

Fresh-Mart Grocery is a regional grocery chain that is developing an information system to monitor inventory levels, product sales, and merchandise turnover. As products are sold in stores, they need to be replaced by shipments from the distribution centers. The IT manager wants you to document a process called BALANCE that determines whether extra product inventory is needed in a particular store. The BALANCE process is to be used in a just-in-time inventory system that automatically orders products and routes them to various stores for sale. A store manager can override the automatic BALANCE process if he or she so desires to get more product into a store.

Tasks

1. Create a decision table that describes the movement of inventory.

2. Draw a decision tree that describes the merchandise inventory management process.

3. Name four attributes that you can use to define a data flow in the grocery inventory information system.

Name four attributes that you can use to define a data store in the grocery inventory information system.

Reference no: EM13192622

Questions Cloud

Find the number of hits for each player : two minor league baseball players got a total of 216 hits. Washington had 2 more hits than Sanchez. Find the number of hits for each player?
Compute the ph for each of the cases in the titration : Calculate the pH for each of the following cases in the titration of 50.0 mL of 0.210 M HClO(aq) with 0.210 M KOH(aq). (a) before addition of any KOH (b) after addition of 25.0 mL of KOH (c) after addition of 40.0 mL of KOH
What are the steady state solutions for wages growth : Imagine an economy with a standard Cobb-Douglas production function, population growth of 2%, 1% total productivity growth, a savings ratio of 10% and a profit share of 20%. Assume that machines depreciate by 5% per annum.
What is the probability about the keyboard : What is the probability that the keyboard you bought was manufactured in Factory A or Factory B? Show your work.
Describes the movement of inventory : Create a decision table that describes the movement of inventory and draw a decision tree that describes the merchandise inventory management process.
State percentage does a dilute aqueous solution expand : By what percentage does a dilute aqueous solution expand when heated form 15 degrees C to 25 degrees C? If a 0.5000 M solution is prepared at 15 degrees C,
What is the probability that he will make both shots : kareem stepped to the free throw line for two shots. If the probability of making each shot is 3/4, what is the probability that he will make both shots?
Describes the big state university : Create a decision table that describes the Big State University course catalog regarding eligibility for MIS 260. Show all possible rules and simplify the table you just created. Describe the results.
Determine what the shop would pay if its output were zero : Suzy is considering opening a restaurant. To do so, she would have to quit her current job which pays $20,000 a year and use her own car which she currently leases out to her brother for $2,000 a year.Her expenses at the restaurant would be $60,000..

Reviews

Write a Review

Database Management System Questions & Answers

  Create a database design - relational data model

Create a database design specification Enhanced Entity Relationship Diagram (EERD) and Relational Data Model from the given business description - Database Management System

  Find names of students who have higher gpa from table

List the students ID, name, GPA, and course Number such that all students have GPA greater than 3 . 5 and enrolled in a course in Jan 1, 2011. Find the names of all students who have GPA greater than 3.

  Systems analysis and database design

Based on the information in the Bike Mania case study, use a suitable CASE tool or drawing package to draw up a set of diagrams showing the current physical view of the systemusing the unified modeling language (UML 2.0) notation

  Explaining database security relate to data integrity

In talking about database security, some aspects to regard as are Data Integrity, Confidentiality, and Malicious Activity. Illustrate how does database security relate to data integrity?

  Security associated with new project

Your company has put in the request for a new database system and you have been tasked with architecting the security associated with this new project.

  Determining the matrix form of game

Assume a game with two players, A and B, who raise one or both hands concurrently. A wins if total number of hands raised is odd, and B wins in other way.Write down the matrix form of the game. Is there a pure strategy solution? Explain your answer..

  Your task is to develop a database to support this activity

Your task is to develop a database to support this activity.Here is what you need to be able to provide Custom Auto Body in order to land your first consulting contract:

  Estimate the height of the b plus tree

Estimate the height of the B+ tree. (Giving a range of heights is fine.) Also estimate the amount of memory needed to store the tree, including leaves but not including the posting lists themselves.

  Explain the concept of physical data independence

Explain the concept of physical data independence and its importance in database systems,  List four significant differences between a file-processing system and a DBMS.

  What functional dependencies can you identify

Suppose you have a relation schema about teaching classes that has the following attributes: Class, Instructor, Time and Room - based on your understanding of this scenario, what functional dependencies can you identify that hold on this relation?

  Express the relationships graphically with an e-r diagram.

A vendor builds multiple types of tablet computers. Each hs a type identification number and a name. The key specifications for each type include amount of storage and display type.

  Design er schema to keep track of information of votes

Design an er schema for keeping track of information about votes taken in the U.S. House of Representatives during the current two year congressional session.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd