A shipping company maintains up to date information on processing and location of a shipped item. It relies on an
information system to. Items are characterized by item number, weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received at a retail center. Retail centers are characterized by type, id, and address. They are delivered through one or more standard transportation media.. These can be flights, trucks, etc. They are characterised by schedule number, type and delivery route.
Identify entities, attributes and relationships
Draw ER diagram for the information Map the ER diagram and generate the schema with its data dictionary
Entities are in squares, attributes are in ovals, and relationships are in diamonds.... View the full answer