WGU C175 Final Exam QUESTIONS WITH ANSWERS 2022

Flat Files - a file having no internal hierarchy Hashed Files - A file that has been encrypted for security purposes. Heap File - An unsorted set of records. Information - The transformation of raw data into useful facts. Punch Card - A card that is perforated and can hold commands or data. Structured Data - Information with a high degree of organization. Unstructured Data - Information that does not have structure (such as text) Binary Relationship - A relationship between two entity types. Unary Relationship - An associate occurrence of an entity type with other occurrences of the same entity type. Cardinality - The maximum number of entities that can be involved in a particular relationship. E-R Model *E-R = Entity - Relationship - Diagram of entities together with their attributes and the relationship among them. Intersection Data - It is data that describes a many-to-many relationship. Modality - It is a minimum number of entity occurrences that can be involved in a relationship. One-to-one Binary Relationship - It means that a single occurrence of one entity type can be associated with a single occurrence of the other entity type and vice versa. Ternary Relationship - Involves three different entity types. Unique identifier - It is used to uniquely identify each record in a database table. Attribute - A property, characteristic, or fact that we know about an entity. "A salesperson works in one office."