Scribd
Upload
8 views2 pages

Herrends, Inc. Database Queries

1. This document appears to be a final exam for a database management systems course. It includes tables for customer data and inventory data. 2. The exam asks students to write SQL queries to retrieve certain records from the tables based on criteria like names, totals over a certain amount, and selecting specific fields. 3. It provides sample data in the customer and inventory tables to allow students to test their SQL queries against.

Uploaded by

Erwin Sison
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
8 views2 pages

Herrends, Inc. Database Queries

1. This document appears to be a final exam for a database management systems course. It includes tables for customer data and inventory data. 2. The exam asks students to write SQL queries to retrieve certain records from the tables based on criteria like names, totals over a certain amount, and selecting specific fields. 3. It provides sample data in the customer and inventory tables to allow students to test their SQL queries against.

Uploaded by

Erwin Sison
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

ST.

NICOLAS COLLEGE OF BUSINESS AND TECHNOLOGY


Department of Computer Programming
Final Exam CS7 Database Management System

Name: ________________________________________________ Date: _______________


Section: _______________________________________________ Score: ______________

Table Name: Customer


CustNum CustCoName CustLName CustFName CustAddr1 CustCity CustState CustZip CustPhone CustEmail CustWeb
API Atlantic Powers, Inc. Jameson Richard 3000 Powers Ct. St. Peters DE 00222-1212 111-111-1111 api@[Link] [Link]
BAC Big Artichoke Company Smith James 6000 Stately Ln. St. Louis MO 00002-1313 444-444-4444 bac@[Link] [Link]
DCCB Delta CCB, Inc. Hendricks Judy 2100 Delta Dr. Joplin CA 61123 333-333-3333 judyh@[Link] [Link]
HERR Herrends, Inc. Samualson Steve 1200 Herrends Ind. Ct. St. Peters MO 63124 555-555-5555 herrends@[Link] [Link]

Table Name: Inventory


InvNum InvDate InvRepNu CustNum InvSubtotal InvSalesTa InvShipping InvTotal InvIsComp 1. Query all order of Jefferson Richard.
m x 2. Query all records where inventory total is more than 5000.
1001 1/1/2008 Joe API 1,474.97 10.00 40.00 1,524.97 TRUE 3. Query only the customer company name and customer web.
1002 1/3/2008 Mary DCCB 2,041.14 17.00 20.00 2,078.14 TRUE 4. Union Customer name.
1003 1/5/2008 Joe API 1,063.30 18.00 50.00 1,131.30 TRUE 5.
1004 1/7/2008 Joe BAC 3,689.86 29.00 60.00 3,778.86 TRUE
1005 1/8/2008 Mary HERR 4,615.82 32.00 30.00 4,677.82 TRUE
1006 1/9/2008 Joe API 31,351.38 34.00 10.00 31,395.38 FALSE
1007 1/12/2008 Mary HERR 287.70 36.00 20.00 343.70 TRUE
1008 1/14/2008 Joe API 701.46 22.00 30.00 753.46 TRUE
1009 1/22/2008 Joe BAC 805.24 24.00 50.00 879.24 TRUE
1010 2/1/2008 Joe API 435.54 28.00 60.00 523.54 TRUE
1011 2/6/2008 Joe API 1,119.48 29.00 40.00 1,188.48 FALSE
1012 2/14/2008 Joe API 543.42 31.00 10.00 584.42 TRUE
1013 2/17/2008 Mary DCCB 6,597.36 39.00 60.00 6,696.36 TRUE
1014 2/20/2008 Mary HERR 1,596.84 40.00 30.00 1,666.84 TRUE
1015 2/20/2008 Joe BAC 7,665.24 42.00 20.00 7,727.24 TRUE
1016 3/2/2008 Joe API 212.66 44.00 50.00 306.66 TRUE
1017 3/9/2008 Joe API 345.66 60.00 30.00 435.66 TRUE
1018 3/13/2008 Mary DCCB 498.68 69.00 20.00 587.68 TRUE
1019 3/20/2008 Joe BAC 601.50 70.00 10.00 681.50 TRUE
1020 3/30/2008 Joe API 459.42 12.00 20.00 491.42 FALSE

You might also like