Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Note: I need help on the following questions which has two parts so please answer all of the parts and provide me with the SQL

image text in transcribedimage text in transcribedNote: I need help on the following questions which has two parts so please answer all of the parts and provide me with the SQL entry please. I would greatly appreciate it and below I have included additional information and help that was provided with the question. Thank you!

image text in transcribedimage text in transcribed

SQL S CRIPTS FOR OTHER AGGREGATE FUNCTIONS WITH TWO TABLES J OINED: 16)Min and Max Quantity on Hand of a Product (Looking for Even and Uneven Sales) 17)PRODUCTS WITH QUANTITY ON HAND GREATHER THAN 25. SQL EC Practice: Working with Multiple Tables in 1:M Relationships Concentua1 Dacion. VENDOR (VendID, VendNam e, VendAddr) MGR (MgrID, MgrName) TYPE (Type ID, TDesc, MgrID) PRODUCT (PNum, PNam e, PPrice, PCost, TypeID, PInDate, VendID) PDETAILS ( PNum, PColor, PQtyOH) Example Data: Mar Tahle. Tune Tahle: Product Tahle: PDetails Table: SQL DDL SCRIPTS TO CREATE DB -SCRIPT TO CREATE PRACTICEEC DATABASE -OCT 21, 2019 .echo on .mode list .separator "" .output YourName_SQL_Practice_EC.txt .open Practice.db PRAGMA FOREIGN_KEYS - ON; DROP TABLE IF EXISTS PDetails; DROP TABLE IF EXISTS Product; DROP TABLE IF EXISTS Type; DROP TABLE IF EXISTS Vendor; DROP TABLE IF EXISTS Mgr; CONSTRAINT type_mgrid_fk FOREIGN KEY (MgrID) REFERENCES Mgr(MgrID)); (VendIDVendNameVendAddrCHAR(10),VARCHAR(30),VARCHAR(30), VendAddr VARCHAR(30), CONSTRAINT VendID_pk PRIMARY KEY (VendID); CREATE TABLE Product (PNumPNameCHAR(10),VARCHAR(30), .. inserting records into Product (100, 'Desk', 750, 550, O, DATE(2005-09-01'), 1221); INSERT INTO Product VALUES (150, 'Table', 600, 400, D, DATE(2005-11-01'), 3782); INSERT INTO Product VALUES (200, 'Chair', 550, 500, L, DATE(' 2006-04-01'), 4976); INSERT INTO Product VALUES (250, 'Bookcase', 220, 180, O, DATE(2006-07-01'), 4976); INSERT INTO Product VALUES (300, 'Lamp', 120, 100, O, DATE('2007-05-01'), 1221); INSERT INTO Product VALUES (350, 'Couch', 999, 500, L, DATE('2007-10-01'), 4976); INSERT INTO Product VALUES (400, 'Chair', 60, 45, D, DATE('2008-06-01'), 3782); INSERT INTO Product VALUES (450, 'Table', 200, 150, L, DATE('2008-08-01'), 5632)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions

Question

1. How does Kiwi Experience maintain a continual customer focus?

Answered: 1 week ago