Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
1. MULTIPLE CHOICE
1. B
2. A
PROBLEMS
1) DISTRIBUTED DATABASES
Chapter 1 Page 2
Mega wants to improve response time by distributing some parts of
the corporate database while keeping other parts of it centralized.
Response:
Commercial Division Database
Customer Table (Commercial customers only. Partitioned by Customer Class)
Sales Invoice (Replicated at Corporate Office)
Inventory Table (Partitioned on Inventory Class)
Vendor Table (Partitioned based on products sold by division)
Purchase Order Table (Replicated at Corporate Office)
Chapter 1 Page 3
Receiving Report Table (Replicated at Corporate Office)
Sales Invoice (AR) (Replicated at Division)
Cash Receipts Table (Centralized at Corporate)
Purchase Order Table (Replicated at Division)
Chapter 1 Page 4
Receiving Report Table (Replicated at Division)
Vendor Invoice Table (AP) (Centralized at Corporate Office)
Cash Disbursement Table (Centralized at Corporate Office)
Description of New Process
The descriptions of the process will vary, however, most of the following key
features should be included in the students’ descriptions:
Chapter 1 Page 5
This system of replicated, centralized and partitioned database tables allows Mega
to process sales locally and quickly and manage billing, AR, Cash receipts, AP and
Cash disbursements centrally, efficiently, and with adequate control.
Chapter 1 Page 6
2. DBMS VERSUS FLAT-FILE PROCESSING
AUGUST 23, 201X
Chapter 1 Page 7
CARLA GLASSER, VP FINANCE
Chapter 1 Page 8
After examining the operations of your organization and deriving a rough-cut
communication. One of the problems that has been brought repeatedly to our
attention, is the need for information by user groups, which is currently kept by
authorized user group may gain access to the data it needs. Further, we see
many inefficiencies in processing data due to data duplication by various
DBMS. This conversion will require that a database administrator be appointed
or hired. A DBMS requires that the central data store be diligently planned,
3. DATABASE DESIGN
Chapter 1 Page 9
Lester’s Rental Solution.
4. DATA NORMALIZATION
Veterinarian practice Solution
Owner Table:
Chapter 1 Page 10
Number (PK)
Name
Name
Patient Table:
Animal Table:
Service/Patient Link Table:
(FK)
Service Table
Chapter 1 Page 11
5. DATABASE DEADLOCK
The example below illustrates how two different transactions are being
processed against the same AR control account within the same time frame.
The individual logic steps are shown in their actual sequence of execution. If no
AR
Control
Time IPU Instruction Sub Acct 1 Sub Account 2 Account
The update process does not reflect the second to last instruction executed.
Deadlock. A deadlock occurs when multiple sites lock out each other. Take for
example, a mail order company in which two customers are processing
transactions simultaneously. Customer 1 wants to order 2 items—Item A and
Chapter 1 Page 12
