SQL – Creating Views

In this series, we will build and enhance the a hotel booking database.

Series 1 Objectives – Create Views

Create 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

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply