Consider the following schema: Guest (Gid, Gname, Age, Gender STAFF (Sid, Sname, Age, Gender, Roles SERVICE (serId, serName, Price) ASSISTS (Gid,…
BCA Database Management System · 2026 · Solved Question with Answer
Consider the following schema:
Guest (Gid, Gname, Age, Gender
STAFF (Sid, Sname, Age, Gender, Roles
SERVICE (serId, serName, Price)
ASSISTS (Gid, Sid) (Which staff assists which guest)
PROVIDES (serId, Sid) (Which staff provides which service)
Write SQL Queries:
a) Find name of guests who are VIP.
b) Find total number of guests assisted by staff Ram.
c) Find name of staff whose name starts with A and ends with A.
d) Display name of staff who provides laundary service.
e) Give 10% discount to female guests on the price of service they receive.