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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Complete the following data model by creating an Entity Relationship Diagram in PowerArchitect. Transform your ERD data model into a database design by creating a Relational Schema Diagram (RSD) in...

I need help with the next queries using the next table. 1. For each month, list the month, the number of different customers placing orders in that month, the total number of orders placed, and the...

Using the table below make the next QUERIES 1. List the order numbers for all orders sold by agent A01 to customer C001 in January.? 2. List the order number, month, order quantity, and invoice...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

Hi, Please put together Case 22-5 and 18-4 Using the following format: Cover Sheet Table of Contents Facts Analysis Conclusion Please make sure to rephrase all the content into one. I am attaching...

Please let me know if you can do the assignment. I am suppose to have four different charts and it needs to be done in VIsio. Thanks AC304: Accounting Information Systems Business Process Modeling...

\ This case was developed solely for the purpose of classroom discussion. Some details of the case have been disguised. This case is not intended to serve as endorsements, sources of academic or...

\f\f\fChapter 2 Service Strategy Learning Objectives After completing this chapter, you should be able to: 1. Formulate a strategic service vision. 2. Describe how a service competes using the three...

design cultural web and its main elements. base your answer on the description offered in the case study at about the time when the workshops begun. Case Study: Kao Corporation By Samantha Ghoshal...

Which report summarizes the amount of financial activity associated with each income or expense account for a specific period of time? Trial Balance Balance Sheet Profit and Loss Audit Log

Warranties and Loss Contingencies the following two independent situations involve loss contingencies. Part 1 Benson Company sells two products, Grey and Yellow. Each carries a one-year warranty. 1....

what is the YTM ? 3 7 , 7 5 1 0 3 1 5 5 . 1 6 % 1 5 . 5 3 % 9 . 4 %

SOPHIA'S FINANCIAL PLAN Sophia, 23, completed her Bachelor of Science degree one year ago. The major cost of her tuition and hooks was covered by a scholarship. Through wise planning, she was able to...

What is the preferred personality?

7. Explain how culture can function as resistance to dominant value systems.

6. On June 12 every year, some U.S. Americans celebrate Loving Day to commemorate: a. Your legal right to love someone of another race b. Your legal right to love someone of the same sex c. Your...