In database jargon, cardinality refers to the number of associations that can exist between two record types. Identify the three types of relationships that deal with cardinality and explain each one. July 1, 2016 by joyce Question 1 Which term refers to a collection of data fields? Flat file Field Relationship Record 8 points Question 2 Which of these access controls tracks what a user does? Accountability Authorization Identification and authentication Verification 8 points Question 3 When discussing data management tools, which tool is the most versatile for managing simple flat files that involve calculations? Dedicated software Word processing software Spreadsheet software database software 8 points Question 4 In which order is data in a typical database stored? Ascending Descending No particular order Hierarchical 8 points Question 5 Which of the following is an analytical process that allows decision makers to quickly get answers to complex queries that encompass multiple factors, such as locations, revenue, time periods, and employee status? Data mining analytics Online analytical processing (OLAP) Data warehousing Predictive analytics 8 points Question 6 In database jargon, cardinality refers to the number of associations that can exist between two record types. Identify the three types of relationships that deal with cardinality and explain each one. Your response should be at least 150 words in length. Path: p Words:0 20 points Question 7 How does a query language like SQL work? Give brief descriptions of commands, parameters, and record searches. Your response should be at least 150 words in length. Path: p Words:0 20 points Question 8 What kinds of databases track relationships? Give a brief description and the advantages of at least three.
