Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am given a case study of Event Management to develop an ER model and based on it its normalization forms and relational schema. Now i have developed my ER Model based on the SRS that i have developed. Now the question that i am having is when i converted my ER diagram to the relational schema i got my tables already normalized. Because of the ER diagram i had nothing to do more in normalization process so i got confused.

Now the question arose in my mind is whether or not it is desirable situation? I mean when i am getting my all the relations normalized from the ER diagram itself then why do i need to do normalization at all?

share|improve this question
    
Note "normalized" means in 1NF and "fully normalized" means in 5NF or 6NF. –  onedaywhen Oct 19 '11 at 14:31
    
I talking about all kind of normalization. If we get the database already in 5NF from erd then why do we need to think of normalization ? –  ankur.trapasiya Oct 19 '11 at 14:53
add comment

1 Answer

If your tables are already in 5NF then you don't need to think much more about further normalization.

Note however that the principle of full normalization (POFN) is no panacea. There may remain non-obvious update anomalies.

Database constraints will need to be applied. In my experience, designers who start with an ER diagram are great at implementing primary keys and foreign keys but other constraints can be easily overlooked. Other design approaches may result in better constraints e.g. I have a little experience of object role modelling which seemed to work well.

Further normalization should only be considered in conjunction with constraints because 6NF often makes constraints more difficult to implement using today's industrial-strength technologies e.g. none support Standard SQL's CREATE ASSERTION nor CHECK constraints that may include a subquery.

Also consider the principle of orthogonal design (POOD).

share|improve this answer
    
I much prefer ORM to ER modelling because what you get is more complete. See LinkedIn group of you can linkedin.com/groups?gid=1743337&trk=hb_side_g –  gbn Dec 9 '11 at 12:37
    
@gbn: My membership is now pending. Do you use ORM much? –  onedaywhen Dec 9 '11 at 13:25
    
Not as much as I would like. Wrong role currently. I'm doing some in my spare time but I lack a practical "mission" –  gbn Dec 9 '11 at 13:27
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.