WGU C175 Study Notecards questions and answers well illustrated.

WGU C175 Study Notecards questions and answers well illustrated. 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. "A salesperson works in one office." What is the name of this relationship? - correct answers.One-to-one binary relationship "A salesperson sells to many customers." What is the name of this relationship? - correct answers.One-to-many binary relationship "A salesperson is authorized to sell many products, and a product can be sold by many salespersons." What is the name of this relationship? - correct answers.Many-to-many binary relationship What is the positioning and meaning for Cardinality and Modality on an E-R model? - correct answers.Cardinality is the outer symbol; represents the maximum. Modality is the inner symbol; represents the minimum. "A salesperson works in a minimum of one and a maximum of one office, and an office may be occupied by or assigned to a minimum of zero and a maximum of one salesperson." - correct answers.