For the below given schema diagram develop a SQL query to find the guest name whose total bill amount is more than 50,000. RESORT MANAGEMENT SYSTEM Town Manager Pointofinterest PK towniD Number PK pointiD describe Varchar(30) Number PK managerID Number Varchar(30) varchar(30) varchar(30) varchar(30) townname varchar(30) varchar(30) varchar(20) varchar(15) name state opentime varchar(10) address 主 longitude city closetime varchar(10) Number latitude FK townlD phone summertemp wintertemp sealevel Number Number Number GIVES Resort Guest Review PK resortiD Number PK guestiD Number Number Number FK,PK guestiD varchar(30) varchar(30) varchar(30) resortName varchar(30) varchar(30) + name FK,PK resortiD street MANCES address dateofreview Date townname country varchar(20) BOOKS varchar(150) townid Number varchar(30) varchar(15) email comments FK phone starRating Number FK managerID Number Booking HAS PK bookingID Number CabinCost FK guestid Number HAS FK,PK resortiD Number FK resortiD Number cabiniD Number FK,PK FK cabiniD Number Cabin fromdate Date PK startdate Date FK,PK resortiD HAS Number enddate Date todate Date PK cabiniD Number HAS PK adultCount Number Number rate childCount Number varchar(30) + describe petcount Number cabintype varchar(10) totalcharge Number bedroomcount Number sleepcapacity Number
For the below given schema diagram develop a SQL query to find the guest name whose total bill amount is more than 50,000. RESORT MANAGEMENT SYSTEM Town Manager Pointofinterest PK towniD Number PK pointiD describe Varchar(30) Number PK managerID Number Varchar(30) varchar(30) varchar(30) varchar(30) townname varchar(30) varchar(30) varchar(20) varchar(15) name state opentime varchar(10) address 主 longitude city closetime varchar(10) Number latitude FK townlD phone summertemp wintertemp sealevel Number Number Number GIVES Resort Guest Review PK resortiD Number PK guestiD Number Number Number FK,PK guestiD varchar(30) varchar(30) varchar(30) resortName varchar(30) varchar(30) + name FK,PK resortiD street MANCES address dateofreview Date townname country varchar(20) BOOKS varchar(150) townid Number varchar(30) varchar(15) email comments FK phone starRating Number FK managerID Number Booking HAS PK bookingID Number CabinCost FK guestid Number HAS FK,PK resortiD Number FK resortiD Number cabiniD Number FK,PK FK cabiniD Number Cabin fromdate Date PK startdate Date FK,PK resortiD HAS Number enddate Date todate Date PK cabiniD Number HAS PK adultCount Number Number rate childCount Number varchar(30) + describe petcount Number cabintype varchar(10) totalcharge Number bedroomcount Number sleepcapacity Number
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
wevsv
Transcribed Image Text:For the below given schema diagram develop a SQL query to find the guest name whose total bill
amount is more than 50,000.
RESORT MANAGEMENT SYSTEM
Town
Pointofinterest
Manager
Number
Varchar(30)
varchar(30)
varchar(30)
Number
PK
townlD
Number
PK
pointiD
PK
managerlD
townname
varchar(30)
varchar(30)
varchar(20)
varchar(15)
describe Varchar(30)
name
state
address
opentime varchar(10)
主
longitude
closetime varchar(10)
city
latitude
varchar(30)
Number
phone
FK
townID
summertemp
Number
wintertemp
Number
sealevel
Number
GIVES
Resort
Guest
Review
PK resortID
Number
PK
guestiD
Number
FK,PK guestiD
FK,PK resortiD
Number
Number
varchar(30)
varchar(30)
varchar(30)
resortName
varchar(30)
varchar(30) +
varchar(20)
varchar(30)
varchar(15)
name
street
MANACES
address
dateofreview Date
townname
country
BOOKS
varchar(150)
Number
email
comments
FK townid
phone
starRating
Number
FK manageriD
Number
Booking
HAS
PK bookingID
Number
CabinCost
FK guestid
Number
HAS FK,PK
resortiD
Number
FK resortID
Number
FK,PK
cabiniD
Number
FK cabiniD
Number
Cabin
fromdate
PK
startdate
Date
Date
todate
FK,PK resortID
HAS
Number
enddate
Date
PK
Date
HAS
PK
cabinID
Number
adultCount
Number
rate
Number
varchar(30) +
varchar(10)
childCount
Number
describe
petcount
Number
cabintype
totalcharge
Number
bedroomcount Number
sleepcapacity
Number
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY