Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Still stuck on this please help. Hide Assignment Information Instructions Transaction Log Exercise Instructions: 1. Create a new database called TransLogDb 2. Create a table

Still stuck on this please help.

Hide Assignment Information

Instructions

Transaction Log Exercise

Instructions:

1. Create a new database called TransLogDb

2. Create a table called Students

Add 5 columns

Add 5 records to the table

The table should be well formed with a unique identifier

Each field must be flagged as NULL or NOT NULL in scope

3. Write a SQL script/statement to check 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 - TWO 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions