DATABASE questions

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.

Навыки: SQL, MySQL, Программирование баз данных, Управление базами данных, SQL-сервер Microsoft

Показать больше: can use google maps api web site, can use upload vbnet, can use php multi mail system, can use static nat, livejasmin account credits can use, can use develop order tracking softwares, use excel calculate stat, can use worldpay authorizenet, free hypnotic sales letter words can use, can use shape file google maps, can use php code ebay, sql copy database can use aspnet project, can use html search excel database, can use access database wordpress, can use database version prestashop, i want a formula that i can use on excel to calculate my age for to days date, Use function lm(y ∼ poly(x,i)) to train your model, here i is the flexibility from 1 to 20. Hint: you can use for loop for t, which of the following methods does google use to calculate store visits, which of the following you can use to load the windows os with only basic files and drivers

ID проекта: #28373514