, , "" , . . .
, , , . Products (), . . Products Orders (). Orders Shipments (). Customers () Invoices (). Products, Orders, Shipments, Customers Invoices . , (, " (Jane Malone)?" " ?"), .
. , , , .
, . , . , .
. . , - , , .
( ), . -: , .
Dolls, 1 -. Manufacturer (), , . , , , - . , , -, .
, Dolls , . 5.1 ( ).
|
|
5.1.
ID | Character | Manufacturer | Manufacturer-Location | Manufacturer-OpeningYear | Manu-facturer-Lawsuits | Purchase-Price |
Yoda | MagicPlastic | China | No | $8.99 |
, , . , , . ( , . " 3. " 2.) . , (. . " " 3) , .
, , .
, , (. 5.2).
5.2.
ID | Character | Manufacturer | Manu-facturer-Location | Manufacturer-OpeningYear | Manufacturer-Lawsuits | Purchase-Price |
Yoda | MagicPlastic | China | No | S8.99 | ||
Dick Cheney | Rebobbiicans | Taiwan | No | S28.75 | ||
Tiger Woods | MagicPlastic | China | No | $2.99 |
-, ( MagicPlastic), . ( 4 ,
. " 4. " 2.) .
■ MagicPlastic , -. ( ), .
■ - . , , , .
, , , , .
, (, ), Dolls . .
■ ( ), . , - ( , , ).
. - , . . , Dolls, . 5.3, Manufacturers (. 5.4).
|
|
5.3. Dolls
ID | Character | Manufacturer | PurchasePrice |
Yoda | MagicPlastic | $8.99 | |
Dick Cheney | Rebobblicans | $28.75 | |
Tiger Woods | MagicPlastic | $2.99 |
5.4. Manufacturers
ID | Manufacturer | Location | OpeningYear | Lawsuits |
MagicPlastic | China | No | ||
Rebobbitcans | Taiwan | No |
( ). . , - ( ) .
MagicPlastic , Location ,
Dolls. (. 6), . (, , MagicPlastic, , .)
Access , . ( → → (Database Tools →Analyze →AnalyzeTable)) , , . , , .
:
- . . Manufacturer, Dolls, Manufacturers.
, , Manufacturer . . , .
. .
■ Dolls, , (, Yoda ()). Yoda, "MagicPlastic" Manufacturers.
■ Manufacturers, (, Rebobblicans). "Rebobblicans" Dolls.
, , , , .
(ID)
Dolls Manufacturers Manufacturer, -. , . , .
.
■ . , ?
■ , . Dolls, .
, , , , (. . " " 2). , , . , (ID number), Access.
|
|
, . , . . 5.5 Dolls, Manufacturer ManufacturerID.
5.5. Dolls
ID | Character | ManufacturerlD | PurchasePrice |
Yoda | $8.99 | ||
Dick Cheney | $28.75 | ||
Tiger Woods | $2.99 |
Manufacturers (. . 5.4), , 1 MagicPlastic.
. :
■ , Dolls, , ;
Dolls, , .
. Dolls, , ManufacturerlD. ( , . " , " 4. , , , Dolls Manufacturers, . " " .)
- (join query) (. . " " 6). , .
" - "
-, (Dr. Phil). "" "" .
. , , , . ""
. . - . . , Manufacturers -, a Dolls -. "".
" ". . , - , { , ). , -.
|
|
, - - . Dolls , Manufacturers . , " ": . , , .
, , . . - Dolls ManufacturerlD. , Manufacturer .
, , " -" . "--" ( , , ). , . " "--"" " "--"" .
, , Access, (, RDBMS). , .
, Dolls Manufacturers, , , , Access . . . , Access , . ,
. Access , . . . , .
, Bobblehead.accdb, , . Dolls Manufacturers ( ). BobbleheadRelationships.accdb : .
, .
1. , . , .
(, . " " 2). , Manufacturers ID, .
2. . ( .)
Dolls.
. 5.1. Dolls , . ManufacturerlD. , ID Manufacturers. . ( .)
3. -, .
, , -. , . 5.1.
, , . . , ( ). . , , Access . , , ManufacturerlD Dolls.
|
|
4. .
Access . .
5. → → (Database Tools →Show/Hide →Relationships).
Access (Relationships). , . , .
Access , (Show Table), (. 5.2).
. 5.2. . , ( )
6. - -.
. ( ).
, . , .
7. (Close).
(. 5.3). , ""
. 5.3. . , , . (Hide Table).
Access , . .
8. , -. -, .
ManufacturerID Dolls () Manufacturers (). , ID ( Manufacturers) ManufacturerID ( Dolls).
- ( ). Access , .
, (Edit Relationships) (. 5.4).
. 5.4. Access - ( / (Table/Query)) - ( / (Related Table/Query)), . , . - , , ,
9. , (Enforce Referential Integrity). ( .)
, , (, , ). . , .
10. (Create).
, . (. 5.5).
(. 9), Access . , , . , , .
. 5.5. Access , 1 (∞) "--" "" "". . ,
11. . ( │ → →.)
Access , . , . , , , . .
, ( → → ) . .
, , ( ). .
, , . . .
, ( → → ).
( 11 ), , . , , , - .
, :
■ ;
■ | → → (Relationship Tools | Design → Relationships → All Relationships) , , ;
■ , | → → (Relationship Tools │ Design → Relationships → Direct Relationships) , .
, . . , , (Edit Relationship). ( . , .) .
, (referential integrity) , .