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 […]
July 13, 2020

Pick A pet

7.1 Output Design Prototypes 7.1.1 Design and implement (with data that is important to the management) 3 reports for management, 1 detailed, 1 exception, and 1 […]