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 SQLDeveloper Must use Virtual Lab for the purpose of this assignment. This table must be for the business venture created in Week
The table should have at least columns and primary key.
Insert 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 screenshootfile
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 onestop solution for pet owners, ensuring their pets are healthy, happy, and wellcared 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 VARCHAR NOT NULL,
Category VARCHAR
Price NUMBER
StockQuantity NUMBER
;
Insert records into the 'Products' table
INSERT INTO Products ProductID ProductName, Category, Price, StockQuantity
VALUES 'Dog Food', 'Food', ;
INSERT INTO Products ProductID ProductName, Category, Price, StockQuantity
VALUES 'Cat Toy', 'Toys', ;
INSERT INTO Products ProductID ProductName, Category, Price, StockQuantity
VALUES 'Bird Cage', 'Cages', ;
INSERT INTO Products ProductID ProductName, Category, Price, StockQuantity
VALUES 'Grooming Brush', 'Grooming', ;
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
