CBIS 3210 Test 2 Questions with Answers

CBIS 3210 Test 2 Questions with Answers Entity Relationship Diagram (ERD) - Answer-A detailed, logical, and graphical representation of the entities, associations, and data elements for an organization or business ERD Terminology - Answer-Entity Attribute Primary Key Relationship Cardinality Maximum Cardinalities - Answer-Maximum of instances that are allowed, largest number of rows in the table ERD Notation - Answer-Crow's Foot Notation ERD Design Guidelines - Answer-Avoid use of ambiguous names Be consistent in terminology Verify if all assumptions are satisfied and write assumptions you make while drawing the ERD Entity - Answer-A person, place, object, event or concept in the user environment about which the organization wishes to maintain data Attribute - Answer-A named property or characteristic of an entity that is of interest to an organization Primary Key or Identifier - Answer-An attribute (or combination of attributes) that uniquely identifies each instance of an entity type Relationship - Answer-An association between the instances of one or more entity types that is of interest to the organization