You are required to create the following tables in a database named COFFEELIST: (20) COFFEE COFFEE_CODE...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are required to create the following tables in a database named COFFEELIST: (20) COFFEE COFFEE_CODE COFFEE_NAME COFEE BRAND STRENGTH PRICE STORES STORE_CODE STORE NAME ADDRESS CITY AVAILABILITY COFFEE_CODE STORE CODE VARCHAR(5) NOT NULL VARCHAR(40) NOT NULL VARCHAR(40) NOT NULL VARCHAR(40) NOT NULL SMALLMONEY NOT NULL VARCHAR(5) NOT NULL VARCHAR(20) NOT NULL VARCHAR(50) NOT NULL VARCHAR(20) NOT NULL VARCHAR(5) NOT NULL VARCHAR(S) NOT NULL AVAILABLE STOCK SMALLINT NOT NULL PRIMARY KEY PRIMARY KEY PRIMARY KEY FOREIGN KEY REFERENCES COFFEE(COFFEE_CODE] PRIMARY KEY FOREIGN KEY REFERENCES STORES(STORE_CODE) You are required to create the following tables in a database named COFFEELIST: (20) COFFEE COFFEE_CODE COFFEE_NAME COFEE BRAND STRENGTH PRICE STORES STORE_CODE STORE NAME ADDRESS CITY AVAILABILITY COFFEE_CODE STORE CODE VARCHAR(5) NOT NULL VARCHAR(40) NOT NULL VARCHAR(40) NOT NULL VARCHAR(40) NOT NULL SMALLMONEY NOT NULL VARCHAR(5) NOT NULL VARCHAR(20) NOT NULL VARCHAR(50) NOT NULL VARCHAR(20) NOT NULL VARCHAR(5) NOT NULL VARCHAR(S) NOT NULL AVAILABLE STOCK SMALLINT NOT NULL PRIMARY KEY PRIMARY KEY PRIMARY KEY FOREIGN KEY REFERENCES COFFEE(COFFEE_CODE] PRIMARY KEY FOREIGN KEY REFERENCES STORES(STORE_CODE)
Expert Answer:
Answer rating: 100% (QA)
Create Database COFFEELIST CREATE DATABASE COFFEELIST Create tables in d... View the full answer
Related Book For
Database Systems A Practical Approach to Design Implementation and Management
ISBN: 978-0132943260
6th Edition Global
Authors: Thomas Connolly, Carolyn Begg
Posted Date:
Students also viewed these programming questions
-
A company's sales in Year 1 were $380,000 and in Year 2 were $417,500. Using Year 1 as the base year, the percent change for Year 2 compared to the base year is:
-
Solomon Airline Company is considering expanding its territory. The company has the opportunity to purchase one of two different used airplanes. The first airplane is expected to cost $10,800,000; it...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Samples of size n = 5 are collected from a process every half hour. After 50 samples have been collected, we calculate. x = 20.0 and s 1.5. Assume that both charts exhibit control and that the...
-
Cassidy Concrete Corp. acquired 20% of Enda Inc.'s common shares on January 1, 2015, by paying $3 million for 100,000 shares. Enda paid a $0.50-per-share cash dividend, which Cassidy received on June...
-
A flow is divided into two branches as shown. A gate valve, half open, is installed in line A, and a globe valve, fully open, is installed in line B. The head loss due to friction in each branch is...
-
All of the first months activity for Crystal Clear Cleaning is as follows. Requirements 1. Journalize transactions as required from the activity data. 2. Post journal entries to T-accounts and...
-
At December 31, 2016, Jimenez SA reported the following as plant assets. During 2017, the following selected cash transactions occurred. April 1 Purchased land for ¬2,200,000. May 1 Sold...
-
Many businesses borrow money during periods of increased business activity to finance inventory and accounts receivable. For example, Min Corporation builds up its inventory to meet the needs of...
-
Air is compressed in an isentropic compressor from 15 psia and 70°F to 200 psia. Determine the outlet temperature and the work consumed by this compressor per unit mass of air. 200 psia Air...
-
A supplier makes a product sold during the winter season at a unit production cost of $5. A retailer sells the product for $30 to the end customer. The supplier currently charges a wholesale price of...
-
12. An electric train travels at a constant speed on a circular track with a radius of 0.7 m. It takes the train 5.0 s to change its heading from east to south. Calculate the train's: a) b) c) d)...
-
Through play, children refine their movements to achieve their goals. At all levels of development, you can find similar examples of how play fosters learning for a child. The concept and value of...
-
Problem #2 The Fermi energy (in eV) of Na and Au are 3.15 eV and 5.54 eV, respectively at 300 K. Calculate the speed of electrons at EF for each metal. Calculate the density of states as states per...
-
How does the intended audience influence the writer's choice of words and use of language in a document? Think of a specific topic and two specific kinds of audiences. Then write a short example of...
-
After reading about High Frequency Trading, do you believe that they are beneficial or detrimental to the efficiency and transparency of markets? Please make an argument for each side and then make a...
-
The dividend discount model cannot be used if the growth rate of dividends is less than the return required by shareholders. O the growth rate of dividends is negative. the growth rate of dividends...
-
F.(3e* -2x 3 sin(2x)) is equal to 2 3 Cos 8. IT 3, t (4+@ 2 3, 1+o 1 4 Cos 4 4 1 3. 1 +4cos V7 (1+o 4 1 4 Cos 4 1+0 4-
-
Describe the rules for deriving relations that represent:
-
Consider the following table: Part (partNo, contract, partCost) which represents the cost negotiated under each contract for a part (a part may have a different price under each contract). Now...
-
What are the main characteristics of functional dependencies that are used when normalizing a relation?
-
A pair of \(20^{\circ}\) full involute spur gears having 40 and 60 teeth of module \(4 \mathrm{~mm}\) are in mesh. The smaller gear rotates at \(1440 \mathrm{rpm}\). Find (a) sliding velocity at...
-
Calculate the minimum number of teeth on a pinion to avoid interference to have a speed ratio of 2.5:1. The pressure angle is \(20^{\circ}\) and addendum of one module of gear may be used.
-
The path of contact in involute gears is (a) a straight line (b) involute path (c) curved path (d) circle.
Study smarter with the SolutionInn App