We help IT Professionals succeed at work.

how to create a table out of this info

pardeshirahul
on
How to go about and create a table based on the information from screenshot for shipment rate to hawai and alaska
Rates-Guide-2011-045.png
Rates-Guide-2011-046.png
Rates-Guide-2011-047.png
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
I'm not understanding your question.

Are you looking for design help?

If so, I might go with:

package_type number,
weight number,
ship_to_zone number,
priority number

then cross-reference tables for the package types and shipping prioritys.

Author

Commented:
i could'nt understand
based on the screen shots i have to create a table and insert the data in that table it can be a master and detail table joined by primary keys if needed
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
>>i have to create a table and insert the data in that table

I gave my suggestion of a design.

The lookup tables would be simple:

package_types
-------------------------------------------
package_type_id number,
package_type_desc varchar2(255)

priority
--------------------------------------------
priority_id number,
priority_desc varchar2(255)

Author

Commented:
and what about the weights and price
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
oh, forgot price.  add that to the main table description in http:#a37070493

weight is in that example table.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.