Question: re-create the BIClass Database Star Schema using the FileUpload.OriginallyLoadedData table1. 3. You will add additional columns to all tables in this project 4. You create

re-create the BIClass Database Star Schema using the FileUpload.OriginallyLoadedData table1. 3. You will add additional columns to all tables in this project 4. You create a table called Process.WorkflowSteps

WorkFlowStepKey INT IDENTITY(1,1) NOT NULL, -- pimary key WorkFlowStepDescription NVARCHAR(100) NOT NULL, WorkFlowStepTableRowCount INT NULL DEFAULT (0), StartingDateTime DATETIME2(7) NULL DEFAULT (SYSDATETIME()) , EndingDateTime DATETIME2(7) NULL DEFAULT (SYSDATETIME())

5. Document your stored procedures 6. You create a stored procedure called Process.usp_TrackWorkFlow 7. You will create stored procedures to load each of the individual tables into the star schema. 8. Completion create a stored procedure Process.usp_Show WorkflowSteps of a query of the Process.WorkflowSteps table.

please do it steps by step

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!