Question
ORDERS A table containing information about orders ordno number(6) unique identifier month char(3) three character abreviation for month order was placed cid customer placing order
ORDERS A table containing information about orders
ordno number(6) unique identifier
month char(3) three character abreviation for month order was placed
cid customer placing order
aid agent handling customers order
pid product ordered
qty number(6) quantity of product (pid) on this order
dollars number(6,2) cost in dollars of this order
PRODUCTS A table containing information about products for sale
pid char(3) unique identifier
pname up to 13 characters descriptive name of product
city up to 20 characters city where this product is warehoused
quantity number(10) quantity on hand for sale
price number(3,2) wholesale price of each product
AGENTS A table containing information about agent employees
aid char(3) unique identifier
aname up to 13 characters last name of agent
city up to 20 characters city where agent is based
percent number(3) percentage commission agent receives on a sale
CUSTOMERS A table containing information about customers
cid char(4) unique identifier
cname up to 13 characters name of a customer
city up to 20 characters city where customers headquarters is located
disnct number(4,2) customers discount
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