SQL – Creating Views
In this series, we will build and enhance the a hotel booking database.
Series 1 Objectives – Create Views
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper NowCreate the bookingdb environment by downloading the bookingdb.zip file attached in this Assignment.
Review the base tables that is created. Code SQL to create a VIEW for each base table. The viewname should begin with ‘v’+basetablename. The CREATE VIEW statement should code all the existing columns in the SQL portion of the statement.
Review the lesson that created the guestmessage table and create a guestmessage base table in this bookingdb. Create a VIEW for the guestmessage table.
In this series, we will learn to create views of the base tables, create stored procedures using the views, and create triggers for insert, update and delete events on the booking table.
Upon completion of the above, export the whole database and zip it. Rename it to bookingdbSeries1.zip and upload
