While the database may be refined several times as the organization evolves, it is critical to understand the company’s end goal and how the database design can help achieve the goal.

The proper implementation of a database is essential to the success of the data performance functions of an organization.

Identify and evaluate at least three considerations that one must plan for when designing a database.

Be sure to respond to at least one of your classmates’ posts.

• Please respond to student’s comment below:
• Hello everyone,

A database is a massive compilation of information to make it intuitive and easy for the user to search for information. The three considerations that an organization must make while designing a database are as follows:

Normalizing data and maintaining consistency – While there may be two types of databases, SQL and NoSQL databases, one clear thing is that they have a complicated structure. It is therefore essential to keep the data normalized and the database structure consistent. Example – Primary keys start with IdTableName, eliminating repeated attributes, etc.

Comprehensive documentation – Another key consideration is ensuring everything is documented for future users. After all, the very purpose of designing a database is with a long-term view of prospective users having the ability to use the database with basic domain knowledge. Documentation can include the database design itself, the entity-relationship schemas, etc.

Emphasis on privacy – Privacy and data integrity go hand in hand, and it is essential to encrypt passwords and provide privacy training to employees before making them, database administrators. If the data integrity is vulnerable to attacks, then there will be an adverse impact on the entire organization.

1. While the database may be refined several times as the organization evolves, it is critical to understand the company’s end goal and how the database design can help achieve the goal.