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 pointReplication GatheringManipulationTransfer
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 pointReplication GatheringManipulationTransfer
Solution
This scenario describes a data replication problem. In the context of databases, replication involves sharing information between different points to ensure consistency. In this case, the point-of-sale systems at the local stores are not replicating, or sharing, their data with 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 the central system is not aware of the sales happening at the local stores.
Similar Questions
A 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 gatheringData replicationData cleaningData 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
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
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
Fill in the blank: Data _____ involves the accuracy, completeness, consistency, and trustworthiness of data throughout its lifecycle.1 pointreplicationmanipulationtransferralintegrity
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.