Computer

Only available on StudyMode
  • Download(s) : 98
  • Published : March 12, 2013
Open Document
Text Preview
Computer
Topic: Databases and Database Objects

Objectives:
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

Introduction

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.

Relational database

Consists of a collection of tables, each of which contains information on a specific

Subject
DATABASE DESIGN GUIDELINES
Database design refers to the arrangement of data in tables and fields.

Guard lines
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.

Note:
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

Examples:

ClientsNumber| Clients Name| Street| City| State| Postal Code| BA53| | | Burles| NC| |
BB32| | | Austin| SC| |
BC76| | | Budq| NC| |
CJ76| | | Granger| NC| |...
tracking img