Entity Relationship Diagram (ERD)
Analyze your database structure
Entity
relationship diagrams(ERD) are a necessary part of all relational database
designs. No matter whether your database is small or large, an ERD will help
you to analyze the relationship of data within your database structure. The ERD
is generally done at an early stage of design for a new process.
An ERD is
basically a relationship of Tables and Fields that outlines the connections of
information. This diagram will help a database administrator to identify
bottlenecks, high-use tables, and ultimately it will help you organize and
optimize your database. This type of analysis will help you to avoid problems
in the future with your database.
Regardless of
whether or not a database consultant or designer presents you with an ERD, all
good design should incorporate this type of report. Do not be shy ask your
designer to provide this report to you. It may cost you to have it prepared,
but in the long run it will be well worth it.
|
Analyze your database structure (Continued)
You can see from the relationship above that the Quality Assurance table is
related to the Employees Table. This will help the designer realize that more
than one employee may be assigned to each quality assurance task. This
information will be critical during the design of a database and it is
necessary to know this before the system is being produced.
Designing
databases using SQL can be both a time consuming and difficult task. It is
generally best left up to professionals and qualified database administrators.
If you have design questions, please don't hesitate to visit our contact us
page. If you are building your own site or want to find out about the services
we offer, please visit our Contact Us page and we
will be glad to help you.
Continue
Learning about System Integration
|