You are working as a data engineer at an enterprise that hasmultiple branches across the U.S. The enterprise needs to maintaininformation about the customer of each branch, as well asadministrative information about its offices. Your job is to designa data distribution plan in which each branch can maintaininformation in its local database and its customers but also accesscustomer data from other branches without having to store thatinformation in its local database. In addition, the headquarters ofthe enterprise can maintain administrative information about allthe branches in its enterprise. Assume that your enterprise has twobranches, one in Phoenix and one in Denver.
Using SQL:
You are working as a data engineer at an enterprise that has multiple branches across the U.S. The enterprise needs to m
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am