Solution 1.doc - Assignment for Module 11 The assignment...

This preview shows page 1 out of 1 page.

Assignment for Module 11The assignment for Module 11 involves problems for falsifying functional dependencies, converting ERDs to table designs, and applying the rules of normalization.1. Requirements for Data Modeling Problems1.You should identify insertion, update, and deletion anomalies in the sample rows of the big patient table shown in Table 1. You should identify one example of each type of anomaly. The combination of VisitNoand ProvNois the only unique column(s) for the table.Table 1: Sample Rows for the Big Patient TableVisitNoVisitDatePatNoPatAgePatCity
End of preview. Want to read the entire page?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
Jane Jordan
Tags
Relational model, Database normalization, relation, deletion anomalies

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture