Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need the right SQL statements to create these tables and populate the data. i get errors when i try to do it. Write Oracle

i need the right SQL statements to create these tables and populate the data. i get errors when i try to do it.

Write Oracle SQL statements to create the tables you have designed and populate the tables with data. SALES create table sales ( TransactionID varchar (4) Primary key, ProductID char (5) not null, SaleDate date, SalePrice number ); INSERT INTO sales values(3303, 'AD301', '02-JAN-2020', 66.72); INSERT INTO sales values(2110, 'BC522', '25-JAN-2020', 70.20); INSERT INTO sales values(5231, 'LD731', '20-JAN-2020', 42.25); INSERT INTO sales values(1633, SG546, 15-FEB-2020, 85.62); EMPLOYEE Create table employee ( EmployeeID number (4) Primary key, EmployeeName varchar (10) not null, City char (10) not null, Salary number not null, JoiningDate date); INSERT INTO employee values(4731, john, lakewood, 5301.11, 02-MAY-2015); INSERT INTO employee values(3256, Mary, Tacoma 3865.50, 01-DEC-2019); INSERT INTO employee values(8845, Mike, Fountain, 3731.12, 14-AUG-2016); INSERT INTO employee values(2464, Kenny, Killeen, 4125.32, 12-NOV-2017); INVENTORY Create table inventory ( ProductID varchar (5) primary key, ProductName Char (15), Author char (12), CurrentInventory number (2)); INSERT INTO inventory values(AD301, Upbound, Bradley 15); INSERT INTO inventory values(BC522, Wonderful_Life, Destin 40); INSERT INTO inventory values(LD731, Living_Life, Brown 18); INSERT INTO inventory values(SG546, Serious_Love, Larry, 12); Customer Create table customer ( CustomerID varchar (4) primary key, CustomerName Char (12), ProductID Char (5), Quantity number (2)); INSERT INTO customer values(3891, Jason, AD301 01); INSERT INTO customer values(4563, Wilson, BC522, 02); INSERT INTO customer values(1544, William, LD731, 02); INSERT INTO customer values(8093, Alan, SG546, 03);

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_2

Step: 3

blur-text-image_3

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