User Account

All Pages

Display the data in the view

Assignment Help Database Management System
Reference no: EM13932807

Premiere Products Database

Table: Rep

Rep_Num

Last_Name

First_Name

Street

City

State

Zip

Commission

Rate

20

Kaiser

Valerie

624 Randall

Grove

FL

33321

$20,542.50

0.05

35

Hull

Richard

532 Jackson

Sheldon

FL

33553

$39,216.00

0.07

65

Perez

Juan

1626 Taylor

Fillmore

FL

33336

$23,487.00

0.05


 

 

 

 

Table: Customer

CustomerNum

CustomerName

Street

City

State

Zip

Balance

CreditLimit

148

Al's Appliance and Sport

2837 Greenway

Filmore

FL

33336

$6,550.00

$7,500.00

282

Brookings Direct

3827 Devon

Grove

FL

33321

$431.50

$10,000.00

Table: Orders

OrderNum

OrderDate

CustomerNum

21608

10/20/2003

148

21610

10/20/2003

356

21613

10/21/2003

408

21614

10/21/2003

282

Table: OrderLine

OrderNum

PartNum

NumOrdered

QuotedPrice

21608

AT94

11

$21.95

21610

DR93

1

$495.00

21610

DW11

1

$399.99

21613

KL62

4

$329.95

21614

KT03

2

$595.00

Table: Part

PartNum

Description

OnHand

Class

Warehouse

Price

AT94

Iron

50

HW

3

$24.95

BV06

Home Gym

45

SG

2

$794.95

CD52

Microwave Oven

32

AP

1

$165.00

DL71

Cordless Drill

21

HW

3

$129.95

1.  Define a view named CustOrder.  It consists of the customer number, name, balance, order number, and order date for all

orders currently on file.  Explain how you would use SQL to obtain the desired results. Display the data in the view.

2.  Create a view named OrdTot.  It consists of the order number and order total for each order currently on file.  (The order

total is the sum of the number ordered multiplied by the quoted price on each order line for each order.)  Explain how you

would use SQL to obtain the desired results. Display the data in the view.

 

Reference no: EM13932807

Questions Cloud

Search for a way to represent the design resolution : Explain the process of his/her search for a way to represent the design resolution through the articulation of the design concept.
What the costs of the revco bankruptcy will be : Revco Drug Store filed for bankruptcy in July of 1988 and was one of the largest bankruptcies in US financial history as well as being one of the largest leveraged buyouts. what the costs of the Revco bankruptcy will be, and how long you expect befor..
Would have difficulty applying the lifo method : Write a memo explaining why Tull Auto Parts, Inc., would have difficulty applying the LIFO method on a perpetual basis. Include a discussion of how to overcome these difficulties.
Value of stocks dividends over time : The following graph shows the value of a stock's dividends over time. The stock's current dividend is $1.00, and dividends are expected to grow at a constant rate of 3.50% per year.  Calculate the PV of the dividend paid today and the PV of the divid..
Display the data in the view : Create a view named OrdTot. It consists of the order number and order total for each order currently on file.
Commercial property prices : Commercial property prices have been increasing steadily for the past decade with greater price appreciation in the last few years, and this is expected to continue.
Standard deviation indicates about dispersion : Explain what the standard deviation indicates about dispersion. Explain how the standard deviation and risk are related. Choose a well known company in the US and calculate the standard deviation of the stock price over the last 10 years.
Death are includible in the deceaseds gross estate : Which of the following statements concerning the “gross-up” rule is (are) correct? I Income taxes paid in the year of death are includible in the deceased’s gross estate. Gift taxes paid in the year of death are included in the deceased’s gross estat..
Review basic concepts of financial accounting and methods : Review forms of business organizations and ownership, tax laws, third-party payers and managed care - review basic concepts of financial accounting and methods.

Reviews

Write a Review

Database Management System Questions & Answers

  Explain the benefits and current trends of data warehousing

Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the conceptual data feeds into and out of the data warehouse. Note: The graphically depicted solution is not included in the required..

  Computer crime has become a serious matter for your

computer crime has become a serious matter for your discussion board post consider the followingdo you think computer

  Discuss advantages and disadvantages of xml in application

XML is one of the base technologies around which many other technologies are developing. Describe an application used at work (or online) that is based on XML and discuss the advantages and disadvantages of XML in this application.

  Prepare a data dictionary

In this lab, you will prepare a Data Dictionary based on the list of elements. Also, your task will be determined the tables, their relationships, primary and foreign keys. Based on this analysis, you will create Database Schema, relational tables..

  Define health care database systems

Define health care database systems. Describe how databases are used across the health care industry. Explain the different database architectures including the relational architecture.

  Diagram of the table containing the initial data

Diagram of the table containing the initial data - state how you checked that the XML file is well-formed and what messages are sent if it is not well-formed?

  Create a query to delete the existing records

Create a spreadsheet that includes a list of the students - you need to create a query to Delete the existing records

  Discuss the main characteristics of the database approach

Please submit at least 250 words for this portion of the discussion forum. Discuss the main characteristics of the database approach and how it differs from traditional file systems. With what other computer system software does a DBMS interact

  Developing a household inventory database

For this Final Project you will be designing and developing a Household Inventory Database (HID). You will be creating tables, relationships, queries, forms, and reports

  Part 1 - using the data items given below construct an rea

part 1 - using the data items given below construct an rea diagram entities participation cardinalities relationships.

  Binary 1-n relationship-optional-to-optional relationship

Give examples of binary 1:N relationships, for (a) an optional-to-optional relationship, (b) an optional-to-mandatory relationship,

  Calculate the percentage of time

Let us have a 20MIPS processor, you have to calculate the percentage of time it spends in busy wait loop of a 75-character line printer, when it takes 2 msec to print a character and a total of 665 instructions require to be executed to print a 75..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd