2) Write the CREATE TABLE statement for these tables and INSERT statements: Customers table customerid firstname...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2) Write the CREATE TABLE statement for these tables and INSERT statements: Customers table customerid firstname lastname 10101 10298 10339 10357 10409 10410 10429 10415 10428 10438 10449 John Leroy Anthony Jared Caroline Mary Ann Sarah Deborah Robert Kevin Isabela Gray Brown Sanchez McGregor Ziadie Howell Graham Taud Gamble Smith Moore city Lynden Pinetop Winslow San Diego New Orleans Charleston Greensboro New York Miami Durango Yuma 1 state Washington Arizona Arizona California Louisiana South Carolina North Carolina New York Florida Colorado Arizona Items_Ordered table ID customerid 1 2 3 4 5 6 7 8 9 10 11 21 Writ 10101 10339 10449 10415 10438 10449 10101 10438 10409 10101 10298 order_date 30-Jun-1999 27-Jul-1999 14-Aug-1999 18-Dec-1999 02-Dec-1999 22-Dec-1999 02-Jan-2000 18-Jan-2000 29-Feb-2000 08-Mar-2000 01-Apr-2000 CREATE TABLE item Raft Umbrella Ski Poles Tent Pillow Canoe Lantern Tent Flashlight Sleeping Bag Ear Muffs deti. quantity 1 1 2 1 1 1 1 1 1 2 1 price 58.00 4.50 25.50 88.00 8.50 280.00 16.00 79.99 4.50 88.70 12.50 2) Write the CREATE TABLE statement for these tables and INSERT statements: Customers table customerid firstname lastname 10101 10298 10339 10357 10409 10410 10429 10415 10428 10438 10449 John Leroy Anthony Jared Caroline Mary Ann Sarah Deborah Robert Kevin Isabela Gray Brown Sanchez McGregor Ziadie Howell Graham Taud Gamble Smith Moore city Lynden Pinetop Winslow San Diego New Orleans Charleston Greensboro New York Miami Durango Yuma 1 state Washington Arizona Arizona California Louisiana South Carolina North Carolina New York Florida Colorado Arizona Items_Ordered table ID customerid 1 2 3 4 5 6 7 8 9 10 11 21 Writ 10101 10339 10449 10415 10438 10449 10101 10438 10409 10101 10298 order_date 30-Jun-1999 27-Jul-1999 14-Aug-1999 18-Dec-1999 02-Dec-1999 22-Dec-1999 02-Jan-2000 18-Jan-2000 29-Feb-2000 08-Mar-2000 01-Apr-2000 CREATE TABLE item Raft Umbrella Ski Poles Tent Pillow Canoe Lantern Tent Flashlight Sleeping Bag Ear Muffs deti. quantity 1 1 2 1 1 1 1 1 1 2 1 price 58.00 4.50 25.50 88.00 8.50 280.00 16.00 79.99 4.50 88.70 12.50
Expert Answer:
Answer rating: 100% (QA)
The CREATE TABLE statement for the Customers table is as follows CREATE TABLE Customers customerid I... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these computer network questions
-
DATABASE NORMALIZATION Improving Database Design through Normalization Continue improving the database (tables) you designed Here are your tasks: Discuss whether the tables you designed have...
-
a) Find the set of solutions of each of the linear congruence: i. 8x = 12 (mod 28). ii. 7x = 1 (mod 9). b) Hashing Function is used to assign a memory location for the records in the computer (For...
-
Player Team Position Salary Brian McCann Atlanta Braves Catcher$6,700,000 Brooks Conrad Atlanta Braves Third Baseman $427,250Chipper Jones Atlanta Braves Third Baseman $14,000,000 CraigKimbrel...
-
Design a linear-time algorithm to sort an array of Comparable objects that is known to have at most three distinct values. (Edsger Dijkstra named this the Dutch-national-flag problem because the...
-
1. Calculate the number of ways that 38 students can be assigned to four seminars of size 10, 12, 10, and 6, respectively. 2. Calculate the number of ways that 65 phone numbers can be distributed to...
-
(a) Given the product structure and master production schedule (Figure 14.14 below), develop a gross requirements plan for all items. (b) Given the preceding product structure, master production...
-
Alicin Nagle, an in-charge auditor, is reviving the inventory controls for the city of Carlton's vehicle maintenance facility. Nagle has learned the following: a. Vehicle maintenance records indicate...
-
Della Bee Company purchased a manufacturing plant building 10 years ago for $1,300,000. The building has been depreciated using the straight-line method with a 30-year useful life and 10% residual...
-
Discuss the role of daemon processes and background services in operating systems. How do these processes differ from regular user processes, and what best practices are followed to ensure their...
-
Procter & Gamble has been the leading soap manufacturer in the United States since 1879, when it introduced Ivory soap. However, late in 1991, its major rival, Lever Bros. (Unilever), overtook it by...
-
The parol evidence rule: a. allows the introduction of conflicting oral testimony relating to contractual obligations if the parties had an oral agreement prior to forming a fully integrated written...
-
Aurora Wedding Gowns was burglarized in May of 20X5. It is unclear how many dresses were stolen. Aurora and its insurance company are currently working to estimate the dollar value of the stolen...
-
Carson's Camera Store has a number of video recording cameras in stock. All units are priced to provide a normal profit margin of \($150\). Some of these units are quite old. Carson's has concluded...
-
Bell Computers assembles and sells notebook styled computers. The company is attempting to better manage cash flow and reduce inventory. The most recent strategy has been to require major vendors to...
-
Determine the "type" and "basic accounting" approach for each of the following categories of investments. Investment level generally over 20% but not giving control Investment level usually over 50%...
-
In the period in which an intercorporate sale occurs, how do the consolidation eliminating entries differ when unrealized profits pertain to an intangible asset rather than a tangible asset?
-
Solve dz/ dx =sin.x.
-
A superior criticized a sales manager for selling high-revenue, low-profit items instead of lower-revenue but higher-profit items. The sales manager responded, My income is based on commissions that...
-
When do you use an update query?
-
What is a fact table in a data warehouse?
-
What is the system catalog? Name three items about which the catalog maintains information.
-
The Private Securities Litigation Reform Act of 1995 and the U.S. Supreme Court's decision in Central Bank of Denver v. First Interstate Bank of Denver represent major victories in the profession's...
-
What are heuristics, and why are they of concern to auditors?
-
Identify and briefly describe the major files that are typically maintained separately from audit working papers.
Study smarter with the SolutionInn App