Question: Please answer the question as soon as possible . All the information already given . Thank you. SQL> CREATE TABLE Customer 2 ( Customer_NoChar(5) NOT

 Please answer the question as soon as possible . All the

information already given . Thank you. SQL> CREATE TABLE Customer 2 (

Customer_NoChar(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

Please answer the question as soon as possible . All the information already given . Thank you.

SQL> CREATE TABLE Customer 2 ( Customer_NoChar(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_NoChar(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_NoChar(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_fle 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) 5.4 User Views Note: List down 3 DBA SQL queries asked by top management. You may use join relations, aggregate or/and grouping function for the queries

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!