Question: Create a unique table of choice using Oracle SQL * Developer . Must use Virtual Lab for the purpose of this assignment. This table must

Create a unique table of choice using Oracle SQL*Developer. Must use Virtual Lab for the purpose of this assignment. This table must be for the business venture created in Week-1.
The table should have at least 4 columns and 1 primary key.
Insert 4 records into the table.
Share SQL script (*.sql) file and a screenshot of the results after running SQL script. Be sure to attach the SQL Script file in submission and that it includes CREATE TABLE and INSERT commands in it.
I have a SQL script at the bottom but my software is having issues can you input my script and send a screenshoot/file.
Business Description
Pet Haven: A pet shop offering pets, pet supplies, and grooming services.
Pet Haven is a pet shop that sells a variety of pets, pet supplies, and offers grooming services. The shop aims to provide a one-stop solution for pet owners, ensuring their pets are healthy, happy, and well-cared for.
Entities and Attributes
Pets
PetID (Primary Key)
Name
Species
Breed
Age
Price
HealthStatus
Customers
CustomerID (Primary Key)
FirstName
LastName
Phone
Email
Address
Products
ProductID (Primary Key)
ProductName
Category
Price
StockQuantity
GroomingServices
ServiceID (Primary Key)
ServiceName
Description
Price
Appointments
AppointmentID (Primary Key)
CustomerID (Foreign Key)
PetID (Foreign Key)
ServiceID (Foreign Key)
AppointmentDate
CREATE TABLE Products (
ProductID NUMBER PRIMARY KEY,
ProductName VARCHAR2(100) NOT NULL,
Category VARCHAR2(50),
Price NUMBER(10,2),
StockQuantity NUMBER
);
-- Insert records into the 'Products' table
INSERT INTO Products (ProductID, ProductName, Category, Price, StockQuantity)
VALUES (1, 'Dog Food', 'Food', 29.99,100);
INSERT INTO Products (ProductID, ProductName, Category, Price, StockQuantity)
VALUES (2, 'Cat Toy', 'Toys', 12.49,50);
INSERT INTO Products (ProductID, ProductName, Category, Price, StockQuantity)
VALUES (3, 'Bird Cage', 'Cages', 89.99,20);
INSERT INTO Products (ProductID, ProductName, Category, Price, StockQuantity)
VALUES (4, 'Grooming Brush', 'Grooming', 15.75,75);
-- Commit the transaction to make sure changes are saved
COMMIT;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!