Xem mẫu
Database Design Primer
A Beginners Guide to
Creating a Database
By William Sprouse
CEMML TPS 05-10
CEMML
CENTER FOR ENVIRONMENTAL MANAGEMENT OF MILITARY LANDS Colorado State University Fort Collins, CO 80523-1490
June 2005
Database Design Primer
A Beginners Guide to Creating a Database
By William Sprouse
Center for Environmental Management of Military Lands Colorado State University 1490 Campus Delivery
Fort Collins, CO 80523-1490 (970) 491-2748
This document was produced under the Land Condition Trend Analysis (LCTA) Technical Support for the U.S. Army Environmental Center (AEC) contract; contract number DAAD13-00-D-5003-0041, task order number CS01-SC-03-016.
Table of Contents
1 Introduction ...........................................................................................................................................................1 2 Concepts of Creating a Database...........................................................................................................................1 2.1 Tables..............................................................................................................................................................1 2.2 Relationships...................................................................................................................................................2 2.3 Attributes.........................................................................................................................................................2
3 Creating a Database in Microsoft Access..............................................................................................................3 3.1 Create Tables (Entities) and Their Attributes..................................................................................................3
4 Defining Relationships in Microsoft Access .........................................................................................................7 5 Conclusion...........................................................................................................................................................10 5.1 Introduction to Data Management.................................................................................................................10 5.1.1 LCTA Data Management.....................................................................................................................11
5.2 Further Reading.............................................................................................................................................12 6 References ...........................................................................................................................................................13
...
- tailieumienphi.vn
nguon tai.lieu . vn