Create a view named customer_mobile_details which has the following attributes. Display customer id,customer name,mobile number, sales id, net amount,model name and manufacturer name of the mobiles,...


Create a view named customer_mobile_details which has the following attributes. Display customer id,customer name,mobile number, sales id, net amount,model name and manufacturer name of the mobiles,<br>they have purchased. Sort the records based on customer id,customer name,sales id in ascending order.<br>Distributor<br>Customer_Info<br>Distributor_ID<br>Distributor_Name<br>Address<br>Mobilenumber<br>Email<br>varchar(10) PK<br>varchar(20)<br>varchar(100)<br>number(10)<br>varchar(30)<br>varchar(10) PK<br>Customer_ID<br>Customer_Name varchar(20)<br>Address<br>Mobile<br>Email<br>varchar(100)<br>number(10)<br>varchar(30)<br>Sales_Info<br>Mobile_Master<br>IME_No<br>Model_Name<br>Manufacturer<br>Date_Of_Manufac<br>Warranty_in_Years<br>Price<br>Distributor_ID<br>Spec_No<br>varchar(10) PK<br>varchar(20)<br>varchar(20)<br>date<br>number(10)<br>number(7,2)<br>varchar(10) FK<br>varchar(10) FK<br>Salesid<br>Sales Date<br>IME_No<br>tot Price<br>number(10) PK<br>date<br>varchar(10) FK<br>number(10)<br>number(10)<br>number(10)<br>värchar(10) FK<br>Discount<br>Net Amount<br>Customer_ID<br>3459<br>Mobile_Specification<br>varchar(10) PK<br>varchar(20)<br>varchar(20<br>varchar(20)<br>varchar(20)<br>number(10)<br>Memory_Card Capacity_GB number(10)<br>varchar(5)<br>varchar(5)<br>varchar(5)<br>varchar(5)<br>varchar(5)<br>varchar(5)<br>varchar(20)<br>number(10)<br>Spec_No<br>Dimension<br>Weight<br>Display_Type<br>Display_Size<br>Internal_mem_in_MB<br>PK - Primary Key<br>FK - Foreigh Key<br>Network 3G<br>GPRS<br>EDGE<br>Bluetooth<br>Camera<br>Camera_Quality<br>OS<br>Battery_Life_Hrs<br>

Extracted text: Create a view named customer_mobile_details which has the following attributes. Display customer id,customer name,mobile number, sales id, net amount,model name and manufacturer name of the mobiles, they have purchased. Sort the records based on customer id,customer name,sales id in ascending order. Distributor Customer_Info Distributor_ID Distributor_Name Address Mobilenumber Email varchar(10) PK varchar(20) varchar(100) number(10) varchar(30) varchar(10) PK Customer_ID Customer_Name varchar(20) Address Mobile Email varchar(100) number(10) varchar(30) Sales_Info Mobile_Master IME_No Model_Name Manufacturer Date_Of_Manufac Warranty_in_Years Price Distributor_ID Spec_No varchar(10) PK varchar(20) varchar(20) date number(10) number(7,2) varchar(10) FK varchar(10) FK Salesid Sales Date IME_No tot Price number(10) PK date varchar(10) FK number(10) number(10) number(10) värchar(10) FK Discount Net Amount Customer_ID 3459 Mobile_Specification varchar(10) PK varchar(20) varchar(20 varchar(20) varchar(20) number(10) Memory_Card Capacity_GB number(10) varchar(5) varchar(5) varchar(5) varchar(5) varchar(5) varchar(5) varchar(20) number(10) Spec_No Dimension Weight Display_Type Display_Size Internal_mem_in_MB PK - Primary Key FK - Foreigh Key Network 3G GPRS EDGE Bluetooth Camera Camera_Quality OS Battery_Life_Hrs

Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here