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.

Programming Logic & Design Comprehensive
9th Edition
ISBN:9781337669405
Author:FARRELL
Publisher:FARRELL
Chapter8: Advanced Data Handling Concepts
Section: Chapter Questions
Problem 17RQ
icon
Related questions
Question

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)
Transcribed Image Text: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)
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Multiple table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage