访问关系 [英] access relations

问题描述

我只是想知道是否有人可以就此提出建议。

我有一个带有两个表的访问数据库。一个登录用户，另一个用户可以修改许多字段。这些由userid与一对一关系链接。第一个表中的用户标识是自动数字，下一个表中的用户标识是数字。第二个也有一个名为profileid的主键。我想把第二个分成更小的表，因为它太大了。


问题是我是否从第二个表链接到我将由userid创建的其他表格关系一对一，或者通过配置文件ID作为主键？

任何建议都将不胜感激。

谢谢

Richard

Hi, I just wonder if anyone can advise about this.
I have an access database with two tables. One logs in a user and in the other the user can modify many fields. These are linked by userid with a relation one to one. The userid in the first table is autonumeric and in the next table is number. The second has a principle key called profileid too. I want to break up the second into smaller tables as its getting too big.

The question is do I link from the second table to the other tables I will create by userid and with a relation one to one, or by profile id as thats the principle key?
Any advise would be greatly appreciated.
Thanks
Richard

推荐答案

你的第二张桌太大了，你打算如何分手呢？

What about your second table is too big, and how do you plan to break it up?

我的建议不是打破它（从你到目前为止所说的话）。


也许如果你能解释你的问题（你认为拆分表会有所帮助），我们可以看看更实用的替代方案。


请查看规范化和表格结构，以便更好地了解您可能遇到的麻烦你自己。

My advice would be not to break it up (from what you''ve said so far).

Maybe if you can explain your problem (that you think splitting the table will help with), we can look at more practical alternatives with you.

Please check out Normalisation and Table structures for a better understanding of the sort of trouble you could be letting yourself in for.

感谢你的回复以及我将要研究的规范化链接。好吧，我之前已经读过一个表不应该有超过30个字段，我认为我应该拆分的字段可能达到80.因为会有用户更新和删除，虽然我没有设想超过400个用户，我认为它可能虽然我可能完全错了，但要处理得太多了。

再次感谢任何建议。

Richard

Thanks for both replies and also the normalisation link I will look into. Well I have read before that a table shouldnt have more than 30 fields and the one I thought I should split might get up to 80. As there will be users updating and deleting, although I dont envisage more than 400 users, I thought it might be too much to handle, although I might be completely wrong.
Thanks again fo any advice.
Richard

这篇关于访问关系的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！