Write a query to be able to lower the max books

Assignment Help Database Management System

Reference no: EM132080213

Need help writing SQL for SQL Server.

The question is :

Question : If a student becomes a senior, you need to lower his/her maximum number of books to borrow from 4 (four) to 2 (two).

We have a student table. The student table contains a column called studentstatus which can hold the value of 0 or 1. 1 is for seniors and 0 is for juniors. We also have another column in the student table called Totalallowed int. Total allowed is the number of books that can be borrowed.

You just need to write a query to be able to lower the max books if the student is a senior.

Reference no: EM132080213

Questions Cloud

Determining the total revenue function : Cost, revenue, and profit are in dollars and x is the number of units. Suppose that the total revenue function is given by R(x) = 48x and that the total cost

Marginal cost predicts about the cost of producing : Tell what the marginal cost predicts about the cost of producing 2 additional units. The cost of producing 2 additional units is $

Forecasting cash flows using a budget : TLC is in its 4th year of operations. The company is experiencing cash flow issues and would like to utilize a budget to forecast cash flows.

How to form a system of equations : I am struggling with how to form a system of equations. One equation represents the amount of final mixture required and the other represents

Write a query to be able to lower the max books : Question : If a student becomes a senior, you need to lower his/her maximum number of books to borrow from 4 (four) to 2 (two).

Create a print function for the list that will print node : Create a print function for the list that will print the nodes in order. You will need to create some functions to support this functionality.

How much money will you have in the account : Today, you open a savings account and you plan to deposit $1,000 at the end of each year. (Your first deposit will be on December 31,2017)

Suppose that in a monopoly market : Total revenue is in dollars and x is the number of units. Suppose that in a monopoly market, the demand function for a product is given by p = 400 - 0.2x

Suppose that the total revenue function : Cost, revenue, and profit are in dollars and x is the number of units. Suppose that the total revenue function is given by R(x) = 48x and that the total cost

User Account

All Pages