Databases Reference
In-Depth Information
(c)
What is the defining difference between a centralized and a
distributed data environment?
(d)
Why might it be necessary to include a firewall in the network
deployment?
(e)
What connectivity requirements do you need to configure at the
database server?
(f)
How would your design change if you needed to include data stored
locally on client computers?
(g)
How would your design change if you needed to include data stored
on client computers and a mainframe computer?
2.
You are migrating from a centralized data environment to a distributed
data environment. Each location will need to maintain its own inventory
and employee records. All information, including copies of inventory and
employee information, will be maintained at the main office in Seattle.
(a)
You want to keep storage requirements at each location to a minimum.
How should you do this?
(b)
When will it be necessary to execute transactions as distributed
transactions? Be specific.
(c)
Assuming you choose SQL Server as your database platform, briefly
describe how distributed transactions are processed and the
components involved.
(d)
You deploy the database servers and create the databases at the
remote locations. You need to perform an initial load that creates the
initial tables. How can you use replication to accomplish this?
(e)
Compare the support requirements for allowing inventory updates at
remote sites only or at remote sites and the master copy in Seattle.
(f)
What would be necessary if you want to use centralized administra-
tion for all databases?
