数据表中从属主题的问题
我正在为一个小型培训组织创建一个数据库，并尝试解决下表的问题
受训者
受训者 ID 、受训者优先、受训者最后、订单名称（可选）、受训者电子邮件、 受训者家庭电话、受训者Mob、受训者StrAddress、受训者城市、 受训者邮政编码、HP、Mod 培训、邮件列表
HP 字段代表健康专业人员，我需要区分表中的组。他们还可以选择进行模块化培训或正常培训。 在这种情况下我应该创建一个子集表，还是有其他解决方案？
另一个问题与邮件列表有关。我需要标记他们是否想出现在订阅者列表中。是否可以在其他表（例如客户）中重复该字段？我不确定这是否有利于数据完整性。
任何帮助将不胜感激， 赞
I'm creating a database for a small training organisation and trying to resolve a problem with the following table
Trainees
Trainees ID , Trainees First, Trainees Last, Order Name (optional), Trainees Email,
Trainees HomeTel, Trainees Mob, Trainees StrAddress, Trainees City,
Trainees PostCode, HP, Mod Training, Mailing list
The field HP stand for Health Professionals and I need to distinguish the group within the table. They also have the option to do either a modular training, or normal.
Should I create a subset table in this case, or is there another solution?
Another issue is related to Mailing list. I need to flag whether they want to be on subscribers list. Is it ok to have the field repeated in other tables such as customers. I'm not sure this will be good for data integrity.
Any help will be much appreciated,
Zan
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
对于第一个问题在这种情况下我应该创建一个子集表，还是有其他解决方案？您不应该创建它，您可以添加或删除更多详细信息以获得您正在搜索的结果。
对于第二个问题是否可以在其他表（例如客户）中重复该字段？可以，这有利于数据完整性，并且可以帮助应用诸如select之类的语句，加入和其他人，但您应该查看是否确实有必要获得您正在寻找的东西。
For the first question Should I create a subset table in this case, or is there another solution? you shouldn’t create it, with the columns that you have you can add or remove more details to obtain the result that you’re searching for.
For the second question Is it ok to have the field repeated in other tables such as customers? It is ok, that is good for the data integrity and it could help to apply statments like select, join and others but you should view if it really necessary to obtain what you’re looking for.