Đã hoàn thành

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.

Kĩ năng: SQL, MySQL, Lập trình cơ sở dữ liệu, Quản trị cơ sở dữ liệu, Microsoft SQL Server

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Nepal

ID dự án: #28373514

Được trao cho:

kietlt10988

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

$20 USD trong 1 ngày
(19 Đánh Giá)
5.5

2 freelancer chào giá trung bình$25 cho công việc này

dataEntryExperty

will do it for you. How much time do you have. Please let me know if more details on chat. Already completed many projects

$30 USD trong 1 ngày
(12 Nhận xét)
3.3