Questions from Database Systems

Q: Write a query to display the movie title, movie year,

Write a query to display the movie title, movie year, and movie genre for all action movies (result shown in Figure P7.108). Figure P7.108 Action movies

Q: Write a query to display the movie number, movie title,

Write a query to display the movie number, movie title, and movie cost for all movies with a cost greater than $40 (result shown in Figure P7.109). P7.109 Movies costing more than $40

Q: Discuss the possible data request scenarios in a distributed database environment.

Discuss the possible data request scenarios in a distributed database environment. 1. Single request accessing a single remote database. (See Figure D12.1.) 2. Multiple requests accessing a single rem...

Q: Write a query to display the movie number, movie title,

Write a query to display the movie number, movie title, movie cost, and movie genre for all movies that are either action or comedy movies and that have a cost that is less than $50. Sort the results...

Q: Write a query to display the membership number, name, street

Write a query to display the membership number, name, street, state, and balance for all members in Tennessee (TN), with a balance less than $5, and whose street name ends in “Avenue...

Q: Write a query to display the movie genre and the number of

Write a query to display the movie genre and the number of movies in each genre (result shown in Figure P7.112). Figure P7.112 Number of movies in genre

Q: Write a query to display the average cost of all of the

Write a query to display the average cost of all of the movies (result shown in Figure P7.113). Figure P7.113 Average movie cost

Q: Write a query to display the movie genre and average cost of

Write a query to display the movie genre and average cost of movies in each genre (result shown in Figure P7.114). Figure P7.114 Average movie cost by genre

Q: Write a query to display the movie title, movie genre,

Write a query to display the movie title, movie genre, price description, and price rental fee for all movies with a price code (result shown in Figure P7.115). Figure P7.115 Rental fees for movies...

Q: Write a query to display the movie genre and average price rental

Write a query to display the movie genre and average price rental fee for movies in each genre that have a price (result shown in Figure P7.116). Figure P7.116 Average rental fee by genre