The Database Design Resource Center

by saji
(mumbai,maharashtra, india)

we have developed a web based application for one of the shipping companies in india. this company get clearences from various bodies for the ship operators to operate in indian waters.
we started designing the database, even befor review they changed the requirements, thus it goes on, we happened to add and remove fields 3 times before we started review of the primary design of the table structure, before normalization.

finaly we went for a tow wise design insted of a column wise design


de defined jobs_attributes table that have id number, field name varhar2 (50), display name varchar2 (50), data type varchar2(50), mandatory_YN char(1), orderby number.

according to the job id we generate the entry screen dynamically through .net and inserted into a table trn_job_data.

now when the data comes inin a huge amount, the system is taking more time to respond while generating design.

this problem was happened because we didnt forseen this problem, and we completely depend on the end user. where there was a very horrible situation of the lack of coordination.

Comments for

Average Rating starstarstarstarstar

Click here to add your own comments

Oct 15, 2015
Good post NEW
by: Nadia McLaughlin

What a great blog you have!
May I ask you to place some ads of my site Halloween Costumes at Costummer, on you blog?
I really love your awesome site and want to offer good money for ads on your site! Please, answer me and let's discuss all the details!

Thank you very much!

Jun 17, 2015
Good post NEW
by: Jennie Schaden

I see that you are a professional in this niche, so, may I ask you do a favor for me?
Could you help me place some ads of my Gunsafesmax on your site?
It will be great if I could suggest some guest posts or banner ads, if it's possible - answer me here, please!
p.s. I will pay for your help good money, I really love your site. Thank you!

Jun 13, 2015
great comments NEW
by: Bonnie

Most writing companies are in constant need of good writers who have a native English speaker. Companies offer online writing are looking for either freelance writers who have essay writing service ranking and knowledge about a practical subjects know the required writing jobs for research.

Jul 13, 2014
forgotten my password NEW
by: Anonymous

I don't remember my password in gmail account.this is my new number/// 9788902269

Mar 10, 2010
Well, well...
by: Alf

Needs to be rethought and rewritten...

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Worst Database Design Experience.

Exclusive interviews with:
Steven Feuerstein, PLSQL expert
Donald Burleson, Top IT consultant

Free eBook

Subscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:

What visitors say...

"I just stumbled accross your site looking for some normalization theory and I have to say it is fantastic.

I have been in the database field for 10+ years and I have never before come across such a useful site. Thank you for taking the time to put this site together."

Mike, USA

Read more Testimonials

Database Normalization eBook:

Database Normalization eBook

Copyright © / Alf A. Pedersen
All rights reserved.
All information contained on this website is for informational purposes only.
Disclaimer: does not warrant any company, product, service or any content contained herein.

Return to top

Copyright acknowledgement note:

The name Oracle is a trademark of Oracle Corporation.
The names MS Access/MS SQL Server are trademarks of Microsoft Corporation.
Any other names used on this website may be trademarks of their respective owners, which I fully respect.