DATABASE questions
$10-30 USD
Thanh toán khi bàn giao
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.
ID dự án: #28373514
Về dự án
Được trao cho:
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 Thêm
2 freelancer chào giá trung bình$25 cho công việc này
will do it for you. How much time do you have. Please let me know if more details on chat. Already completed many projects