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

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.

Is it yes or no about the data redundancies?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Is it yes or no about the data redundancies?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us