﻿1. From the main menu in VS, go to View --> SQL Server Object Explorer

		Locate the (localdb)\ProjectsV13 server

		Right-click on the (localdb)\ProjectsV13 server and select New Query...


2. Run the following queries in the SqlQueries folder (in the order specified):

	IMPORTANT: Make sure you are connected to the right database
			When you open each Sql file, right-click on file and select Connection --> Connect...
			Expand Local, select ProjectsV13
			Specify the Database Name in the lower screen:  GoMovies2020



	1. 1_CreateDatabase.sql:				script to create the database
	2. 2a_CreateTables.sql:					script to create tables in the database

	IMPORTANT: You do NOT need to run 2b_DropTables (unless you want to delete the tables and start again)

	3. 3a_InsertData1_AgeRatings			script to insert sample data in to the AgeRating table
	4. 3b_InsertData2_TicketTypes			script to insert sample data in to the TicketType table
	5. 3c_InsertData3_Films					script to insert sample data in to the Film table
	6. 3d_InsertData4_FilmShowings			script to insert sample data in to the FilmShowing table

	7. 3e_InsertData5_Films_UpdatePosters	script to update the poster images in the Film table
