Database design and optimisation

September 7, 2020

Visio Assignment

After reviewing Appendix C of Hands-On Database, use Visio to re-create one of the E-R diagrams provided in Appendix F of Database Design for Mere Mortals. […]
September 7, 2020

Scenario Activity

Vince Roberts runs a vintage record shop in the University district. His shop sells 45s, LPs, and even old 76 RPM records. Most of his stock […]
September 1, 2020

Transaction control procedure

Transaction control*** Create a stored procedure with the following requirements:      Accept input that identifies the customer, the ISBN for one book, and the quantity […]
August 7, 2020

SQL Stored Procedures

Create a stored procedure NEWGUESTBOOKING that adds a booking for a new guest. The stored procedure NEWGUESTBOOKING receives the following parameters Input ParametersGuest nameGuest addressHotelNoRoomNodateFromdateTo Output […]