Realtor Database: Data Redundancy and Anomalies
Conduct an in-depth examination and analysis of the database, Week1_Realtor.mdb (Download Here). Apply the concepts of database systems that you have learned this week.
For example, you may want to include a definition and analysis of these concepts:
Describe the data contained in the database. Describe the tables, fields, and records in the database. Describe the keys, indexes, and relationships in the database. Identify data redundancy and describe potential solutions. Identify data anomalies and describe potential solutions. Identify fields containing more than one item of data and describe potential solutions. Identify other design concerns and describe potential solutions.
The document should be written in Microsoft Word. The format should be APA style, double-spaced, and sufficient length to thoroughly complete the assignment (usually 2-3 pages). Be sure to cite your sources. Your final submission will be a Microsoft Word document.
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 | 21 Tye Rd., Nash, TN | 37118 | Leah F. Hahn | 615-882-1244 | 120.00 |
| Kathy W. Smith | 615-894-2285 | 125 Oak Ln, Babs, TN | 36123 | Leah F. Hahn | 615-882-2144 | 150.00 |
| Leona K. Dunne | 713-894-1238 | Box 12A, Fox, KY | 25246 | Alex B. Alby | 713-228-1249 | 250.00 |
| Myron Orlando | 615-222-1672 | Box 111, New, TN | 36155 | Alex B. Alby | 713-228-1249 | 100.00 |
| Olette K. Smith | 615-297-3809 | 2782 Main, Nash, TN | 37118 | John T. Okon | 615-123-5589 | 500.00 |
| Paul F. Olowski | 615-894-2180 | 217 Lee Ln., Babs, TN | 36123 | Leah F. Hahn | 615-882-1244 | 300.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 |
| John T. Okon | 615-123-5589 | 452 Elm, New, TN | 36155 | 15-Jun-2005 | 98762.25 | 12553.52 |
| Leah F. Hahn | 615-882-1244 | 334 Main, Fox, KY | 25246 | 23-May-1986 | 37874.24 | 2943.65 |
