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. […]
