1. Using MySQL Workbench, create a new database names Sales (ensure that the database does not...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Using MySQL Workbench, create a new database names Sales (ensure that the database does not already exist and remember to refresh your SCHEMA). 2. Using the newly created Sales database, create a new table named customer with the following fields & properties: a. customer_id integer b. first name varchar (255) c. last_name varchar(255) d. email_address varchar(255) number_of_complaints integer e. 3. Perform a Select for all entries, did you find any data? 4. Now, create a second table named sale, you will need to create one column, call it sale_id varchar(255) primary key. 5. Refresh your schema list to ensure that the table was created [screen shot| here!] 6. Remove (use Drop) the table named sale 7. Drop the table named customer 8. re-add the customer table this time including the primary key constraint (customer_id) 9. Then, create the items table with the primary key constraint item_code item_code - VARCHAR of 255, item - VARCHAR of 255, unit_price-NUMERIC of 10 and 2, company_id - VARCHAR of 255 10. Create the companies table with the primary key constraint company_id company_id - VARCHAR of 255, company_name - VARCHAR of 255, headquarters_phone_number - integer 1. Using MySQL Workbench, create a new database names Sales (ensure that the database does not already exist and remember to refresh your SCHEMA). 2. Using the newly created Sales database, create a new table named customer with the following fields & properties: a. customer_id integer b. first name varchar (255) c. last_name varchar(255) d. email_address varchar(255) number_of_complaints integer e. 3. Perform a Select for all entries, did you find any data? 4. Now, create a second table named sale, you will need to create one column, call it sale_id varchar(255) primary key. 5. Refresh your schema list to ensure that the table was created [screen shot| here!] 6. Remove (use Drop) the table named sale 7. Drop the table named customer 8. re-add the customer table this time including the primary key constraint (customer_id) 9. Then, create the items table with the primary key constraint item_code item_code - VARCHAR of 255, item - VARCHAR of 255, unit_price-NUMERIC of 10 and 2, company_id - VARCHAR of 255 10. Create the companies table with the primary key constraint company_id company_id - VARCHAR of 255, company_name - VARCHAR of 255, headquarters_phone_number - integer
Expert Answer:
Answer rating: 100% (QA)
Solution 1 To create a new database use the CREATE DATABASE statement CREATE DATABASE IF NOT EXISTS Sales To avoid an error in case you accidentally c... View the full answer
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1285196145
11th edition
Authors: Carlos Coronel, Steven Morris
Posted Date:
Students also viewed these electrical engineering questions
-
1. Create a new database and name it Baseball Gear. 2. Include in the Baseball Gear database a table (entity) for Customer, Order, Order Line Item, and Item. 3. For each table (entity) created...
-
How do you create a new database in MySQL?
-
How do you create a new database in SQL Server 2014?
-
For the following 28 scores on a 40-point test, a. Construct a bar graph using 4-point score intervals and b. Draw a frequency curve using 4-point score intervals. 27 24 21 36 25 25 38 27 25 17 31 20...
-
Describe two channels through which foreign exchange interventions may affect the value of the exchange rate.
-
Lambert Corporation sells merchandise at a list price of $70,000 with accompanying terms of 2/10, n/30 on December 8, 2016. By December 18, 2016, Lambert had collected from customers for merchandise...
-
World Transportation, Inc., is expected to initiate its quarterly dividend of \($1\) five years from today and the dividend is expected to remain constant permanently. What is the price of World...
-
VOC Industries Inc. manufactures recreational vehicles. VOC uses a job order cost system. The time tickets from May jobs are summarized below. Job 301 ........... $ 6,700 Job 302 ...........5,100 Job...
-
Assume that your father is now 50 years old, plans to retire in10 years, and expects to live for 25 years after he retires - thatis, until age 85. He wants his first retirement payment to have thes 2...
-
The Fly-Right Airplane Company builds small jet airplanes to sell to corporations for the use of their executives. To meet the needs of these executives, the companys customers sometimes order a...
-
LO. 2, 5. In 2022, Mohammed purchased a new computer for $16,000. The computer is used 100% for business. Mohammed did not make a code 179 election with respect to the computer. He does not claim any...
-
Big technology companies such as Google and Microsoft utilize organized general apologies to lay off massive amounts of employees. Recently Big tech companies have been laying off massive amounts of...
-
1. The expression 13 + 314 2. Simplify 6-5 x 68. is equal to 3. Simplify (3-5) (3) .
-
Using the table below, calculate the menu mix percent data and the number of each dish likely to sell based on a forecast of 482 guests, if only 71% of guests order appetizers Menu Item Number Sold...
-
1. Two carts of masses 2 kg and 3 kg respectively are initially at rest on a frictionless track. The carts are pushed towards each other from opposite directions. Upon collision, they stick together...
-
Graph the circle x + y - 4x - 6y + 4 = 0 Identify the center and radius
-
CASE VIGNETTE: Kara is a 15 y/o female who is originally from Colombia. She immigrated to the United States with her parents at the age of four years old. She and her parents present for support to...
-
On January 1, 2017, McIlroy, Inc., acquired a 60 percent interest in the common stock of Stinson, Inc., for $340,200. Stinson's book value on that date consisted of common stock of $100,000 and...
-
Explain the difference between an ORDER BY clause and a GROUP BY clause.
-
Describe the type(s) of relationship(s) between EMPLOYEE and STORE.
-
What is logical independence?
-
A clerk works in a wholesale business that also operates several retail outlets. Thus, cash sales are common. This clerk is responsible for tallying the day's cash receipts and preparing the daily...
-
What is meant by "more than remote?"
-
Forensic accounting is governed by the materiality concept. Analyze this statement.
Study smarter with the SolutionInn App