COMPSCI 1BA3 Chapter Notes -Associative Entity, Data Redundancy, Unique Key
5 Dec 2012
School
Department
Course
Professor
Document Summary
Dbms can be a useful tool only if it"s carefully designed to meet user needs. Identify all the fields needed to produce the required information. Organize each piece of data into its smallest useful part: e. g. , instead of using full name fields store by first and last name fields to make searching easier. Determine each table"s primary key: composite key: two or more fields might be needed to function as the primary key. Include a common field in related tables: use the common field to connect one table logically with another table. Determine the properties of each field: need to identify the properties (characteristics) of each field so. Dbms knows how to sore, display and process the field values. Last step of database design determine which values to assign to the properties. When you select/enter a value for a property, you set the property. You must name each field, table, and other object in an access database.
