Questions from Database Systems

Q: Create a stored procedure named prc_new_rental to insert

Create a stored procedure named prc_new_rental to insert new rows in the RENTAL table. The procedure should satisfy the following conditions. a. The membership number will be provided as a parameter....

Q: Create a stored procedure named prc_new_detail to insert

Create a stored procedure named prc_new_detail to insert new rows in the DETAILRENTAL table. The procedure should satisfy the following requirements. a. The video number will be provided as a paramet...

Q: Create a stored procedure named prc return_video enter data about

Create a stored procedure named prc return_video enter data about the return of videos that had been rented. The procedure should satisfy the following requirements. a. The video number will be provi...

Q: What is the relationship between the SDLC and the DBLC?

What is the relationship between the SDLC and the DBLC?

Q: Write a query to display the manager name, department name,

Write a query to display the manager name, department name, department phone number, employee name, customer name, invoice date, and invoice total for the department manager of the employee who made a...

Q: Write a query to display the book number, title, and

Write a query to display the book number, title, and year of publication for all books that contain the word “Database” in the title, regardless of how it is capita...

Q: Write a query to display the patron ID, first and last

Write a query to display the patron ID, first and last name of all patrons that are students (See Figure P7.81). (44 rows) FIGURE P7. 81 Student Patrons

Q: Write a query to display the patron ID, first and last

Write a query to display the patron ID, first and last name, and patron type for all patrons whose last name begins with the letter “C” (See Figure P7.82). FIGURE P...

Q: Write a query to display the author ID, first and last

Write a query to display the author ID, first and last name of all authors whose year of birth is unknown (See Figure P7.83). FIGURE P7. 83 Authors with Unknown Birth Year

Q: Write a query to display the author ID, first and last

Write a query to display the author ID, first and last name of all authors whose year of birth is known (See Figure P7.84). FIGURE P7. 84 Authors with Known Birth Year