Database design basics
A properly designed database provides you with access to up-to-date, accurate information. Because a correct design is essential to achieving your goals in working with a database, investing the time required to learn the principles of good design makes sense. In the end, you are much more likely to end up with a database that meets your needs and can easily accommodate change.
This article provides guidelines for planning a database. You will learn how to decide what information you need, how to divide that information into the appropriate tables and columns, and how those tables relate to each other. You should read this article before you create your first database.
In this article
Some database terms to know
What is good database design?
The design process
Determining the purpose of your database
Finding and organizing the required information
Dividing the information into tables
Turning information items into columns
Specifying primary keys
Creating the table relationships
Refining the design
Applying the normalization rules
Some database terms to know
Microsoft Office Access 2007 organizes your information into tables: lists of rows and columns reminiscent of an accountant’s pad or a Microsoft Office Excel 2007 worksheet. In a simple database, you might have only one table. For most databases you will need more than one. For example, you might have a table that stores information about products, another table that stores information about orders, and another table with information about customers.
A properly designed database provides you with access to up-to-date, accurate information. Because a correct design is essential to achieving your goals in working with a database, investing the time required to learn the principles of good design makes sense. In the end, you are much more likely to end up with a database that meets your needs and can easily accommodate change.
This article provides guidelines for planning a database. You will learn how to decide what information you need, how to divide that information into the appropriate tables and columns, and how those tables relate to each other. You should read this article before you create your first database.
In this article
Some database terms to know
What is good database design?
The design process
Determining the purpose of your database
Finding and organizing the required information
Dividing the information into tables
Turning information items into columns
Specifying primary keys
Creating the table relationships
Refining the design
Applying the normalization rules
Some database terms to know
Microsoft Office Access 2007 organizes your information into tables: lists of rows and columns reminiscent of an accountant’s pad or a Microsoft Office Excel 2007 worksheet. In a simple database, you might have only one table. For most databases you will need more than one. For example, you might have a table that stores information about products, another table that stores information about orders, and another table with information about customers.
Images
Images
Images
Images
Images
Images
Images
Images
Images
Images
Images
No comments:
Post a Comment