Skip to main content

Database Anomalies

Let's try and recreate the anomalies found previously, ie: Insertion anomaly, Deletion anomaly, Duplicate entry and Update anomaly

Activity 6

Insertion anomaly

  • A new Unit needs to be added to the database for next year. Add the Unit D76E 34, Maths for Computing 1, 1, O, 7 to the Units table.

Did you encounter any problems inserting this record?

Deletion anomaly

  • Using the query 'Students and Units' note what Units Jane Smith is studying.
  • Jane Smith has decided to leave so delete her record from the Student table.

    Is the record for the Units she was studying still in the query?
    Is the record for the Unit still in the Unit table?

Click on the following link to see one possible solution:

Answer to Activity 6

Next: Activity 7