Solution-Display the data in the view

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.

User Account

All Pages

Display the data in the view

Reference no: EM13932807

Reference no: EM13932807

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT