For this question I have to get the same input as what is above the question. I

Question

For this question I have to get the same input as what is above the question. I placed the tables and the values and the ERD. I need to write the VIEW in SQL in Microsoft SQL not oracle. I am using SQL Server 2012

Stu Tech ID Print Money Campus Cash Minimum Pages 12345678 8.000 300.00 4.00 23456789 8.00 0.00 200.00 34567890 8.00 200.00 0.00 Assume it's a first day of a semester, you have your campus card with you; you loaded some amount in your campus cash. Now you want to find out the minimum number of pages that you can print with the total amount (campus cash and print money) you have in your card. Write a view to display the stu Tech ID and the minimum number of pages you can print. 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 total and the no of pages he can print.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.