Answer the question (5.4 -User Views) as soon as possible . The information already given . And screenshot the sql queries and results from SQL Developer .

Entity-Relationship Model Customer Designer Customer_No (PK) Customer Name Gender Address Email Address Telephone_No No_of_Clothes Size Receipt_Date Return Date Clothes No{FK) Designer_No (PK) Designer_Name Address Email Address Telephone_No Social_Med_Plat Salary Clothes_No{FK) 1.1 1..1 have designs Clothes 1. * Clothes_No (PK) Type Clothes Cond Clothes Type Fabric Colour Clothes Pnce Customer_No {FK} Designer_No (FK) 3.0 LOGICAL DATABASE DESIGN I Customer(Customer. No, Customer Name. Email Address, Telephone No. Receipt Date, Return Date, Clothes. No Primary Key - Customer. No Foreign Key - Clothes, Ne Gender, No of Clothes, Address, Size, Address, Email Address, Designer Designer Ne, Designer Name, Telephone Ne, Social Med Plat, Salary) Primary Key - Designer No Foreign Key - Clothes, Ne Clothes(Clothes.Ne, Type Clothes, Cond, Clothes, Type Fabric, Colour Clothes, Price, Customer. No, Designer No Primary Key - Slothes. No Foreign Key - Customer No, Designer No 4.0 PHYSICAL DATABASE DESIGN I CREATE TABLE Customer ( Customer.No Char(5), Customer Name Varchar2 (30). Gender Char(1), Address Varchar2(60), Email Address Varchar2(60), Telephone No Varchar2(10), Nanofi Clothes Number(2), Size char(5), Receipt Date Varchar2(15) Return Date Varchar2(15) CONSTRAINT Customer No pk PRIMARY KEY (Customer No), CONSTRAINT Clothes, Ne fk FOREIGN KEY (Clothes, No); CREATE TABLE Designer Designer No Char(5), Designer Name Varchar2(30), Address Varchar2(60), Email Address Varchar2(60), Telephone, No Varchar2(10), Social Med Plat Varchar2(30), Salary Number(4) CONSTRAINT Designer Nampk PRIMARY KEY (DesignerNo)): CONSTRAINT Clothes. Ne fk FOREIGN KEY (Clothes, No): A CREATE TABLE Clothes (Clothes. No Char(5), Type Clothes Varchar2(30), Cond. Clothes Varchar2(20), Type Fabric Varchar2(20), Colour Slothes Varchar2(10), Price Number(3), CONSTRAINT Clothes_No_pk PRIMARY KEY (Clothes. No), CONSTRAINT Customer No FOREIGN KEY (Customerno), CONSTRAINT Designer No FOREIGN KEY (Designer No)); 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. Below are a few examples