Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer the question as soon as possible . All the informatio is already given . Construct the SQL statement to answer the question and screenchot

image text in transcribed

image text in transcribed

image text in transcribed

Answer the question as soon as possible . All the informatio is already given . Construct the SQL statement to answer the question and screenchot (prtsc) the results of the SQL statement executed in Oracle . Thank you .

SQL> CREATE TABLE Customer 2 ( Customer_No Char(5) NOT NULL, 3 Customer_Name Varchar2(30) NOT NULL, 4 Gender Char(1) NOT NULL, 5 Address Varchar2(60) NOT NULL, 6 Email Address Varchar2(60) NOT NULL, 7 Telephone_No Number (10) NOT NULL, 8 No_of_Clothes Number(2) NOT NULL, 9 Cust_Size Char(5) NOT NULL, 10 Receipt_Date Varchar2(15) NOT NULL, 11 Return_Date Varchar2(15) NOT NULL, 12 CONSTRAINT Customer_No_pk PRIMARY KEY (Customer_No)); Table created. SQL> DESC Customer Name Null? Type CUSTOMER_NO CUSTOMER_NAME GENDER ADDRESS EMAIL_ADDRESS TELEPHONE_NO NO_OF_CLOTHES CUST_SIZE RECEIPT_DATE RETURN_DATE NOT NULL CHAR(5) NOT NULL VARCHAR2(30) NOT NULL CHAR(1) NOT NULL VARCHAR2(60) NOT NULL VARCHAR2(60) NOT NULL NUMBER (10) NOT NULL NUMBER(2) NOT NULL CHAR(5) NOT NULL VARCHAR2(15) NOT NULL VARCHAR2(15) SQL> CREATE TABLE Designer 2 ( Designer_No Char(5) NOT NULL, 3 Designer_Name Varchar2(30) NOT NULL, 4 Address Varchar2(60) NOT NULL, 5 Email Address Varchar2(60) NOT NULL, 6 Telephone_No Number(10) NOT NULL, 7 Social_Med_Plat Varchar2(30) NOT NULL, 8 Salary Number (4) NOT NULL, 9 CONSTRAINT Designer_No_pk PRIMARY KEY (Designer_No)); Table created. SQL> DESC Designer Name Null? Type DESIGNER_NO DESIGNER_NAME ADDRESS EMAIL_ADDRESS TELEPHONE_NO SOCIAL_MED_PLAT SALARY NOT NULL CHAR(5) NOT NULL VARCHAR2(30) NOT NULL VARCHAR2(60) NOT NULL VARCHAR2(60) NOT NULL NUMBER (10) NOT NULL VARCHAR2(30) NOT NULL NUMBER (4) SQL> CREATE TABLE Clothes 2 ( Clothes_No Char(5) NOT NULL, 3 Customer_No Char(5) NOT NULL, 4 Designer_No Char(5) NOT NULL, 5 Type_Clothes Varchar2(30) NOT NULL, 6 Cond_Clothes Varchar2(20) NOT NULL, 7 Type_Fabric Varchar2(20) NOT NULL, 8 Colour_Clothes Varchar2(10) NOT NULL, 9 Price Number(3) NOT NULL, 10 CONSTRAINT Clothes_No_pk PRIMARY KEY (Clothes_No), 11 CONSTRAINT Customer_No_fk FOREIGN KEY (Customer_No) REFERENCES Customer, 12 CONSTRAINT Designer_No_fk FOREIGN KEY (Designer_No) REFERENCES Designer); Table created. SQL> DESC Clothes Name Null? Type CLOTHES_NO CUSTOMER_NO DESIGNER_NO TYPE_CLOTHES COND_CLOTHES TYPE_FABRIC COLOUR_CLOTHES PRICE NOT NULL CHAR(5) NOT NULL CHAR(5) NOT NULL CHAR(5) NOT NULL VARCHAR2(30) NOT NULL VARCHAR2(20) NOT NULL VARCHAR2(20) NOT NULL VARCHAR2(10) NOT NULL NUMBER(3) Query For customers who received the clothes from June 2021 onwards, show the customers' names and the types of clothes received by the customers

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

More Books

Students also viewed these Databases questions