[SOLVED] Database SQL Queries of Ordering Management System

By Anonymous -
Use this file as your template and place your SQL code {not the results} beneath each question.

Use the following tables to answer the questions:
CUSTOMERS(cid, cname, city, discnt)
AGENTS(aid, aname, city, commission)
PRODUCTS(pid, pname, city, quantity, price)
ORDERS(ordno, ordmonth, cid, aid, pid, qty, dollars)

Construct queries to answer the following:

  1. List the name [cname] of all customers
  2. List the order number [ordno] of all orders
  3. List all information about the products
  4. List the customer ids [cid] of all customers who placed an order. Do not list duplicates.
  5. List the customer names [cname] for customers in the city of Dallas.

Buy now

Comments

Post a Comment

Popular posts from this blog

Body Mass Index (BMI) calculator with JUnitTesting in Java

By Hassnain Jamil -
Image
Introduction: Aitor Tilla S.L. clinic specializes on the endocrine treatment of people with diverse needs in relation to weight control. The clinic wants to launch a number of technological solutions (mobile app and web pages) that will allow its clients to have an effective monitoring of the dietary plans suggested by the clinic doctors. To this end, Aitor Tilla, S.L. requires to evolve the component that measures metrics for a healthy life developed during the previous guided exercises. The component will be reusable and will allow the calculation of new necessary metrics. The component will be developed in Java, J2EE platform, and will be delivered in a JAR format that will allow the access to the methods, and the programming interface that integrates with the mobile app and web pages. In addition, the code will be delivered with a user manual that explains programmers how the integration with other components should be done. The function to consider consists of characterizing the B...
Read more

Stack and Queue Implementation with JUnitTesting according to UML

By Hassnain Jamil -
Image
Objectives: After completing this assignment the student should be able to, Write concrete classes that implement Java Interfaces according to specifications given in UML. Implement a last-in-first-out (LIFO) stack class in java. Implement a first-in-first-out (FIFO) queue class in Java. Requirements: For this assignment you are given the following Java source code files: CSE205_Assignment03.java (This file is complete – you will make no changes to this file) IStack.java (This file is complete – you will make no changes to this file) IQueue.java (This file is complete – you will make no changes to this file) MyStack.java (you must complete this file) MyQueue.java (you must complete this file) The specifications for the files are given below (including the UML diagram on the following page). Special requirements: Both MyStack and MyQueue Classes size method Returns the number of items in the collection. empty method Returns true if the size of the collection is zero; otherwise returns f...
Read more