Question
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.
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.
Step by Step Solution
3.43 Rating (156 Votes )
There are 3 Steps involved in it
Step: 1
For the Customer Phone Key and Customer Zip fields in the Perfect Pizza database you should choose a...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started