CREATE TABLE sales ( SalesNumber INT(10) AUTO_INCREMENT PRIMARY KEY, SalesDate DATE, SalesTotal DECIMAL(10,2) ); CREATE TABLE products ( number INT(11) AUTO_INCREMENT PRIMARY KEY, prodid VARCHAR(20) UNIQUE, prodname VARCHAR(30), price DECIMAL(10,2), onhand INT(11), CONSTRAINT fk_salesdetails_products FOREIGN KEY (prodid) REFERENCES salesdetails(prodid) ON DELETE RESTRICT ); CREATE TABLE salesdetails ( number INT(10) AUTO_INCREMENT PRIMARY KEY, SalesNumber INT(10), prodid VARCHAR(20), price DECIMAL(7,2), qty INT(10), CONSTRAINT fk_salesdetails_sales FOREIGN KEY (SalesNumber) REFERENCES sales(SalesNumber) ON DELETE CASCADE, CONSTRAINT fk_salesdetails_products FOREIGN KEY (prodid) REFERENCES products(prodid) ON DELETE CASCADE ); Using the above SQL and the schema diagram, create an ER diagram detailing all the fields of the tables and the relationship amount the tables.
CREATE TABLE sales (
SalesNumber INT(10) AUTO_INCREMENT PRIMARY KEY,
SalesDate DATE,
SalesTotal DECIMAL(10,2)
);
CREATE TABLE products (
number INT(11) AUTO_INCREMENT PRIMARY KEY,
prodid VARCHAR(20) UNIQUE,
prodname VARCHAR(30),
price DECIMAL(10,2),
onhand INT(11),
CONSTRAINT fk_salesdetails_products
FOREIGN KEY (prodid)
REFERENCES salesdetails(prodid)
ON DELETE RESTRICT
);
CREATE TABLE salesdetails (
number INT(10) AUTO_INCREMENT PRIMARY KEY,
SalesNumber INT(10),
prodid VARCHAR(20),
price DECIMAL(7,2),
qty INT(10),
CONSTRAINT fk_salesdetails_sales
FOREIGN KEY (SalesNumber)
REFERENCES sales(SalesNumber)
ON DELETE CASCADE,
CONSTRAINT fk_salesdetails_products
FOREIGN KEY (prodid)
REFERENCES products(prodid)
ON DELETE CASCADE
);
Using the above SQL and the schema diagram, create an ER diagram detailing all the fields of the tables and the relationship amount the tables.
![swen2005 sales
SalesNumber: int(10)
SalesDate : date
# Sales Total : decimal(7,2)
V swen2005 salesdetails
number: int(10)
# SalesNumber : int(10)
Ⓒ prodid: varchar(20)
# price : decimal(7,2)
# qty: int(10)
swen2005 products
number : int(11)
prodid: varchar(20)
Ⓒ prodname : varchar(30)
# price : decimal(10,2)
#onhand int(11)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F16a501d0-ad86-4e86-a9d4-08a716d78319%2F928507f0-2a00-4873-9475-3298720747f8%2Fm7mx85o_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Enhanced Discovering Computers 2017 (Shelly Cashm…](https://www.bartleby.com/isbn_cover_images/9781305657458/9781305657458_smallCoverImage.gif)
![Enhanced Discovering Computers 2017 (Shelly Cashm…](https://www.bartleby.com/isbn_cover_images/9781305657458/9781305657458_smallCoverImage.gif)