Data Redundancy and Anomalies

* Describe the data contained in the database.

In the “Customer” database there are ten clients currently being stored with the following information: customer name; customer phone number; customer address; customer zip code; realtors name; realtors’ phone number; and amount paid to the realtor.

In the “Realtor” database there are currently three realtors being stored with the following information: realtors name; realtors’ phone number; realtors address; realtor’s zip code; the year month and date the realtor was hired. Also the realtors current YTD (Year to Date) Sales and YTD pay.

* Describe the tables, fields, and records in the database.

Field is a single item of data Examples:

CUSTOMER |

C_NAME |

Alfred A. Ramas |

|

CUSTOMER |

C_ADDRESS |

21 Tye Rd., Nash, TN |

CUSTOMER |

R_PHONE |

713-228-1249 |

REALTOR |

R_NAME |

Alex B. Alby |

REALTOR |

ADDRESS |

452 Elm, New, TN |

REALTOR |

YTD_SALES |

59386.43 |

Record is collection of related fields Examples:

CUSTOMER |

C_NAME | C_PHONE | C_ADDRESS | C_ZIP | R_NAME | R_PHONE | AMT |

Alfred A. Ramas | 615-844-2573 | 218 Fork Rd., Babs, TN | 36123 | Leah F. Hahn | 615-882-1244 | 100.00 |

REALTOR |

R_NAME | R_PHONE | R_ADDRESS | R_ZIP | HIRED | YTD_SALES | YTD_PAY |

Alex B. Alby | 713-228-1249 | 123 Toll, Nash, TN | 37119 | 01-Nov-2000 | 59386.43 | 7425.65 |

Tables are a collection of related records Examples:

CUSTOMER |

C_NAME | C_PHONE | C_ADDRESS | C_ZIP | R_NAME | R_PHONE | AMT |

Alfred A. Ramas | 615-844-2573 | 218 Fork Rd., Babs, TN | 36123 | Leah F. Hahn | 615-882-1244 | 100.00 |

Amy B. O'Brian | 713-442-3381 | 387 Troll Dr., Fox, KY | 25246 | John T. Okon | 615-123-5589 | 850.00 |

Anne G. Farriss | 713-382-7185 | 2119 Elm, Crew, KY | 25432 | Alex B. Alby | 713-228-1249 | 100.00 |

George Williams | 615-290-2556 | 155 Maple, Nash, TN | 37119 | John T. Okon | 615-123-5589 | 250.00 |

James G. Brown | 615-297-1228...