create a database model consisting of 1) a summary of the relationships between

Question

create a database model consisting of 1) a summary of the relationships between the entities similar to Figure 6-40;

2) 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. Export your Power Architect diagram to a .pdf and attach it to the assignment drop box.

Relationship Child WORK TRANS TRANS Cardinality Parent ARTIST WORK CUSTOMER CUSTOMER CUSTOMER ARTIST_INT Identifying ARTIST Type Nonidentifying 1:N M- Nonidentifying 1:N M-M Nonidentifying 1:N O-C MAX MIN 1:N M-O CUSTOMER ARTIST_INT Identifying 1:N M-O

Explanation / Answer

Please find the answer

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.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.