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
| Clients Name
| Postal Code
Please join StudyMode to read the full document