Transaction Log Lecture notes (see the attachment) & the video link : https://www.youtube.com/watch?v=rPfncf8W1MA&feature=emb_logo Instructions: 1. Create a test database called dbLog 2. Create a...

Transaction Log

Lecture notes (see the attachment) & the video link :
https://www.youtube.com/watch?v=rPfncf8W1MA&feature=emb_logo

Instructions:

1. Create a test database calleddbLog

2. Create a table calledtbl_Locationwith 3 columns: [LocIDINT PK, Date DATETIMEDefault GetDate(), City CHAR(25) NOT NULL]

3. Add two records to the table for cities - Miami and Los Angeles

Write a SQL script/statement tocheck the log file for the newly created database to check what processes and steps SQL Server took to create the database and table.

What to Submit

1.A Zipped folder with the following files:

a. A single SQL file with all queries

b. A Word file with all screenshots of the database, table and records in the table, transaction log result screen

Naming convention of all files:
firstnameLastname_Module2Assignment.fileextension(.sql or .docx)