Write dml code based on the instructions in th picture given below Sales customers * customer_id
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sales customers * customer_id first_name last_name phone email street city state zip_code orders * order_id customer_id order_status order_date required_date shipped_date store_id staff_id ++ ++ et staffs staff_id first_name last_name email phone active store_id manager_id phone email street stores * store_id store_name city state zip_code order_items * order_id *item_id product_id quantity list_price discount ++ Production categories * category_id category_name products ++ *product_id product_name brand_id category_id model year list_price stocks * store_id *product_id quantity brands * brand_id brand name ++ Sales customers * customer_id first_name last_name phone email street city state zip_code orders * order_id customer_id order_status order_date required_date shipped_date store_id staff_id ++ ++ et staffs staff_id first_name last_name email phone active store_id manager_id phone email street stores * store_id store_name city state zip_code order_items * order_id *item_id product_id quantity list_price discount ++ Production categories * category_id category_name products ++ *product_id product_name brand_id category_id model year list_price stocks * store_id *product_id quantity brands * brand_id brand name ++
Expert Answer:
Answer rating: 100% (QA)
Based on your instructions and the database schema provided here are the Data Manipulation Language ... 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 databases questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Janet Van Tassel met Charles Carver, president of McDonald Corporation, a sub-franchisor of Baskin-Robbins Ice Cream Company. To induce her to become an ice cream store operator in a Michigan mall,...
-
How do institutions such as education, politics, and the economy contribute to the construction and maintenance of social hierarchies, and how might they be reformed to promote greater equity and...
-
a) Discuss the effect of solvent polarity on Rf-values. b)Explain how the Rf (Retention Factor)-values can be in agreement or disagreement with the like dissolves like principle?
-
Find Rab in the circuit shown. 12 k 12 k
-
On January 1, 2017, Ashlock Chemical AG issued 4,000,000, 10%, 10-year bonds at 4,543,627. This price resulted in an 8% effective-interest rate on the bonds. Ashlock uses the effective-interest...
-
A restaurant offers a $20 dinner special that lets you choose from 8 appetizers, 11 entres, and 7 desserts. How many different meals are available when you select an appetizer, an entre, and a...
-
Laminar flow in a narrow slit (see Fig. 2B.3).? (a) A Newtonian fluid is in laminar flow in a narrow slit formed by two parallel walls a distance 2B apart. It is understood that B p + pgh = p ? pgz...
-
On June 1, Blue Spruce Corp. Ltd. borrows $76,500 from Acme Bank on a 6-month, $76,500, 8% note. The note matures on December 1. (a) Prepare the entry on June 1. (Credit account titles are...
-
1. Cost out these packages given the data in Exhibits 1 and the information obtained from various insurance carriers and other information sources (Exhibit 4). Exhibit 1: Current compensation costs...
-
Match each of the following with its correct label as either a sustaining or disruptive innovation. Group of answer choices Apple creates the iPhone, creating a need for mobile apps and changing how...
-
A wholesaler just secured a contract for $600,000 in gross sales a year to a new client. Assuming the Net Profit Margin averages 20% on every sale by the wholesaler and they now expect to supply this...
-
a) discuss the analysis of thin plate b) i) Check for the admissibility of the assumed deflection function. ii) derive an expression for the maximum deflection and maximum moments using Navier Method...
-
Solve: -11c +12=-c. If there are multiple solutions, list them separated by enter . Provide your answer below: c=0 a comma
-
Why does cash flow and liquidity become a problem during a company growth? How can a company have healthy profits but lack funds to pay basic expenses? What is the relationship between liquidity and...
-
Security structure - Alternatives Structure I: 5M shares of common; Structure II: RP ($5M APP); Structure III: RP + 5M shares of common; Structure IV: PCP with participation as-if 5M shares of...
-
15. H Ha N He H He Identify the most acidic hydrogen present in the above compound: (a) a (b) b (c) c XXXXX (d) d
-
During registration at Tech every quarter, students in the Department of Management must have their courses approved by the departmental advisor. It takes the advisor an average of 4 minutes...
-
What additional factors must you consider during the physical-level design of a distributed database?
-
The management of Colonial Adventure Tours wants you to complete the following exercises. You do not use the Colonial Adventure Tours database for any of these exercises. 1. The DBA asks for your...
-
How do you save the results of an SQL query as a table?
-
If the displacement of an object is 300 m north, what can you say about the distance traveled by the object?
-
An object traveling at a constant velocity vo experiences a constant acceleration in the same direction for a period of time t. Then an acceleration of equal magnitude is experienced in the opposite...
-
You are told that a person has walked 750 m. What can you safely say about the persons final position relative to the starting point?
Study smarter with the SolutionInn App