AboutScottGem Expertise I have been an IT professional for over 16 years. During that time I have accumulated a large store of knowledge and experience. This allows me to assist with a large variety of technology issues. My specialty is Database design primarily with MS Access. However, I can answer questions on many different IT related topics.
Experience I have worked in IT support for over 16 years. I have also helped people in cyberspace for a good portion of that time. I have been a volunteer staffer on Prodigy and AOL. I was the #2 ranked expert at AskMe.com (#1 in Technology) and am currently ranked at or near the top at Answerway.com and PointAsk.com.
Expert: ScottGem Date: 7/3/2007 Subject: request for help!
Question sir, i have a secnario, i want 2 do normalization and er diagram what i do for that? can u help for create table in
data base?
Answer As far as normalization is concerned, there are many good books and articles on the WEB that explain how to do it. Normalization is a process whereby data tables in a database are designed to eliminate redundancy.
An ER diagram is a visual representation of the tables and their relationships to each other. You can draw such a diagram on paper. There are many software tools that will analyze a database and create such a diagram or allow you to create one by placing objects. Microsoft Visio is an example of one.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
