WGU C175 Study guides, Class notes & Summaries

Flat Files - CORRECT ANSWER a file having no internal hierarchy Hashed Files - CORRECT ANSWER A file that has been encrypted for security purposes. Heap File - CORRECT ANSWER An unsorted set of records.

WGU C175 FINAL EXAM WITH QUESTIONS AND WELL VERIFIED ANSWERS [GRADED A+] ACTUAL 100% What is a broad definition of data? - ANS---Raw facts that are captured on printed or digital media What are data? - ANS---Facts that are collected and stored in a database system Which is true about flat files? - ANS---They contain no internal hierarchical organization. Which technology has no internal hierarchy? - ANS---Flat files How were data retrieved before database management systems? - ANS---Sequential...

WGU C175 Final+1+2 GRADED A+

WGU C175 Final+1+2 GRADED A+

What is a broad definition of data? - Answer Raw facts that are captured on printed or digital media What are data? - Answer Facts that are collected and stored in a database system What is a determining characteristic of unstructured data? - Answer It does not follow a data model. Which is true about flat files? - Answer They contain no internal hierarchical organization. Which technology has no internal hierarchy? - Answer Flat files How were data retrieved before data...

ad hoc query - Answer A "spur-of-the-moment" question analytical database - Answer A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making availability - Answer In the context of data security, it refers to the accessibility of data whenever required by authorized users and for authorized purposes centralized database - Answer A database located at a single site cloud database - Answer A database that is ...

What is a broad definition of data? - Answer Raw facts that are captured on printed or digital media What are data? - Answer Facts that are collected and stored in a database system What is a determining characteristic of unstructured data? - Answer It does not follow a data model. Which is true about flat files? - Answer They contain no internal hierarchical organization. Which technology has no internal hierarchy? - Answer Flat files How were data retrieved before data...

Entity-Relationship (E-R) model - Answer Diagramming technique for entities, their attributes, and their relationships Association between entities is - Answer Relationship Binary relationship is between two - Answer Entity types "Binary" in binary relationship - Answer two entity types Cardinality of a relationship - Answer Maximum number of entities that can be involved in the relationship Modality of a relationship is - Answer Minimum number of entities that can b...

Flat Files - Answer a file having no internal hierarchy Hashed Files - Answer A file that has been encrypted for security purposes. Heap File - Answer An unsorted set of records. Information - Answer The transformation of raw data into useful facts. Punch Card - Answer A card that is perforated and can hold commands or data. Structured Data - Answer Information with a high degree of organization. Unstructured Data - Answer Information that does not have structure ...

Associative Entity - Answer An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute - Answer An attribute is a property or characteristic of an entity. Binary relationship - Answer A binary relationship is a relationship between two entity types. Candidate Key - Answer Is any column or a combination of columns that can qualify as unique key in database. Cardinality - Answer Cardinality repr...

Associative Entity - Answer An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute - Answer An attribute is a property or characteristic of an entity. Binary relationship - Answer A binary relationship is a relationship between two entity types. Candidate Key - Answer Is any column or a combination of columns that can qualify as unique key in database. Cardinality - Answer Cardinality repr...