Question 142 Consider the relation account (customer, balance) where customer is a primary key and there are no null values. We would like to rank customers […]
Question 141 Consider the relation “enrolled(student, course)” in which (student, course) is the primary key, and the relation “paid(student, amount)” where student is the primary key. […]
Question 35 A company maintains records of sales made by its salespersons and pays them commission based on each individual’s total sales made in a year. […]
Question 34 A table ‘student’ with schema (roll, name, hostel, marks), and another table ‘hobby’ with schema (roll, hobbyname) contains records as shown below: Table: Student […]