A retailer keeps data in point-of-sale systems at its 10 local stores and an inventory management system at its central warehouse. When purchases are made at a store, they are only recorded in the point-of-sale systems. As a result, the inventory records are inaccurate and stores often run out of inventory. What data integrity problem does this scenario describe?1 pointTransferReplication ManipulationGathering
Question
A retailer keeps data in point-of-sale systems at its 10 local stores and an inventory management system at its central warehouse. When purchases are made at a store, they are only recorded in the point-of-sale systems. As a result, the inventory records are inaccurate and stores often run out of inventory. What data integrity problem does this scenario describe?1 pointTransferReplication ManipulationGathering
Solution
The data integrity problem described in this scenario is Replication. This is because the data from the point-of-sale systems at the local stores is not being replicated or copied to the inventory management system at the central warehouse. As a result, the inventory records are not updated in real-time and are therefore inaccurate. This leads to stores often running out of inventory because they are not aware of the current stock levels.
Similar Questions
Question 2A company has multiple retail chain stores. Each store’s database is located onsite and used for various purposes. Which of the following processes could compromise data integrity?1 pointData replicationData cleaningData transferData gathering
Question 2A healthcare provider stores data in patient portals at multiple clinics and its billing system at headquarters. When a doctor makes a change to a patient's medication in the portal, the change is not reflected in the billing system. This leads to patients being billed for the wrong medications. What data integrity problem does this scenario describe?1 pointGatheringManipulationReplication Transfer
A junior data analyst copies data from one computer to another over their company network. The network connection goes down during the process, which results in an incomplete copy of the data. What data integrity problem does this scenario describe?1 pointCleaningReplicationManipulationTransfer
When merchandise is sold, stores compile data about the purchase. Then the data is entered into a huge database known as a(n) Blank______.Multiple choice question.UPC code systemcash registerRFID systemdata warehouse
Question 4What is the process of tracking changes, additions, deletions, and errors during data cleaning? 1 pointCatalogingDocumentationRecordingObservation
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.