Log onto Oracle Live SQL$.$

Create the following tables with script Lab$01.$sql I provided for you.

Insert these $20$ records $($as shown in the following tables$)$ into the corresponding tables. Each

record is created with one INSERT INTO statement.

All these statements should be tested individually and saved together in one file Lab$03.$sql$.$

Customers $($CustomerID is PK$)$

Employees $($EmployeeID is PK$)$

Categories $($CategoryID is PK$)$

Products $($ProductID is PK$)$

CustomerID int PRIMARY KEY,

Customername varchar$2(255),$

Address varchar$2(255),$

City varchar$2(255),$

Postalcode varchar$2(255),$

;

Country varchar$2(255)$

CREATE TABLE Employees

$($

EmployeeID int PRIMARY KEY,

LastName varchar$2(255),$

FirstName varchar$2(255),$

;

BirthDate DATE

CREATE TABLE Categories

$($

CategoryID int PRIMARY KEY,

CategoryName varchar$2(255),$

;

CREATE TABLE Products

OrderDetails $($no PK is assigned$)$

ProductID int PRIMARY KEY,

ProductName varchar$2(255),$

CategoryID int,

Unit varchar$2(255),$

Price int

;

CREATE TABLE orders

$($

OrderID int PRIMARY KEY,

CustomerID int,

EmployeeID int,

OrderDate Date

CREATE TABLE orderDetails

OrderID int,

ProductID int,

Quantity int

;