Database Concepts

Published by Pearson
ISBN 10: 0133544621
ISBN 13: 978-0-13354-462-6

Chapter 2 - The Relational Model - Figure 2-33 - Sample Data for Regional Labs - Page 114: K

Answer

The well formed relations free from modification anomalies are shown in the attached picture.

Work Step by Step

Modification anomalies occur because employee name and salary occurs multiple times against ProjectID.So,we make a separate relation called EMPLOYEE to store name and salary. Additionally assigning every employee an Id to use as foreign key in the PROJECT.
Update this answer!

You can help us out by revising, improving and updating this answer.

Update this answer

After you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.