tables

  • Thread starter Thread starter fajita
  • Start date Start date
F

fajita

please give me some suggestions on mormalizing my tables.
Here are some of my fields....
Resp Dept, Dute Date, Input Date, Event, Originator, AI
Status, AI Title, AI Descrip, Notes, Linking Doc, Assign
to, Alt Assign to, Action Item # (Primary Key - Auto
number), Priority...
Right now they are all in one table

Thank you muchos!
 
Without knowing anything else about your entity strcture or business model,
I would look at possibly creating separate tables for: originator, AIStatus,
AssignTO, AltAssignTO

Of course, there's no way to tell without more info

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
 
As Kevin already said, it's very hard to make recommendations without
knowing more.

If you already have data in your table, you might try the Table Analyzer
Wizard. Although it's a little weak and sometimes guesses wrong, it might
give you some ideas. It's at: Tools/Analyze/Tables

Bottom line, there's nothing like learning the basics and doing it yourself.

Take a look at
http://support.microsoft.com/defaul...upport.microsoft.com/default.aspx?kbid=289533
and http://support.microsoft.com/default.aspx?kbid=283878 and download the
document at http://support.microsoft.com/default.aspx?scid=kb;en-us;283698.

Last, but not least, I'd recommend getting a copy of "database Design for
Mere Mortals" by Michael Hernandez.

Good luck.

Sco
 
ok tru again to make table "M.L. Sco Scofield said:
As Kevin already said, it's very hard to make recommendations without
knowing more.

If you already have data in your table, you might try the Table Analyzer
Wizard. Although it's a little weak and sometimes guesses wrong, it might
give you some ideas. It's at: Tools/Analyze/Tables

Bottom line, there's nothing like learning the basics and doing it yourself.

Take a look at
http://support.microsoft.com/default.aspx?kbid=289533http://support.microsof
t.com/default.aspx?kbid=289533
and http://support.microsoft.com/default.aspx?kbid=283878 and download the
document at http://support.microsoft.com/default.aspx?scid=kb;en-us;283698.

Last, but not least, I'd recommend getting a copy of "database Design for
Mere Mortals" by Michael Hernandez.

Good luck.

Sco
Click to expand...
 
Back
Top