48Days.NET

top page logo

Your place for community & resources to find or create work you love

We are so glad you're here and ready to take the next step! We created 48days.net as a place for community. For people to encourage each other and help each other in finding or creating work that is meaningful.

But frankly, we've outgrown it, so we're moving to provide you new resources.

48Days.net will be closing as it is today on November 30, 2017. Until then current members can click the button below to access groups and resources.

If you're new to 48days.net, connect here for a close up look at our thriving 48 Days Eagles Community and to get weekly free resources and motivation as you find and create work you love.

Design Tips That Every DBA Consultant Must Know

If you are involved with the application development projects, database designs can be considered as one of the important factors. Here are some essential tips that every database expert must know.

Avoid The Repetition Of Data: One of the factors that you should look into while handling the database designs is to avoid the repetition of data. For example, the traditional recording of data includes the processing of flat files and the creation of invoice records. So, the invoice records must have fields like, Item3, Item2 or Item1. Therefore, whenever you are observing field names like this, you should definitely create the table separately.

Use Convention Of Names: For avoiding the confusion, the naming convention of the database objects are to be selected and maintained. Consistency is to be maintained for the constraints, columns, tables and other objects in a predictable manner.

Avoid Codes That Are Secret: Field names like, the Customer Type may include values, with a large number of constants that cannot be mentioned anywhere else, within the database. You may start, with only two types of customers at first and the application may change when the third type of customers is introduced. A separate table can be created, which can help in overcoming the constraints of the foreign keys.

Apply Saved Procedures: The DBA consultant can easily use the procedures that were stored previously. When you are using the stored procedures the burden of the SQL programming gets easily reduced. It can also be considered as an efficient method of maintaining the transactions. It also prevents the risks of the injection attacks of SQL.

Use The Right Number Of Tables: While designing the databases, the right number of tables need to be used. The database should contain the exact number of tables required for the applications.

Avoid Redundancy: Data redundancy functions are to be avoided while designing the database tables. The redundant data may corrupt the database and, therefore, should be avoided. For example, you have saved the same customer name in two separate tables. You have updated one table and missed updating the other one. Therefore, the database has become inconsistent in this case.

Keep Away From Nulls: If you allow Nulls, within your database tables; the application programs may get complicated. Therefore you should avoid null by the command NOT NULL. But, when you truly require nulls, you can definitely use them.

Apply Constraints Wisely: Constraints help you in preventing the changes that may violate the consistency. Therefore, you should use them wisely, so that they can be validated, only if the data meets several criteria.

Besides these, you can also use triggers, whenever required. Thus, if you are using the right number of tables by avoiding the redundancy, repetition and the nulls, you can surely design a successful database table. Try applying the stored procedures for your convenience and also avoid the secret codes, if any. You should also remember applying the constraints for preventing the changes that may violate the consistency.

Views: 20

Comment

You need to be a member of 48Days.NET to add comments!

Join 48Days.NET

Coaching Mastery Program

Interested in being a 48 Days Certified Coach?  Check out our elite program here:

Check it out!

Follow 48 Days:

Have a question or want to connect? Enter in some keywords here to see what we're already saying!

Interested in the next step beyond this community - with more hands-on interaction with Dan and other 48 Days Mentors? Check out our new membership site!

Weekly Podcast

Hosted by Dan Miller

Good stuff from 48days

Sign up for the FREE weekly 48 Days Newsletter HERE
Check out Dan's 
daily blog and 
free worksheets
Get the 48 Days App!


 


Have a question or want to connect? Enter in some keywords here to see what we're already saying!

 

© 2017   Created by Jon Dale.   Powered by

Badges  |  Report an Issue  |  Terms of Service