实体关系图
我正在尝试创建一个数据库，但在设计过程中。关于所需内容的一些背景知识。我有一个包含大量有关客户的详细信息的表。这是每月从外部 csv 文件导入的。将验证数据，检查电子邮件是否有效，然后复制到结构完全相同但包含有效详细信息（有效电子邮件）的另一个表。
导入的数据来自在线注册（包括姓名、出生日期、电子邮件）表格，客户可以根据预选流派列表的外部数据选择他们最喜欢的流派风格。大约有 11 种流派（也在 csv 文件中）。此外，在导入的客户数据中，还包含每个客户选择的最近购买的杂志。这也来自杂志 csv 文件，其中包含杂志列表和出版商的详细联系信息。
我希望使用这些数据来基于音乐流派和杂志列表之间的客户数据链接，以便第三方供应商可以查看邮件列表和潜在客户。
我附上了 erd 图的 jpg 文件。我无法确保实体之间的链接正确。 http://img718.imageshack.us/i/erd2.jpg/
I'm trying to create a database but in the design process. A bit of background on what is required. I have a table containing a bunch of details concerning customers. This is being imported from an external csv file every month. The data is going to be validated checking the email is valid and then copied to another table in the exact same structure but containing the details that are valid (valid email).
This data being imported is from an online registration (including name, DOB, email) form where customers choose their favourite genre styles based on external data of a list of pre-selected genres. There about 11 genres (also in a csv file). Also in this imported customer data is what each customer has chosen as a recently purchased magazine. This also comes from a magazine csv file with list of the magazines and a contact detail at the publisher.
Using this data I want to based on the customer data link between the music genres and magazine lists for third party suppliers who can view mailing lists and potential customers.
I've attached a jpg file of the erd diagram. I'm having trouble make sure the links between entities are correct. http://img718.imageshack.us/i/erd2.jpg/
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我认为你走在正确的道路上。
可以表示为
杂志也一样
I think you're on the right track.
which can be represented as
and same thing for magazines