Perfect Pizza is a pizza delivery shop. They make pizzas only for home delivery. They have recently designed a new database to track their sales. They use the customer's tele-phone number for a Key column in the Customer table, They are interested in households, not individuals, They need the street address and zip code for the delivery, They deliver to only three zip codes 98001, 98002, and 98003. With the zip code, they can fill in city and state information later, though they prefer to do it when they enter a new customer. In the Order Detail table, they store the price charged for two reasons: First, it may be different than product price due to1 and second. it keeps a history the record discount Product of or the table, special price. it That doesn't allowance way, affect if the they prices change charged the in price pas in sales. Here is the entity relation diagram for the database

1. What do you think would be the appropriate data types for Customer Phone Key and Customer Zip? Explain.

Answer rating: 100% (QA)

For the Customer Phone Key and Customer Zip fields in the Perfect Pizza database you should choose a... View the full answer