Section 2 Lesson 1: Conceptual and Physical Models

1. List five reasons for building a conceptual data model

Section 2 Lesson 2: Entities, Instances, Attributes, and Identifiers

1. Name two volatile attributes.

2. Name two non-volatile attributes.

3. Identifying Attributes for Entities.

The three entities that play a role in a florist business: PRODUCT, CUSTOMER, and VENDOR are listed as the first three column headings of the table below. The fourth column contains a collection of attributes. Indicate if the attribute listed could be an attribute for the entities listed. (For example, could Price be an attribute for PRODUCT, CUSTOMER or VENDOR?

PRODUCT	CUSTOMER	VENDOR
			Product ID
			Order ID
			Price
			First Name
			Phone Number
			Quantity
			Last Name
			Vendor ID
			Type
			Customer ID
			Color
			Address