Is it yes or no about the data redundancies?

Question

1.00/5 (1 vote)

See more:

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

Posted 14-Mar-17 15:44pm

Member 13059370

Updated 14-Mar-17 16:22pm

Add a Solution

2 solutions

Solution 1

Quote:
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

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.

Posted 14-Mar-17 16:11pm

Patrice T

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehedi Shams · Accepted Answer · 2017-03-14T16:22:00

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.