2020 Exam Reviewed |Elaborations| FUNDAMENTALS OF DATABASE MANAGEMENT SYSTEMS (IT CIS111 )

2020 Exam Reviewed |Elaborations| FUNDAMENTALS OF DATABASE MANAGEMENT SYSTEMS (IT CIS111 ) The Entity-Relationship (E-R) model is _____. a. a diagramming technique that describes record structures (i.e. the fields that make up the records of a file) b. an alternative to indexing and hashing as a means for providing direct access in files c. a diagramming technique that describes entities, their attributes, and the relationships between them d. an alternative to file design in which attributes are used instead of fields e. a diagramming technique that relates entities to each other, attributes to each other, and relationships to each otherAn association between entities is a(n) _____. a. entity type b. entity occurence c. record d. attribute e. relationshipA binary relationship is a relationship between two _____. a. entity types b. attribute types c. associations d. files e. cardinalitiesThe term “binary” in binary relationship indicates that the relationship is between a. two halves of an entity typeThe cardinality of a relationship is _____. a. The minimum number of entities that can be involved in the relationship. b. The maximum number of entities that can be involved in the relationship. c. The minimum number of attributes that can be in the entity types in a relationship. d. The maximum number of attributes that can be in the entity types in a relationship. e. The minimum number of associations that can be involved in the relationship.The modality of a relationship is _____. a. The minimum number of entities that can be involved in the relationship. b. The maximum number of entities that can be involved in the relationship. c. The minimum number of attributes that can be in the entity types in a relationship. d. The maximum number of attributes that can be in the entity types in a relationship. e. The minimum number of associations that can be involved in the relationship.