Database Management SystemTU Board 2020
Consider a database system with following schemes: Restaurant(Rname, Rlocation, Rfund) Cook(Cname, Cspeciality) Worksat(Cname, Rname, Workinghrs, Shift) Food(Fname, Cname, Catagory) Now write SQL…
10Consider a database system with following schemes: Restaurant(Rname, Rlocation, Rfund) Cook(Cname, Cspeciality) Worksat(Cname, Rname, Workinghrs, Shift) Food(Fname, Cname, Catagory) Now write SQL statements and relational algebra statements for following Queries: a) Select the name and location of all restaurants. b) Find the working hours of cook named "Sita". c) Select name of the foods cooked by "Ramesh". d) Use join to select name of restaurants where food of category "breakfast" is available. e) Find the name of cooks who work as "KFC"
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