5. Read the given business scenario and walk through the steps below.

Im the owner of a small gardening store. We have over 200 flowers/plants that we need to keep track of in our inventory.

Each of our flowers have a unique product ID. For each flower, we need to know its name, type (annual, perennial, etc.) quantity, growing preference (sun, shade, partial sun, etc.) and color. (Lantana yellow, Petunia - purple).

Yes, we do have multiple pots/containers of each of our flowers/plants.

We give each flower a specific ID, and then track which flowers are sold.

a. Write a list of nouns used in the scenario.

b. Name each entity.

c. Is each instance of the entity uniquely identifiable? Which attribute or attributes could serve as the unique attribute to identify the entity?

Section 2 Lesson 3: Entity Relationship Modeling and ERDs

1. True or False: To be described as implementation-free, a data model must be changed to accommodate the database system onto which it is built.

2. True or False: To be described as implementation-free, a data model must not change to accommodate the database system onto which it is built.

3. List four goals of entity relationship modeling.

4. An __________ is a consistent tool that can be used to represent data requirements regardless of the type of database used