3.1. , .
3.2. 3.1 INNER JOIN.
3.3. , .
3.4. , .
3.5. , .
3.6. , . , ( ) .
, SQL, . MS Access (*.mdb), , .
5.1. AS?
5.2. 2.4.
5.3. INNER JOIN?
4. Microsoft Access
MS Access 2 .
Access
MS Access . , , . . .
3.1. . .
3.2. . 1
3.3. ,
3.4. , , .
3.5. , .
3.6. , . .
3.7. .
|
|
3.8. .
3.9. .
3.10. ,
3.11. .
3.12. , .
3.13. . , , , , , . , . , , . . .
3.14. , . .
3.15. . .
3.16. . _.
3.17. . , .
3.18. .
3.19. .
3.20. :
SELECT ., ._ FROM ;
3.21. 2.
3.22. .
3.23. .
3.24. ,
3.25. .
. MS Access (*.mdb), , .
5.1. MS Access . .
5.2. , .
5.3. .
5.4. 2?
5. ERwin
( -, ER-) Computer Associates ERwin 4.0.
|
|
2.1. ERwin 4.0.
2.2. . File/New, Logical/Physical Access 2000.
2.3. , Format / Default Fonts & Colors , Arial CYR.
2.4. , , . Model Explorer Entities New. .
2.5. Entity Properties (Name) (Definition).
2.6. Attributes, , .
2.7. (Definition).
2.8. Key Groups ( ) . _ (Primary Key).
2.9. . , , .
2.10. (relationships) . Model Explorer Entities Child Relationships ( ) New
(parent) , (child) . Non-Identifying.
_ (Foreign Key FK).
2.11. .
2.12. (Verb Phrase). Relationship Properties. Parent-to-Child Child-to-parent , () , .
2.13. Format/Relationship Display Verb Phrase. Format/Entity Display Entity Icon Attribute Icon. :
2.14. .
2.15. . Access . (Physical) .
Tools Forward Engineer / Schema Generation.
Access Schema Generation Generate. Access Connection Admin, Browse *.mdb. Connect.
2.16. *.mdb Access .
3.1. .
3.2. .
[1]