DATABASE questions
$10-30 USD
Paid on delivery
1. Create a view GRANTS INFO (Instructorld, Instr Type, AccountNo, FName, LName, Grant Title, Source, CurrBalance) that retrieves the info about each Grant and the instructors associated with it. The view should
have the attributes renamed as: (lld, IType, ANo, FN, LN, GTitle, Source, and CBal) and be ordered by Grant title in the descending order.
2. Can you use the following query to calculate the sum of the current balance left in each of the Grants from the view GRANTS INFO?
SELECT SUM(CBal)
FROM grants_info
if No, then why not? If No, then give another query that can help you get the correct amount. If yes, then explain
how?
3. Write an SQL query that uses the view GRANTS_INFO to find the number of Instructors associated with each
GrantTitle.
4. Write the corresponding Relational Algebra expression.
Project ID: #28373514
About the project
Awarded to:
Hi there, I am an experience T-SQL developer with more than 9 years experience. I am able to done any kind of project using this skill. I have done many prj like this and always got 5 starts and positive feedback from More
2 freelancers are bidding on average $25 for this job
will do it for you. How much time do you have. Please let me know if more details on chat. Already completed many projects
