Description of this paper

Loading

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

Description

Step-by-step Instant Solution


Question

HI, Could you help me with the attached assignment? please let me know . Thanks?


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)

 


 

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

 

2)

 


 

3)

 

4)

 

5)

 


 

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; id=10, name=Abdullah,

 

phone=1234567.

 

Change supplier?s phone number by 9876543 whose id=10.

 

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.

 

o

 

o

 


 

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:

 

o

 

o

 


 

The assignment is submitted after due date.

 

The assignment is copied.

 


 

Objective:

 

o 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.

 


 

 

Paper#9256873 | Written in 27-Jul-2016

Price : $16
SiteLock