Question
Create Java Statements from the following SQL Statements: 1. CREATE TABLE ShoppingCart ( shoppingCart int(10) NOT NULL, totalCost int(10), itemQuantityTotal int(10), CONSTRAINT ShoppingCart PRIMARY KEY
Create Java Statements from the following SQL Statements:
1.
CREATE TABLE ShoppingCart (
shoppingCart int(10) NOT NULL,
totalCost int(10),
itemQuantityTotal int(10),
CONSTRAINT ShoppingCart
PRIMARY KEY (shoppingCart));
ALTER TABLE ShoppingCart ADD CONSTRAINT FKShoppingCa817479 FOREIGN KEY (shoppingCart) REFERENCES Account (username);
2.
CREATE TABLE ShoppingCartItem (
shoppingCartItem int(10) NOT NULL,
itemName varchar(255),
itemCost int(10),
itemQuantity int(10),
PRIMARY KEY (shoppingCartItem));
ALTER TABLE ShoppingCartItem ADD CONSTRAINT FKShoppingCa232318 FOREIGN KEY (shoppingCartItem) REFERENCES ShoppingCart (shoppingCart);
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started