The Database Design Resource Center

The worst database as my prespective

by mahmoud helmy mahmoud
(Giza,Cairo,Egypt)

I think that the worst database is which that has redundant data
which lead to increase the database size and decrease the performance

______________________________________________________________________________________

what leads to redundant data ?

There are many causes that lead to redundant data such as taking the foreign key as many attributes from another table without needing that
for example

suppose we have the tables

1- Employee(ID,Name,Salary,DeptID) // DeptID attribute is foreign key and it is sufficient to make a relation

2- Department(ID,Name,Position)


some one may do this bad design of entity(table)
1- Employee(ID,Name,Salary,DeptID,DeptName) // the value of DeptID may be existed many time,
and due to this DeptName will be repeated without any need
2- Department(ID,Name,Position)
this bad design leads to increase the size of the database and decrease the quality


______________________________________________________________________________________

Thanks in advance
ma7moud_7elmy@yahoo.com

Comments for The worst database as my prespective

Average Rating starstarstarstarstar

Click here to add your own comments

Nov 09, 2016
Rating
starstarstarstarstar
Great NEW
by: assignment writing help

Good one I like your post.

Nov 06, 2015
Rating
starstarstar
database is compromise NEW
by: Melodyze

You are right. This is always the case where the database is compromise and will become very slow to access.

how to buy twitter favorites
buy twitter followers

Oct 12, 2015
Rating
starstarstarstarstar
RE: NEW
by: John Sanford

This having an effect far and wide, numerous calling it a wonder and one of the foreign key as many attributes from another table without needing that noteworthy accomplishments. For more information visit now at : DissertationMall |I want to write a dissertation that's really a good news for the student for any-kind of education help just visit.


Oct 09, 2015
Rating
starstarstarstarstar
RE: NEW
by: Kevin Reid

The PHP code is unable to connect to the database. I'm using "localhost" (which is what phpMyAdmin shows), I've double-checked and double-set the password, and help to order dissertation and ensured that username and database names are correct (including prefix with underscore). I've even given the database user all privileges for the purpose of troubleshooting.

Sep 18, 2015
Rating
starstarstarstarstar
The worst database as my prespective NEW
by: Anonymous

I feel that I must keep in touch with your website because here I saw numerous posts which as I really motivated. So now own words I have made my mind to visit on your site in a week. Through which I have to got some helpful thing for my project write my essay - gethomeworkonline.com. So over all I enjoyed in your archive and I will keep coming here.

Sep 17, 2015
Rating
starstarstarstarstar
I build and order form design NEW
by: Anonymous

I build and order form design in PHP to use that form I connect it to database I use local hosting provider service my site name college assignment help the form got no support for asp but supports PHP, JavaScript and others the problem is whenever I click order now I got an error "database not supported "m totally confuse what can I do please help

Jun 17, 2015
Rating
starstarstarstarstar
Education NEW
by: Anonymous

Skills are present in student but school as institution help someone for polish its abilities for best possible results which i always buy essays online at www.ukbestessays.net and one can show from his character .Education helps to utilize hidden skills.

Jun 17, 2015
Rating
starstarstarstarstar
Good post NEW
by: Keshaun Cummerata PhD

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 wedding-max.com 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!

Mar 10, 2010
Rating
starstarstarstarstar
At the corde of denormalization
by: Alf

Yes, indeed, you are at the core of breaking normalization rules. Glad you understand it.

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 © www.databasedesign-resource.com / Alf A. Pedersen
All rights reserved.
All information contained on this website is for informational purposes only.
Disclaimer: www.databasedesign-resource.com 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.