WGU C175 Study Notecards

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