Need help with this problem. I added the ERD below with it so you can see the ta

Question

Need help with this problem. I added the ERD below with it so you can see the tables and keys. Would like for the answer to be in Microsoft Sql Server, not Oracle.

Stu Tech ID Art, Money Cash MrnumPeges 800 400 800 000 000 800 Assume it's a first day of a semester, you have vour campus tard with your vou loaded some emounte your sempua cash. Now want to find out the minimum of that vau cae with the tatal amount (campuu end can money have in vour write a view to display the stu Tech-ID and the mininum ramber pages HINT Use Prints and card table

Explanation / Answer

Create view print_pages as select Stu_Tech_Id,Print_Money,Campus_Cash,((Campus_Cash+Print_Money)/Print_Unit_Cost) as Minimum_Pages from CARD,PRINTS where CARD.Stu_Tech_Id=STUDENT.Stu_Tech_Id and STUDENT.Stu_Tech_Id=PRINTTRANSACTION.Stu_Tech_Id and PRINTTRANSACTION.PrintID=PRINTS.PrintID;

The above is the view which will results studentid ,his toatl and the no of pages he can print.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---