Discussion Topic
This module we reviewed various modeling techniques used in the design and development of database systems. There are a plethora of database design tools on the market to support this process.
Go online and research these tools.
Find an open source (free) database design tool that supports multiple modeling techniques.
Summarize the tool and its capabilities.
We also covered erroneous, inaccurate, and missing data and their impact on data analysis and decision making.
What does the conditioning/scrubbing of data entail?
What are different methods that can be used to accomplish this task?
How can it benefit the data retrieval process?
What are the drawbacks of utilizing these techniques?