Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Materials Management

Authors: Arnold J. R. Tony, Gatewood Ann K., M. Clive Lloyd N. Chapman Stephen

8th edition

9386873249, 134156323, 978-9386873248

More Books

Students also viewed these Programming questions

Question

What religion do you practice?

Answered: 1 week ago

Question

4. What do you wear when working out at the gym?

Answered: 1 week ago

Question

How many complete meals do you eat daily?

Answered: 1 week ago