You are working as a data engineer at an enterprise that has multiple branches across the U.S. The enterprise needs to m

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

You are working as a data engineer at an enterprise that has multiple branches across the U.S. The enterprise needs to m

Post by answerhappygod »

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:
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply