|
Database Services in Oracle,
MS SQL Server, MS Access, Sybase, Fox Pro
Database Design
The nature and complexity of a database application,
as well as the process of planning it, can vary greatly.
A database can be relatively simple and designed for
use by a single person, or it can be large and complex
and designed, for example, to handle all the banking
transactions for hundreds of thousands of clients.
In the first case, the database design may be little
more than a few notes on some scratch paper. In the
latter case, the design may be a formal document with
hundreds of pages that contain every possible detail
about the database.
Designing a database requires an understanding of
both the business functions you want to model and
the database concepts and features used to represent
those business functions. It is important to accurately
design a database to model the business because it
can be time consuming to change the design of a database
significantly once implemented. A well-designed database
will also perform better.
When designing a database,
we consider:
|
The purpose of the database and how it affects
the design.
|
|
Create a database plan to fit your purpose.
|
|
Database normalization rules that prevent
mistakes in the database design.
|
|
Protection of your data’s integrity.
|
|
Security requirements of the database and
user permissions.
|
|
Performance needs of the application.
|
|
Features that improve performance.
|
|
Achieving a balance between the size of
the database and the hardware configuration.
|
|
Maintenance.
|
|
Estimating the size of a database.
|
|
Importing and Exporting Data
We can easily import data from other applications
or export data to those applications.
|
