Step-by-step Instant Solution
HI, Could you help me with the attached assignment? please let me know . Thanks?
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
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,
Change supplier?s phone number by 9876543 whose id=10.
Delete the view created in 1st query.
Every query must be executed through views.
Your assignment must be uploaded/submitted before or on 22/5/2016
The topic of the assignment is SQL VIEW Statements.
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.
o This assignment has been designed so that you understand the concept of SQL VIEW
Assignment submission instructions:
Your assignment should be in .doc format.
Paper#9256873 | Written in 27-Jul-2016Price : $17.85