Topic: Databases and Database Objects
1 Design a database to satisfy a collection of requirements
2 Create a Database
3 Create Tables in Datasheet and Design views
4 Add Records to table
The term DATABASE describes a collection of data organized in manner that allows access, retrieval, and use of that data.
A DATABASE MANAGEMENT SYSTEM, Such as access, is software that allows you to use a computer to create a database, add, Change and delete data in a database; ask and answer questions concerning the data in the database; and create forms and reports using the data in the database.
Consists of a collection of tables, each of which contains information on a specific
DATABASE DESIGN GUIDELINES
Database design refers to the arrangement of data in tables and fields.
1 Identify the tables
2 Determine the Primary keys.
Primary key is a unique identifies for records in the table. 3 Determine the additional field.
4 Determine relationships between the tables
5 Determine data types for the fields.]
6 Determine and remove any unwanted redundancy
7 Determine a storage location for the database
8 Determine additional properties for fields
9 Determine the best method for distributing the database objects.
Rows in the table are called records.
The columns in the tables are called fields.
Designing a Database
I. Database Requirements
II. Naming Tables and Fields
Note: No use of special x-cters
III. Determing the primary key.
IV. Determing additional fields.
V. Determing and implementing relationship between the tables. VI. Determing Data type of the fields
VII. Identify and Removing Redundary
ClientsNumber| Clients Name| Street| City| State| Postal Code| BA53| | | Burles| NC| |
BB32| | | Austin| SC| |
BC76| | | Budq| NC| |
CJ76| | | Granger| NC| |...