INMT 342 Topic 3 Conceptual Data Modeling Questions and Correct Answers

Conceptual Data Modeling Process 1. Determine Requirements 2. Examine Business Rules 3. Build conceptual data model Requirements the needs, features, or conditions required for an information system and underlying data. ex. the system shall create and email an electronic receipt when a customer completes an order. ex. the DB shall recorded all of the details about each order, including order ID, products purchased, etc, etc Requirements are determined based on ________ interviews, analysis of documents (e.g. purchase order form), and analysis of business rules. Business Rules statements that define or constrain some aspect of the business and are derived from policies, procedures, events, functions. ex. A student may register for a course only if he/she has successfully completed the prerequisites for the course. ex. A preferred customer qualifies for a 10 percent discount. Entity type collection of entity instances (e.g. city, professor, course, etc.) *strong, weak, or associative Entity instance a single occurrence of an entity type (e.g. Knoxville, Jong Seok Lee, IM342 etc.) Attribute a property or characteristic of an entity or relationship type (e.g. population, time zone, county, etc.) Relationship *Relationship type -- a meaningful association between (or among) entity types ( professor and course)