Question
7.7 Write and run an SQL CREATE TABLE statement to create the CUSTOMER_01 table. Figure 7-42 Data for the CH07_RQ_TABLES Database SALE_01 Table Figure 7-43
7.7 Write and run an SQL CREATE TABLE statement to create the CUSTOMER_01 table.
Figure 7-42 Data for the CH07_RQ_TABLES Database SALE_01 Table
Figure 7-43 Data for the CH07_RQ_TABLES Database SALE_02 Table
7.8 Write and run an SQL CREATE TABLE statement to create the CUSTOMER_02 table.
7.9 Are there any significant differences between the CUSTOMER_01 and CUSTOMER_02 tables? If so, what are they?
7.10 Write and run an SQL CREATE TABLE statement to create the CUSTOMER_03 table.
7.11 Are there any significant differences between the CUSTOMER_02 and CUSTOMER_03 tables? If so, what are they?
SaleIDDateOfSale EmailAddress 20150001 2015-01-14 Robert.Shire@somewhere.com 20150002 2015-01-14 Chris.Bancroft@somewhere.com 20150003 2015-01-16 Robert.Shire@somewhere.com 20150004 2015-01-17 Katherine.Goodyear@somewhere.com SaleAmount 234.00 56.50 123.00 34.25Step by Step Solution
There are 3 Steps involved in it
Step: 1
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
Concepts of Database Management
Authors: Philip J. Pratt, Joseph J. Adamski
7th edition
978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591
