Topics: Database, SQL, Relational model Pages: 3 (470 words) Published: March 12, 2013
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.

Relational database

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

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.

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| |...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • PROPOSAL Essay
  • Intro to Computers Essay
  • Uses of Computers Essay
  • Online Computer Aided Survey Essay
  • Computer and Points Received Essay
  • The rapid growth of computers in field of technology Research Paper
  • Databases Is a Structured Collection of Data or Records Stored on a Computer System. Essay
  • Water Billing System Essay

Become a StudyMode Member

Sign Up - It's Free