Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer the query (For customers who received the clothes from June 2021 onwards , show the customers' names and the types of clothes received

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Please answer the query (For customers who received the clothes from June 2021 onwards , show the customers' names and the types of clothes received by the customers) as soon as possible . Thank you . Screenshot the results of the SQL statement .

CREATE TABLE Customer Customer No Char(5) NOT NULL, Customer Name Varchar2(30) NOT NULL, Gender Char(1) NOT NULL, Address Varchar2(60) NOT NULL, Email Address Varchar2(60) NOT NULL, Telephone_No Number(10) NOT NULL, No of Clothes Number(2) NOT NULL, Sust.Size Char(5) NOT NULL, Receipt_Date Varchar2(15) NOT NULL, Return_Date Varchar2(15) NOT NULL, CONSTRAINT Customer Newpk PRIMARY KEY (Customer_No)); CREATE TABLE Designer (Designer_No Char(5) NOT NULL, Designer_Name Varchar2(30) NOT NULL, Address Varchar2 (60) NOT NULL, Email Address Varchar2(60) NOT NULL, Telephone No Number(10) NOT NULL, Social Med Plat Varchar2(30) NOT NULL, Ne Designed Number(3) NOT NULL, Salary Number(4) NOT NULL, CONSTRAINT Designer. No pk PRIMARY KEY (Designer_No)); CREATE TABLE Clothes (Clothes_ No Char(5) NOT NULL, Type_Clothes Varchar2(30) NOT NULL, Cond_Clothes Varchar2(20) NOT NULL, Type_Fabric Varchar2(20) NOT NULL, Colour Clothes Varchar2(10) NOT NULL, Price Number(3) NOT NULL, Customer No Char(5) NOT NULL, Designer_No Char(5) NOT NULL, CONSTRAINT Clothes No pk PRIMARY KEY (Clothes No), CONSTRAINT Customer_No fk FOREIGN KEY (Customer_No) REFERENCES Customer, CONSTRAINT Designer Ne fk FOREIGN KEY (Designer_No) REFERENCES Designer); SQL> INSERT INTO Customer 2 (Customer_No, customer_Name, Gender, Address, Email Address, Telephone_No, No_of_clothes, Cust_size, Receipt_Date, Return_Date) VALUES 4 ('CU001', 'Sarah', 'F', '163, Main St.', 'sarah365@gmail.com', 0134576232, 2, 'M', '07-05-2021', '27-05-2021'); 3 1 row created. SQL> INSERT INTO Customer 2 (Customer_No, Customer_Name, Gender, Address, Email Address, Telephone_No, No_of_clothes, Cust_size, Receipt_Date, Return_Date) 3 VALUES 4 ('CUOO2', 'Ahmed', 'M', '32, Manse Rd.', 'ahmed35@gmail.com', 0176158359, 1, 'T', '15-06-2021', '05-07-2021'); 1 row created. SQL> INSERT INTO Customer 2 (Customer_No, Customer_Name, Gender, Address, Email Address, telephone_No, No_of_clothes, Cust_size, Receipt_Date, Return_Date) 3 VALUES 4 ('CUOO3', 'John', 'M', '56, Clover Dr', 'john5@gmail.com', 0177658349, 3, 's', '04-10-2021', '24-10-2021'); 1 row created. SQL> INSERT INTO Customer 2 (Customer_No, Customer_Name, Gender, Address, Email Address, Telephone_No, No_of_clothes, Cust_size, Receipt_Date, Return_Date) VALUES 4 ('CU004', 'Susan', 'F', '22, Deer St.', 'sus3@gmail.com', 0114563732, 1, 'XL', '27-12-2021', '17-01-2022'); 3 1 row created. SQL> INSERT INTO Customer 2 (Customer_No, Customer_Name, Gender, Address, Email Address, Telephone_No, No_of_clothes, Cust_size, Receipt_Date, Return_Date) 3 VALUES 4 ('CU005', 'David', 'M', '6, Lawrence st.', 'dave99@hotmail.com', 0163732343, 5, 'XXL', '13-01-2022', '03-02-2022'); 1 row created. SQL> INSERT INTO Designer 2 (Designer_No, Designer_Name, Address, Email Address, Telephone_No, Social_Med_plat, Salary, No_Designed) VALUES ('0001', 'Hannah', '2, Manor Rd.', 'hnnh23@gmail.com, 01827456877, 'bannahsdezine', 4000, 99); 3 4 1 row created. SQL> INSERT INTO Designer 2 (Designer_No, Designer_Name, Address, Email Address, Telephone_No, Social_Med_Plat, Salary, No_Designed) VALUES 4 ('0002', 'Hamid', '8, Holhead st., hmd67@gmail.com, 0168745397, "hmmmdesigns', 7000, 230); 3 1 row created. SQL> INSERT INTO Designer 2 (Designer_No, Designer Name, Address, Email Address, Telephone No, social_med_Plat, Salary, No_Designed) VALUES ('0003', 'Camila', '18, Dale Rd.coco@gmail.com, 0167788977, cocofficial', 5000, 160); 3 4 1 row created. SQL> INSERT INTO Designer 2 (Designer_No, Designer_Name, Address, Emaii_Address, Telephone_No, social_Med_Plat, Salary, No_Designed) VALUES 4 ('0004', 'James', '601, W Main st., James8o@gmail.com 0145668977, jamjamdoes', 2000, 56); 3 1 row created. 2. SQL> INSERT INTO Designer (Designer_No, Designer_Name, Address, Email Address, Telephone No, social_Med_plat, Salary, No_Designed) VALUES ('0005', 'Mary', '420, N. Santa Anita Street,mry29@gmail.com 0145979987, maryfashion', 4000, 81); 3 4 1 row created. F SQL> INSERT INTO clothes 2 (Clothes_No, Type_clothes, Cond_clothes, Type_Fabric, colour clothes, Price, customer_No, Designer_No) VALUES 4 ('CL001', 'Shirt', 'Light', 'Cotton', 'white', 25, CU003D002'); 3 1 row created. SQL> INSERT INTO clothes 2 (Clothes_No, Type_Clothes, Cond_clothes, Type_Fabric, colour clothes, Price, Customer_No, Designer_No) 3 VALUES 4 ('CL002', 'Pants', 'Intermediate', Denim', 'Blue'), 35, CU001', 'D005); 5 1 row created. SQL> INSERT INTO clothes 2 (clothes_No, Type_clothes, Cond_clothes, Type_Fabric, colour clothes, Price, customer_No, Designer_No) 3 VALUES 'CL003', 'Scarf', 'light', 'Pink', 15, 'CU004, DOOBNE 4 'Silk', 1 row created. SQL> INSERT INTO clothes 2 (clothes_No, Type_clothes, Cond_clothes, Type_Fabric, colour clothes, Price, Customer_No, Designer_No) 3 VALUES 4 ('CL004', 'Skirt', 'Bad', 'Velvet', 'Green 38, CU001 D0010 1 row created. SQL> INSERT INTO Clothes 2 (clothes_No, Type_clothes, Cond_clothes, Type_Fabric, colour clothes, Price, customer_No, Designer_No) VALUES ('CL805', 'Sweatshirt', 'Intermediate', 'Polyester, 'Black', 30, CuO05, DO04'); 3 4 1 row created. SQL> INSERT INTO Clothes 2 (Clothes_No, Type_clothes, Cond_clothes, Type_Fabric, Colour clothes, Price, Customer_No, Designer_No) VALUES ('CL006', 'Jacket', 'Light', 'Leather', 'Black', 40, cu002D003'); 3 4 1 row created. Query For customers who received the clothes from June 2021 onwards, show the customers' names and the types of clothes received by the customers. Answer: Www

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

Business Process Driven Database Design With Oracle PL SQL

Authors: Rajeev Kaula

1st Edition

1795532386, 978-1795532389

More Books

Students also viewed these Databases questions

Question

=+ Of the HR issues mentioned in the case,

Answered: 1 week ago