WGU C724 Unit 4 Questions & Answers Solved 100% Correct!!

What are tuples and how are they used in databases? - Answer-one record or data set in a row. A record in a row or table What is the description of a flat file database? - Answer-single table database What is data integrity? - Answer-data is accurate and consistent through its use and application time A database schema can be represented by which model? - Answer-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? - Answernormalization Why did relational database models replace hierarchical database models in business applications? - Answer-they are simpler table relationships than hierarchical databases What size is big data database considered? - Answer-petabyte Why are data warehouses beneficial to business managers? - Answer-they can be mined or analyzed for trends or patterns What is the definition of data integrity? - Answer-a process to ensure data is not corrupted It is a good practice to _________________ data that is backed up on a regular basis. - Answerreduce Why is it not good practice to perform analytics on an online transaction processing database? - Answer-analytics would affect the database performance What can be used to predict future outcomes or trends, but it does not tell you what will happen in the future? - Answer-predictive analysisWhere would metadata about customer and product tables be stored? - Answer-data dictionary What is data inconsistency - Answer-what happens when the same attribute has different values because the data is stored in more than one location What does classification do? - Answer-loo