ASSIGNMENT QUESTION / SOALAN TUGASAN.

Added on - 30 Sep 2019

  • 12

    pages

  • 1173

    words

  • 112

    views

  • 0

    downloads

Showing pages 1 to 4 of 12 pages
ASSIGNMENT QUESTION/ SOALAN TUGASAN1.Create a Database CBDB4103, or any suitable name.2.Create Product, Customer and Order tables.Product Tablecreate table Product(ProductId int,ProductName varchar2(30),Price decimal(10,2),Categoryvarchar2(30));
Customer Tablecreate table Customer(CustomerId int,CustomerName varchar2(30),CustomerAddressvarchar2(30),CustomerContact number(15));Orders Tablecreate table Orders(OrderId int,Date1 varchar2(30),Total_Amount decimal(10,2),ProductIdint,CustomerId int);
3.Insert the above given data into the created tables.Product Tableinsert into Product values(1,'Router',945.00,'Network');insert into Product values(2,'Laptop',3400.00,'Hardware');insert into Product values(3,'Microsoft Software',450.00,'Software');insert into Product values(4,'Switch',567.00,'Network');
Customer Tableinsert into Customer values(101,'Halinda','Shah Alam',0192345333);insert into Customer values(102,'Rafeq','Subang Jaya',0198089888);insert into Customer values(103,'Jason','Kepong',0186789543);insert into Customer values(104,'Lee Kim Siew','Shah Alam',0145567865);insert into Customer values(105,'Joshua','Shah Alam',0132244567);insert into Customer values(106,'Zarina','Subang Jaya',0145567783);insert into Customer values(107,'Amin','Kepong',0186675433);
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document