Tip

Key database design concepts

This excerpt from Teach Yourself Database Design focuses on some basic concepts associated with the database design

    Requires Free Membership to View

process. Before a design effort can proceed full speed ahead, the designer must first take time to understand the business. Understanding the business involves understanding the entities, data, and rules within an organization, and then converting these attributes of the business into a business model. Then, the designer must have a solid comprehension of the proposed database model. Finally, the designer will convert the business model into a database model, using a design methodology, whether automated or a manual process.

The following subsections briefly describe these topics: design methodology, converting the business model to design, and application design.

 

Design Methodology

A design methodology is the approach taken toward the design of a database. It is the process of designing a database with a sound plan from the beginning. For individuals lacking the proper knowledge and experience, designing a database probably involves a great deal of trial and error. If an individual understands database fundamentals and design concepts, the basic steps of the database design process, and has a structured plan (has selected a design methodology), the design process should produce a quality product to the customer.

Some of the advantages of using a design methodology include:

  • It provides a step by step guide toward database design.
  • Little or no trial and error is involved.
  • It is easy to document the database and application with the availability of design plans, drawings depicting the organization's needs, and other deliverables specified.
  • It is easy to modify the database in the future as organization and planning eases the tasks of managing changes.

 

Converting the Business Model to Design

Database design is the process of converting business objects into tables and views. It is the process of actually designing a database based on a business model. Business model components such as entities and attributes are converted into tables and columns. Constraints are added to columns where necessary in order to enforce data and referential integrity. Views of tables might be created in order to filter the data that a user sees, or to simplify the query process. After the design of a database is complete, the entire business model (business processes, rules, and entities) will have been converted into a functional database in which corporate data can be stored, modified, and easily retrieved.

 

Application Design

Application design is the process of creating an interface for the end user through which the database can be accessed. It is the process of transforming business processes that have been defined into a usable application through which the end user can easily access information in the database. A typical application might consist of a set of forms that allow the end user to create new records in the database, update or delete existing records, or perform queries. The application might also include canned queries and reports. Common tools used to develop an application include Oracle Designer, Oracle Developer/2000, Visual Basic, C++, and PowerBuilder. Application design, although an essential part of the overall design process, is out of the scope of this book. This book focuses on the database design process versus application design--although the design of an application is an integral supplement to the database itself.

 

For More Information


This was first published in April 2001

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.