designing a relational database? 9. Name a database you interact with frequently. What would some of the field names be? 10. What is metadata? 11. Name three advantages of using a data warehouse. 12. What is data mining? 13. In your own words, explain the difference between supervised learning and unsupervised learning. Give an example of each (not from the book). Exercises 1. Review the design of the School database earlier in this chapter. Reviewing the lists of data types given, what data types would you assign to each of the fields in each of the tables. What lengths would you assign to the text fields? 2. Download Apache OpenOffice.org and use the database tool to open the “Student Clubs.odb” file available here. Take some time to learn how to modify the database structure and then see if you can add the required items to support the tracking of faculty advisors, as described at the end of the Normalization section in the chapter. Here is a link to the Getting Started documentation. 3. Using Microsoft Access, download the database file of comprehensive baseball statistics from the website SeanLahman.com. (If you don’t have Microsoft Access, you can download an abridged version of the file here that is compatible with Apache Open Office). Review the structure of the tables included in the database. Come up with three different data-mining experiments you would like to try, and explain which fields in which tables would have to be analyzed. 4. Do some original research and find two examples of data Information Systems for Business and Beyond (2019) pg. 87
Made with FlippingBook flipbook maker