Database Management SystemTU Board 2026
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…
10Consider 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 laundry service. e. Give 10% discount to female guests on the price of service they receive. [3+2+2+1+2]
A worked answer is on its wayMeanwhile, read the Database Management System notes for this topic.
Discussion
Loading…
More Database Management System questions
Define transaction. Describe ACID properties with example. [1+4]TU Board 20265Explain physical data independence and logical data independence. [2.5+2.5]TU Board 20265What is stored procedure? Describe statement level trigger and multi row enabled trigger? [1+4]TU Board 20265Define schedule and serializability with example. How can you test the serializability? [2+3]TU Board 20265What is data model? What are its types? [1+4]TU Board 20265Define query processing and steps in query processing. [1+4]TU Board 20265