Database Reference
In-Depth Information
SerialNumber
Make
Model
ProcessorType ProcessorSpeed MainMemory DiskSize
9871234
HP
Compaq Elite 8300
Intel i5-3570S
3.10
4.0 Gbyte
500 Gbytes
9871245
HP
Compaq Elite 8300
Intel i5-3570S
3.10
4.0 Gbyte
500 Gbytes
9871256
HP
Compaq Elite 8300
Intel i5-3570S
3.10
4.0 Gbyte
500 Gbytes
9871267
HP
Compaq Elite 8300
Intel i5-3570S
3.10
4.0 Gbyte
500 Gbytes
9871278
HP
Compaq Elite 8300
Intel i5-3570S
3.10
4.0 Gbyte
500 Gbytes
9871289
HP
Compaq Elite 8300
3.10
Intel i5-3570S
4.0 Gbyte
500 Gbytes
Dell
OptiPlex 9010
3.10
6541001
Intel i7-3770S
8.0 Gbytes
1.0 Tbytes
3.10
6541002
Dell
OptiPlex 9010
Intel i7-3770S
8.0 Gbytes
1.0 Tbytes
6541003
Dell
OptiPlex 9010
Intel i7-3770S
3.10
8.0 Gbytes
1.0 Tbytes
6541004
Dell
OptiPlex 9010
Intel i7-3770S
3.10
8.0 Gbytes
1.0 Tbytes
6541005
Dell
OptiPlex 9010
Intel i7-3770S
3.10
8.0 Gbytes
1.0 Tbytes
6541006
Dell
OptiPlex 9010
Intel i7-3770S
3.10
8.0 Gbytes
1.0 Tbytes
Figure 7-36
WPC COMPUtEr Data
7.61
Define referential integrity actions (such as ON UPDATE CASCADE) for the
COMPUTER-to-COMPUTER_ASSIGNMENT relationship only. Explain the need for
these actions.
7.62
Assume that COMPUTER_ASSIGNMENT in the EMPLOYEE-to-COMPUTER_
ASSIGNMENT relationship is now mandatory (i.e., every employee must have at least
one computer). Use Figure 6-28(b) as a boilerplate to define triggers for enforcing the
required child between EMPLOYEE and COMPUTER_ASSIGNMENT. Define the pur-
pose of any necessary triggers.
Figure 7-37
WPC COMPUtEr_
aSSIGNMENt Data
SerialNumber
EmployeeNumber
DateAssigned DateReassigned
9871234
11
15-Sep-13
21-Oct-13
9871245
12
15-Sep-13
21-Oct-13
9871256
4
15-Sep-13
NULL
9871267
5
15-Sep-13
NULL
9871278
8
15-Sep-13
NULL
9871289
9
15-Sep-13
NULL
6541001
11
21-Oct-13
NULL
6541002
12
21-Oct-13
NULL
6541003
1
21-Oct-13
NULL
6541004
2
21-Oct-13
NULL
6541005
3
21-Oct-13
NULL
6541006
6
21-Oct-13
NULL
9871234
7
21-Oct-13
NULL
9871245
10
21-Oct-13
NULL
Search WWH ::
Custom Search