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