Question

1. Define data dependency, and explain only two reasons why this is undesirable. Explain the solution...

1. Define data dependency, and explain only two reasons why this is undesirable. Explain the solution to this.

2. One of the advantages of a database management system is to provide data independence. Explain this.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1. Data dependency means that one/more attribute uniquely identifies other attributes of a relation. in more simple terms we can say that some data values are dependent on other data values in order to get recognized.

This situation is not desirable because every non-key attribute has to be fully dependent on the PK.

2. One of the highest advantage of databases is data independence. It means we can change the conceptual schema at one level without affecting the data at another level. It also means we can change the structure of a database without affecting the data required by users and programs.

Add a comment
Know the answer?
Add Answer to:
1. Define data dependency, and explain only two reasons why this is undesirable. Explain the solution...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT