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.
Figure 6-40
entities and attributes to use:
CEREAL_MANUFACTURERS (CMID, CMName, CMHomeState)
PRODUCTS (PID, PName)
INGREDIENTS (IID, IName)
SUPPLIERS (SID, SName, SPhone, SStreet, SCity, SState, SZip)
SUPPLIERS_PRICING (SID, IID, Price, PriceExpires) Note: PriceExpires is a date MM/DD/YYYY.
1. Manufacturer can manufacture many products so the relationship is one to many.
product can have many ingredients so the relationship is one to many.
A product can be supplied by many suppliers and hence it is many to many
pricing of ingrdients depends on suppliers and different supplier supplies different ingredients for the product and price of ingredient is fixed for a particular supplier and hence 1 to many from supplier to supplier pricing
Product has to be manufactured by someone .product cannot exist without manufacture.hence identifying relation. | ||||
ingredients depends on product and hence relation is identifying | ||||
manufacturer is mandatory to produce product hence M:M | ||||
Ingredient is mandatory for a product hence M:M | ||||
supplier is necessary for product .supplier may supply zero product |
Create a database model consisting of 1) a summary of the relationships between the entities simi...
What an Executive Summary Is An executive summary is a specific type of document that does two things: it summarizes a research article, and it offers recommendations as to how information from the article can be used. Some long reports can contain an executive summary section, as indicated in the Pearson handbook. Write a 2 pahe Executive Summary In business contexts, an executive summary is always written for a specific purpose: to explain the information in the article to a...