Kitchen World Is Changing Its Inventory System from a File-Oriented

question 64

Essay

Kitchen World is changing its inventory system from a file-oriented system to a relational database system.Identify and design at least three tables that would be needed to capture data for Kitchen World's inventory.Each table should include a primary key,three non-key attributes,and foreign keys as necessary.Make up data values for two records within each table.

---

Definitions:

False Alarm

An incorrect signal or detection indicating the presence of a condition or attribute that is not actually present.

Control Limits

The boundaries defined in control charts within which a process statistic is considered to be in a state of statistical control.

Standard Errors

A measure of the statistical accuracy of an estimate, calculated from the standard deviation of the sampling distribution.

Sample Mean

This is the average of all the values in a sample set, calculated by summing all the numbers in the sample and then dividing by the count of the sample.