表设计 [英] Table Design

问题描述

所以我正在申请制作有关银行审核的审核计划问卷。 到目前为止，我有审计域，审计区域和问题的表格。 域的示例可能是"逻辑安全"，审计
区域可能是"使用密码"。 在问题表中，我有以下字段：

• ID - 主键的自动编号字段
• Printorder - 用于定义打印的数字字段表单和报告上的顺序
• 问题 - 问题本身的长文本字段
• Origin - 用于记录在程序中提出问题的理由的简短文本字段。  ;例如，可能会问一些问题，因为它们只是具有良好的商业意义或是预期的经营方式。 但是，可能会询问其他
  的问题，因为具体的法规要求银行执行问题所指的事情。 例如，如果法规"2016-94 par.3"要求银行拥有至少10个字符的密码，那么我想在我们的审计程序中记录
  ，这是此问题背后的支持性规定。

当我有一个问题但有多个法规支持该问题时，我的问题就出现了。 我怎么去把它放进我的桌子？ 如果我有固定数量的监管来源，比如3，那么我可以为三个法规中的每个
单独执行一个字段，并使用是/否样式来表明是否支持该问题，但是法规可能会有所不同，因此无效。 我是否应该有一个单独的表并在那里输入规则，然后使用连接表将它们分配给问题
？

任何帮助都将不胜感激。

解决方案

你好jdmcleod，



根据你的描述，我建议你可以参考
数据库设计基础来创建一个设计合理的数据库。



另外你可以参考
表格关系指南



感谢您的理解。

So I have an application I am working on for generating audit program questionnaires on bank audits.  I have tables for the audit domain, the audit area and the questions so far.  An example of a domain might be "Logical Security" and the audit area might be "use of passwords".  In the questions table I have the following fields:

• ID – autonumber field for primary key
• Printorder – numeric field to define the print order on forms and reports
• Question – long text field for the question itself
• Origin – short text field designed to be used to document the rationale for having the question in the program.  For example, some questions may be asked because they just make good business sense or are an expected way of doing business.  Other questions, however, may be asked because a specific regulation requires the bank to do the thing the question is referring to.  For example, if regulation "2016-94 par.3" requires the bank to have passwords of at least 10 characters, then I want to document in our audit program that this is the supporting regulation behind this question.

My problem comes in when I have one question but multiple regulations that support that question.  How would I go about entering this into my table?  If I had a fixed number of regulation sources, say 3, then I could do a separate field for each of the three regulations and use a yes/no style to indicate if that was supporting the question or not, but the regulations can vary so that won’t work.  Should I have a separate table and enter in the regulations there and then assign them to the questions using a join table?

Any help would be appreciated.

解决方案

Hi jdmcleod,

According to your description, I suggest that you could refer to Database design basics to create a properly designed database.

In addition you could refer to Guide to table relationships

Thanks for your understanding.

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