Description of this paper

Loading

Assignment: Write SQL VIEW Queries for the following relations.-(Answered)

Description

Step-by-step Instant Solution


Question

Assignment:

Write SQL VIEW Queries for the following relations.

PART (partID, name, brand, type, retailPrice)

SUPPLIER (suppID, name, address, countryID, phone)

PART_SUPPLIER (partID, suppID, qty, cost)

COUNTRY (countryID, name, regionID)

REGION (regionID, name)

Write a SQL query which creates a view containing the following attributes of the SUPPLIER relation.

suppID, name, address.

Write a SQL query which creates a view containing the following attributes from the PART and the SUPPLIER relations.

PART (partID, pName, retailPrice)

SUPPLIER (suppID, sName, phone)

Add a supplier through the view with the following information; , , .

Change supplier?s phone number by 9876543 whose .

Delete the view created in 1st query.
?

NOTE:

???? Every query must be executed through views.

Deadline date:

Your assignment must be uploaded/submitted before or on 22/5/2016

Assignment Topic:

The topic of the assignment is SQL VIEW Statements.

Uploading instructions:

Please view the assignment submission process document provided to you by the Virtual University to upload the assignment.

Assignment submission through email is highly discouraged.

Save your assignment with your ID (e.g. bx020200786.doc).

Rules for Marking:

It should be clear that your assignment will not get any credit if:

The assignment is submitted after due date.

The assignment is copied.

Objective:

  • This assignment has been designed so that you understand the concept of SQL VIEW Statements.

Assignment submission instructions:

Your assignment should be in .doc format.


1) Write a SQL query which creates a view containing the following attributes of the

 

SUPPLIER relation.

 

suppID, name, address.

 

CREATE VIEW view_Supplier

 

AS (SELECT suppID, [name], address FROM...

 

Paper#9256683 | Written in 27-Jul-2016

Price : $16
SiteLock