Question: (25 points) Draw the data model for the following freight table taken from a mail order catalog. Be sure to indicate the primary key and
- (25 points) Draw the data model for the following freight table taken from a mail order catalog. Be sure to indicate the primary key and foreign keys in the model. Use Visio or another ER modeling tool to solve this problem. Copy the solution and paste it into this document.
| Amount of Order | Regular Delivery 7-10 Days | Rush Delivery 4-5 Business Days | Express Delivery 1-2 Business Days |
| $0 to $15.00 | $4.95 | $9.95 | $17.45 |
| $15.01 to $30.00 | $5.95 | $10.95 | $18.45 |
| $30.01-$45.00 | $7.95 | $12.95 | $20.45 |
| $45.01-$65.00 | $9.95 | $14.95 | $22.45 |
| $65.01-$90.00 | $11.95 | $16.95 | $24.45 |
| $90.01-$125.00 | $13.95 | $18.95 | $26.45 |
| $125.01-$200.00 | $14.95 | $19.95 | $27.45 |
| $200.01 + | $16.95 | $21.95 | $29.45 |
2. (15 points) Create the database designed in answer to question 1. Create the table in the database you use and copy and paste the table creation script here.
3. (10 points) Populate the database created in answer to question 2. Populate the table in the database you use and copy and paste the table insertion script here. Your data should match that provided in the chart above.
I NEED HELP WITH PART 2 and 3
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help