Create a crow's foot ER diagram for the design using Power Architect. Reminder: a crow's foot ERD does not contain primary keys, foreign keys, or intersection relations

entities and attribute

CEREAL_MANUFACTURERS (CM_ID, CM_Name, CM_HomeState)

PRODUCTS (P_ID, P_Name) INGREDIENTS (I_ID, I_Name)

SUPPLIERS (S_ID, S_Name, S_Phone, S_Street, S_City, S_State, S_Zip)

SUPPLIERS_PRICING (S_ID, I_ID, Price, Price_Expires) Note: Price_Expires is a date MM/DD/YYYY

if a value consists of numerals, but is not used in arithmetic calculations (for example, a zip code or a phone number) then it should be defined as CHAR or VARCHAR2, rather than a NUMBER

Power Architect is used to design databases that can be compiled into the syntax of a variety of products. Therefore, its attribute data types are generic. Use VARCHAR for VARCHAR2 and NUMERIC for NUMBER.