Add the following data to the FEE table. Billy Elliot was charged last year on Jan 20th.
Fantastic news! We've Found the answer you've been seeking!
Question:
Add the following data to the FEE table.
![Billy Elliot was charged last year on Jan 20th. He is a student at Queens University and paid the student](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/65152ffd440c8_1695887357277.jpg)
![P FeePK FeeDescription DateCharged FeeCharged. FEE_CC F Service CC_ServicelD GUEST CC GuestID IF Fee_CC_PK](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/651530052b720_1695887365693.jpg)
Transcribed Image Text:
Billy Elliot was charged last year on Jan 20th. He is a student at Queens University and paid the student lower rate of $30 per day. Because he is a loyal guest he didn't need to pay a deposit on Jan 20th. (this means you need to store a record showing the guest was charged a deposit of 0.00) Justin Hackman paid last year a discount rate of $35 per day and a deposit of $20 because he is a smoker. He was charged the room rate for Feb 2nd, 8th, 17th, and 28th Deena Donor was charged last year on the 1** of every month from January through to April. Because of her position, she is not charged a deposit or room rate. (this means you need to record the room rate being 0.00 and the deposit being 0.00 for each 1" of the month) Billy Elliot was charged last year on Jan 20th. He is a student at Queens University and paid the student lower rate of $30 per day. Because he is a loyal guest he didn't need to pay a deposit on Jan 20th. (this means you need to store a record showing the guest was charged a deposit of 0.00) Justin Hackman paid last year a discount rate of $35 per day and a deposit of $20 because he is a smoker. He was charged the room rate for Feb 2nd, 8th, 17th, and 28th Deena Donor was charged last year on the 1** of every month from January through to April. Because of her position, she is not charged a deposit or room rate. (this means you need to record the room rate being 0.00 and the deposit being 0.00 for each 1" of the month)
Expert Answer:
Answer rating: 100% (QA)
t seems like you want to add data to a FEE table for different guests Assuming you have a table stru... View the full answer
Related Book For
Managerial accounting
ISBN: 978-0471467854
1st edition
Authors: ramji balakrishnan, k. s i varamakrishnan, Geoffrey b. sprin
Posted Date:
Students also viewed these databases questions
-
Gary's TV had the following accounts and amounts in its financial statements on December 31, 2022. Assume that all balance sheet items reflect account balances at December 31, 2022, and that all...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Write a nonrecursive function that takes the first Node in a linked list as an argument and reverses the list, returning the first Node in the result.
-
In the model of an oligopoly with identical (homogeneous) products, what is the price likely to be?
-
Your manager says they think we might have a revenue leakage issue at Nexford University, what process do you follow to investigate? PLEASE DO FAST AND CORRECT need correct answer
-
Do you offer free information? Avoid organizations that charge for information or demand details about your problem first.
-
Boilermaker House Painting Company incurs the following transactions for September. 1. Paint houses in the current month for $25,300 on account. 2. Purchase painting equipment for $12,600 cash. 3....
-
Analyze Results of Non Financial Intiatives McKenzie Tax Services is a company serving 72 clients (as of the beginning of last month) that is working on reorganizing its balanced scorecard....
-
1. The heritability of BPD is on par with other major psychiatric illnesses. A. True B. False 2. BDP is overdiagnosed A. True B. False 3. Self-injury is not usually associated with an intent or wish...
-
3. Find the derivate 1 for each of the following functions a. g(x) = ecos(x) b. f(x)=(5x7+sin(2x)) In(tan(x)) c. h(x): = tan(x2) log10(sec(x))
-
Mijka Company was started on January 1, Year 1. During Year 1, the company experienced the following three accounting events: 1. earned cash revenues of $32,500 2. paid cash expenses of $14,500 3....
-
Q2. Find the equations of the tangent and normal to the curve x3 + y = 2 at (1, 1). Q3. Find if y dx y= :xsinx + (sinx)cosx [10] [10]
-
Assume you have been given $400,000 CAD with access to all listed stocks, bonds, futures, and options worldwide. You can trade in options and futures, in combination with the underlying asset....
-
The formula weight (FW) of a gas can be determined using the following form of the ideal gas law FW = g R T / PV where g is the mass in grams, R is the gas constant, T is the temperature in Kelvin, P...
-
Consider a game in which a fair die is thrown. The player pays $5 to play and wins $2 for each dot that appears on the roll. Define X = number on which the die lands, and Y = player's net profit...
-
JC Construction took out a $250,000 loan to buy new equipment. The loan is subject to a 12% Interest rate compounded annually for 7 years. What would be the total owed at the end of the loans term?...
-
1. What are some current issues facing Saudi Arabia? What is the climate for doing business in Saudi Arabia today? 2. Is it legal for Auger's firm to make a payment of $100,000 to help ensure this...
-
Name one important difference between the reciprocal method and the step-down method.
-
OConner and Company provide you with the following data regarding their transportation costs. Required: a. Using regression analysis, estimate OConners monthly fixed costs and the cost per case...
-
Brandt Heating and Cooling is a reputed HVAC (heating, ventilation, and air-conditioning) contractor. Tim Brandt has a reputation for doing quality work and for treating the customer right. Brandt...
-
14. Assume in problem 12 that the city reports the work as a capital asset. Which ofthe following is true? a. Depreciation is not recorded because the city has no cost. b. Depreciation is not...
-
7. Which of the following is true for the Year 2 government-wide financial statements? a. Both expense and liability will be zero. b. Both expense and liability will be $110,000. c. Expense will be...
-
10. What liability should the city report on government-wide financial statements at the end ofYear 1? a. It depends on whether the employees work at governmental activities or business-type...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App