Create the above entities in Oracle SQL Plus using DDL syntax. Make sure you include all appropriate
Fantastic news! We've Found the answer you've been seeking!
Question:
Create the above entities in Oracle SQL Plus using DDL syntax. Make sure you include all appropriate constraints, referential integrity, PK, FK etc. Also plug in the data below.
Question: How do you solve this and How do you insert the data into SQL Plus on macbook?
Transcribed Image Text:
cgmerchant PK Store ID State Zip Code city Store Type has cgManufacturer PK Manufacturer ID UC dc State Zip Code City Manuf Type FK1 Store ID H- 9898 7755 3739 6329 clothes shoes Rx TVs IBA cgManufacturer MANUFACTURER_ID MANUF_TYPE clothes shoes Rx TVS cgShipment SHIP_DATE TRUCK_NO 17-May-2009 4422 20-Jul-2009 2222 21-Jul-2009 9922 23-Jul-2009 7722 Shipment Ship Dats Truck No PK,FK1 Manufacturer ID PK PK DDL Exercise: Create the above entities in Oracle SQL Plus using DDL syntax. Make sure you include all appropriate constraints, referential integrity, PK, FK etc. Also plug in the data below. cgMerchant STORE_ID STORE_TYPE CITY Owings Mills Reistersown Harrisonburg Harrisonburg ZIP CODE 7755 9898 3739 6329 CITY 21117 21136 MD MD 22801 VA 22807 VA MANUFACTURER_ID Glen Burnie Los Angeles Detroit Miami STATE ZIP CODE cgProducts PK Product ID 21156 90088 45443 30588 FK1 Store 0 Product Name Product Price Product Cost contain cgDescription PKFK1 Product ID PK FK2 Shipment Date PK,FK2 Track N PK FK2 ManufactMERE IR MD Quantity Condition STATE STORE_ID 1 CA MI 3 FL 4 2 cgmerchant PK Store ID State Zip Code city Store Type has cgManufacturer PK Manufacturer ID UC dc State Zip Code City Manuf Type FK1 Store ID H- 9898 7755 3739 6329 clothes shoes Rx TVs IBA cgManufacturer MANUFACTURER_ID MANUF_TYPE clothes shoes Rx TVS cgShipment SHIP_DATE TRUCK_NO 17-May-2009 4422 20-Jul-2009 2222 21-Jul-2009 9922 23-Jul-2009 7722 Shipment Ship Dats Truck No PK,FK1 Manufacturer ID PK PK DDL Exercise: Create the above entities in Oracle SQL Plus using DDL syntax. Make sure you include all appropriate constraints, referential integrity, PK, FK etc. Also plug in the data below. cgMerchant STORE_ID STORE_TYPE CITY Owings Mills Reistersown Harrisonburg Harrisonburg ZIP CODE 7755 9898 3739 6329 CITY 21117 21136 MD MD 22801 VA 22807 VA MANUFACTURER_ID Glen Burnie Los Angeles Detroit Miami STATE ZIP CODE cgProducts PK Product ID 21156 90088 45443 30588 FK1 Store 0 Product Name Product Price Product Cost contain cgDescription PKFK1 Product ID PK FK2 Shipment Date PK,FK2 Track N PK FK2 ManufactMERE IR MD Quantity Condition STATE STORE_ID 1 CA MI 3 FL 4 2
Expert Answer:
Answer rating: 100% (QA)
asked to create the entities in oracle sql plus using DDL for that initially we have to take the given data and for that the entities are Create cgMerchant table CREATE TABLE cgMerchant STOREID NUMBER... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
PLEASE NO PLAGIARISM 2-3 PAGES When examining the historical context of treatment in a correctional setting, it must be seen through both domestic and international viewpoints. Under the domestic...
-
You have just been employed by the ROBCOR Trucking Company to develop a database. To gain a sense of the databases intended functions, you have spent some time talking to ROBCORs employees and youve...
-
The purpose of this mini-project is to help you verify the Rule for Sample Means, using a physical simulation. Suppose you are interested in measuring the average amount of blood contained in the...
-
Tonight at 7pm a professional basketball game featuring the Golden State Warriors and the Washington Wizards will be played at the Chase Center, an indoor arena in the Mission Bay neighborhood of San...
-
A -Y-connected bank of three identical 100-kVA, 2400-V: 120-V, 60-Hz transformers is supplied with power through a feeder whose impedance is 0.065 + j0.87 per phase. The voltage at the sending end...
-
Datacom Services, Inc., reported the following statement of stockholders' equity for the year ended October 31, 20X7. Required Answer these questions about Datacom Services' stockholders' equity...
-
There are no IFRS accounting standards for the reporting of social and environmental activities. Evaluate what issues this presents for the preparation of financial reports.
-
The book balance in the checking account of Volman Enterprises as of October 31 is $4,765.00. The bank statement shows an ending balance of $4,348.00. The following information is discovered by (1)...
-
11. A planet is revolving around the sun in an elliptical orbit. The mass of planet is m, angular momentum of planet about sun is L, and length of semi major axis is a and eccentricity are e. Time...
-
You have just been hired as a management trainee by Cravat Sales Company, a nationwide distributor of a designer's silk ties. The company has an exclusive franchise on the distribution of the ties,...
-
1. Which of the following transactions decreases the profitability of a company? a.Purchasing treasury stock b.Declaring cash dividend c.Issuing a note payable d.Recording payroll tax expense 2. Joe...
-
Why do nations trade? Explain why freer international trade welfare is- enhancing. Show and explain why trade theories have influenced the evolution and interpretation of international laws.
-
Some of the costs are minimised by the use of inventory. Which one is not affected by it? a. cost of purchasing items b. cost of advertisement c. cost of carrying or holding inventory d. cost of...
-
Which of the following would cause a change in the feasible region? a. Increasing an objective function coefficient in a maximization problem b. Adding a redundant constraint c. Changing the...
-
How are items like raw materials stored in inventories? a. by themselves b. in work-in-process c. in the finished product d. all of the above
-
Linear programming problems are solved the fastest by the isoprofit line method. How does it work? a. It determines constraints. b. It defines variable. c. It finds an optimal solution. d. None of...
-
In this scenario imagine you oversee the loyalty programs for a burger restaurant. The burger restaurant is part of a chain that competes with Red Robin for market share. The CEO of the burger...
-
Consider the setup in Problem 16. Show that the relative speed of the ball and the point of contact on the stick is the same before and immediately after the collision. (This result is analogous to...
-
How are qualified dividends taxed in 2012? Please give the two rates of tax which apply to qualified dividends, and specify when each of these rates applies._________________________...
-
Indicate, in each of the following situations, the number of exemptions the taxpayers are entitled to claim on their 2012 income tax returns. Number of Exemptions a. Donna, a 20-year-old single...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family. The Incisors own a rental beach house in Hawaii. The beach house was rented for the full year during 2012...
-
Who was Phar-Mors flamboyant Chief Executive Officer?
-
Which of the following generally is not considered something of value? 1. Cash, money or checks 2. Airline miles or hotel credits associated with frequent activity (e.g., frequent flier miles) 3. An...
-
Which of the following is not one of the five major categories of fraudulent disbursements? 1. Payroll schemes 2. Expense reimbursement schemes 3. Shell company schemes 4. Billing schemes
Study smarter with the SolutionInn App