View the step-by-step solution to:

Question

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

Top Answer

Entities are in squares, attributes are in ovals, and relationships are in diamonds.... View the full answer

Screen Shot 2020-01-02 at 10.38.10 PM.png

Dimensions
Insurance
Amount
Weight
Destination
Item Number
Item
Final Delivery
Date
Recieved at
Delivered through
Type
Delivery Route
Retail Center
Transportation
Media
ID
Address
Schedule
Type
Number

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question