5 When would using a personal DBMS make sense When the connection to a network

5 when would using a personal dbms make sense when

This preview shows page 1 - 2 out of 2 pages.

5. When would using a personal DBMS make sense?When the connection to a network got discontinued, or working on a small database.6. What is the difference between a spreadsheet and a database? List three differences between them.A database handles with many types of data and connects them together, a spreadsheet does not use a query language while a database does, and a spreadsheet holds less data compared to a database.7. Describe what the term normalization means.To be designed to lower the duplication of data between tables and make the table flexible.8. Why is it important to define the data type of a field when designing a relational database?So that way there is enough storage space for the data.9. Name a database you interact with frequently. What would some of the field names be?Microsoft excel would be one, field names can be Integer, Decimal, Date.10. What is metadata?Metadata is the data that describes other data.
11. Name three advantages of using a data warehouse.Data warehouse provides tools to combine data, with a data warehouse you can see trends with snapshots, and data warehouse allows all the data collected in the enterprise to be visible.12. What is data mining?Data mining is analyzing data to make a decision.ExerciseDo some original research and find two examples of data mining. Summarize each example and then write about what the two examples have in common.Two examples of data mining is service providers and retail stores. Service provider because they will use data mining to see what trending or what the customer wants. Retail stores because they will data mine for the best prices or what sells a lot so they can sell more. What these two have in common is that they both mine for data to see the trend so they can provide the customers with that item.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture