You are analyzing a table within a database that manages inventories of office supplies. The table you are analyzing, tblReceivedSupplies, is used to track the arrival of new supplies. You notice the fields SupplyID, SupplyName, Date, and Quantity all existing within the table. In order to meet the criteria for the 3NF, which of these nonkey fields would need to be deleted and why? What other
table should exist to meet the criteria for normalization?
What will be an ideal response?
The field SupplyName would have a transitive dependency on the SupplyID field. If the SupplyID field changed, so would the SupplyName field. The field SupplyName should be removed from the tblReceivedSupplies table. If it does not exist already, a table storing all SupplyID's and SupplyName's should be created to maintain this data. This would meet the criteria for 3NF.
You might also like to view...
If the source file contains heading styles, the slides will be created using the headings present in the file
Indicate whether the statement is true or false
You type the following words on a screen: GO LADY VOLS! If the processor handles 32 bits at a time, what letters are input to the processor simultaneously?
A) G B) GO C) GO L D) GO LA E) GO LADY VOLS!