WGU C724 Unit 4 Questions and Answers Solved Correctly

What are tuples and how are they used in databases? - one record or data set in a row. A record in a row or table What is the description of a flat file database? - single table database What is data integrity? - data is accurate and consistent through its use and application time A database schema can be represented by which model? - ERD (entity relationship model) describes the data and map processes to data requirements What takes place during the database design process to eliminate data redundancy? - normalization Why did relational database models replace hierarchical database models in business applications? - they are simpler table relationships than hierarchical databases What size is big data database considered? - petabyte Why are data warehouses beneficial to business managers? - they can be mined or analyzed for trends or patterns What is the definition of data integrity? - a process to ensure data is not corrupted It is a good practice to _________________ data that is backed up on a regular basis. - reduce Why is it not good practice to perform analytics on an online transaction processing database? - analytics would affect the database performanceWhat can be used to predict future outcomes or trends, but it does not tell you what will happen in the future? - predictive analysis Where would metadata about customer and product tables be stored? - data dictionary What is data inconsistency - what happens when the same attribute has different values because the data is stored in more than one location