Q
Problem solve Get help with specific problems with your technologies, process and projects.

Checkpoints of good database design

What are the checkpoints to design a good database?

What are the checkpoints to design a good database?

There are many aspects of database design. This is such a broad topic that it is hard to do it any justice in this venue. As an overview, I give you the following:

  1. When creating your schema, your table should represent real-world entities. The columns of that table are attributes of the entity.
  2. Your schema should be in Third Normal Form (3NF) to stop data anomolies from occuring.
  3. The application's SQL statements and stored procedures should be tuned for optimal performance.
  4. The physical design of the database should take into account security and performance.

I'm sorry that I cannot go much further in answering your question. This is a pretty broad topic.

Dig Deeper on Oracle DBA jobs, training and certification

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close