数据冗余是肯定还是否？ [英] Is it yes or no about the data redundancies?

问题描述

WID WNAME BRANCHID BRANCHNAME BRANCHSIZE WGENDER WSALARY

1 Dave R Richmond 15 M 50000

2 Sally H Hawthorn 10 F 65000

4 Karen R Richmond 15 F 37000

8 Kim H Hawthorn 10 F 61000

11 Chris R Richmond 15 M 54000



Q1。 BranchID列中的值是冗余数据的示例吗？

Q2。 BranchSize列中的值是冗余数据的示例



我尝试过：



这是一个问是或否的问题没有要求代码或输出。如果是的话，请向我解释，如果不是，为什么呢？非常感谢

WID WNAME BRANCHID BRANCHNAME BRANCHSIZE WGENDER WSALARY
1 Dave R Richmond 15 M 50000
2 Sally H Hawthorn 10 F 65000
4 Karen R Richmond 15 F 37000
8 Kim H Hawthorn 10 F 61000
11 Chris R Richmond 15 M 54000

Q1. Are the values in the column BranchID an example of redundant data?
Q2. Are the values in the column BranchSize an example of redundant data

What I have tried:

its a question that's asking yes or no didn't ask for the code or the output. and please explain it to me if its yes then why if its no and why? thanks a lot

推荐答案

引用：

这是一个问是或否的问题没有要求代码或输出。如果是的话，请向我解释，如果不是，为什么呢？非常感谢

its a question that's asking yes or no didn't ask for the code or the output. and please explain it to me if its yes then why if its no and why? thanks a lot

在SQL 101的第一天，你应该能够自己回答这个问题。你没有跳过课程吗？

从你的问题中，可以推断出你不知道什么是数据库，你需要学习你的课程，或者你需要老师的大力帮助。



我们不做你的HomeWork。

HomeWork不会测试你乞求别人做你的工作的技巧，它会被设定为您可以考虑并帮助您的老师检查您对所学课程的理解，以及您在应用这些课程时遇到的问题。

你的任何失败都会帮助你的老师发现你的弱点并设定补救措施。

所以，试一试，重读你的课程并开始工作。如果您遇到特定问题，请显示您的代码并解释这个问题，我们可能会提供帮助。

Within first day of SQL 101, you should be able to answer this question yourself. Did you skip the course ?
From your question, one can deduce that you have no idea of what is a database, you need to learn your lessons or you need big help from your teacher.

We do not do your HomeWork.
HomeWork is not set to test your skills at begging other people to do your work, it is set to make you think and to help your teacher to check your understanding of the courses you have taken and also the problems you have at applying them.
Any failure of you will help your teacher spot your weaknesses and set remedial actions.
So, give it a try, reread your lessons and start working. If you are stuck on a specific problem, show your code and explain this exact problem, we might help.

您好会员13059370 ，



是的，它们是多余的。在查看您的数据时，BRANCHNAME也是多余的。确切地说，BRANCHID，BRANCHNAME和BRANCHSIZE都是多余的。他们可以移动到不同的桌子，你可以使用相应的ID。



例如：

桌子工作场所

WORKPLACEID-BRANCHID-BRANCHNAME-BRANCHSIZE

1               &NBSP ;       R                 里士满 &NBSP ;         15

2                         H                  Hawthorn            10



您的桌子变为



WID WNAME WORKPLACEID WGENDER WSALARY

1       Dave  ;      1                   &NBSP ;     M                 50000

2      萨利       2                           F                   65000

4      卡伦     1      &NBSP ;                   F      &NBSP ;           37000

8   &n BSP;  金        2              &NBSP ;          F               &NBSP ;  61000

11分配    克里斯      1                           M                54000



请阅读有关数据冗余和规范化的更多信息。

Hi Member 13059370,

Yes they are redundant. And looking at your data, BRANCHNAME is also redundant. To be precise, BRANCHID, BRANCHNAME, and BRANCHSIZE are all redundant. They can be moved to a different table and you can just use the corresponding ID.

E.g.:
Table WORKPLACE
WORKPLACEID-BRANCHID-BRANCHNAME-BRANCHSIZE
1                       R                 Richmond          15
2                       H                Hawthorn           10

And your table becomes

WID WNAME WORKPLACEID WGENDER WSALARY
1      Dave      1                        M                50000
2      Sally      2                         F                 65000
4      Karen    1                         F                 37000
8      Kim       2                         F                 61000
11    Chris     1                         M              54000

Please read more about data redundancy and normalization.

这篇关于数据冗余是肯定还是否？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！