SQL DATABASE

create developer design documentation using an Excel spreadsheet

I need to create fact table and dimention table base on the first capture I have linked here. So far for excel spreadsheet just contain rough draft.

The OLTP source Database consists of the following tables Classrooms CourseSessions Students Column Name Condensed Type Nullable ? ClassroomlD int Column Name Condensed Type Nullable CourselD int Column Name Condensed Type Nullable g StudentlD int No No nvarchar(100) No Yes No nvarchar(70) No nvarchar(60) No nvarchar(55) No ? ClassroomlD int No FName Name ? Date BuildinglD int Start End es Email es Buildings Enrollments Column Name Condensed Type Nullable uildingD int Name Column Name Condensed Type Nullable nvarchar(100 No Courses ? EnrollmentlD int No CourselD int No Column Name Condensed Type Nullable CourselD int Name StudentlD int nvarchar(80) No EnrollmentD... date No ourc Database Table EnrollmentTracker EnrollmentTracker.dbo.Classrooms EnrollmentTracker.dbo.ClassroomID EnrollmentTracker.dbo.Classroom Name EnrollmentTracker.dbo.BuildingD EnrollmentTracker.dbo.Buildings EnrollmentTracker.dbo.Building D DWEnrollmentTracker EnrollmentTracker.dbo.Classrooms EnrollmentTracker.dbo.ClassroomID EnrollmentTracker.dbo.Classroom Name EnrollmentTracker.dbo.BuildinglD EnrollmentTracker.dbo.Buildings EnrollmentTracker.dbo.BuildinglD EnrollmentTracker.dbo.BuildingName EnrollmentTracker.dbo.CourseSessions EnrollmentTracker.dbo.CourselD EnrollmentTracker.dbo.ClassroomID EnrollmentTracker.dbo.Date EnrollmentTracker.dbo.Start EnrollmentTracker.dbo.End EnrollmentTracker.dbo.Courses EnrollmentTracker.dbo.CourselD EnrollmentTracker.dbo.CourseName EnrollmentTracker.dbo.CoursePrice EnrollmentTracker.dbo. Students EnrollmentTracker.dbo.StudentsiD EnrollmentTracker.dbo.FName EnrollmentTracker.dbo.LName EnrollmentTracker.dbo.StudentEmail EnrollmentTracker.dbo.Enrollments EnrollmentTracker.dbo.EnrollmentID EnrollmentTracker.dbo.CourselD EnrollmentTracker.dbo.StudentID EnrollmentTracker.dbo.Price Data Warehouse Database Table nchart5) nvarchar(50) nchar(5) Table nchar(5) nvarcharfS0) Table nchar(5) nchar(5) nvarchar(100) IlmentTracker.dbo.BuildingVame nvarchari100) Table EnrollmentTracker.dbo.CourseSessions EnrollmentTracker.dbo.CourselD EnrollmentTracker.dbo.ClassroomID EnrollmentTracker.dbo.Date EnrollmentTracker.dbo. Start EnrollmentTracker.dbo.End EnrollmentTracker.dbo.Courses EnrollmentTracker.dbo.CourselD EnrollmentTracker.dbo.CourseName EnrollmentTracker.dbo.CoursePrice EnrollmentTracker.dbo.Students EnrollmentTracker.dbo.StudentsiD EnrollmentTracker.dbo.FName EnrollmentTracker.dbo.LName NA. NA Table nchar(5) nvarchar(80) decimal(18,4) Table nchar(5) nvarchart50) nvarchar(50) nvarcharf50) Table nchar(5) nchar(5) nchar(5) decmal(18,4) Int Dimesnion Table nvarchar(80) Dimension Table Table nvarchart70) nvarchar(60) nvarcharf55) IlmentTracker.dbo. StudentEmail EnrollmentTracker.dbo.Enrollments EnrollmentTracker.dbo.EnrollmentID EnrollmentTracker.dbo.CourselD EnrollmentTracker.dbo.StudentID EnrollmentTracker.dbo.Price EnrollmentTracker.dbo.EnrollmentDate int EnrollmentTracker.dbo.Enrollment Date EnrollmentTracker.dbo.FactEnrollmentCources Fact Table EnrollmentTracker.dbo.FactEnrollmentID The OLTP source Database consists of the following tables Classrooms CourseSessions Students Column Name Condensed Type Nullable ? ClassroomlD int Column Name Condensed Type Nullable CourselD int Column Name Condensed Type Nullable g StudentlD int No No nvarchar(100) No Yes No nvarchar(70) No nvarchar(60) No nvarchar(55) No ? ClassroomlD int No FName Name ? Date BuildinglD int Start End es Email es Buildings Enrollments Column Name Condensed Type Nullable uildingD int Name Column Name Condensed Type Nullable nvarchar(100 No Courses ? EnrollmentlD int No CourselD int No Column Name Condensed Type Nullable CourselD int Name StudentlD int nvarchar(80) No EnrollmentD... date No ourc Database Table EnrollmentTracker EnrollmentTracker.dbo.Classrooms EnrollmentTracker.dbo.ClassroomID EnrollmentTracker.dbo.Classroom Name EnrollmentTracker.dbo.BuildingD EnrollmentTracker.dbo.Buildings EnrollmentTracker.dbo.Building D DWEnrollmentTracker EnrollmentTracker.dbo.Classrooms EnrollmentTracker.dbo.ClassroomID EnrollmentTracker.dbo.Classroom Name EnrollmentTracker.dbo.BuildinglD EnrollmentTracker.dbo.Buildings EnrollmentTracker.dbo.BuildinglD EnrollmentTracker.dbo.BuildingName EnrollmentTracker.dbo.CourseSessions EnrollmentTracker.dbo.CourselD EnrollmentTracker.dbo.ClassroomID EnrollmentTracker.dbo.Date EnrollmentTracker.dbo.Start EnrollmentTracker.dbo.End EnrollmentTracker.dbo.Courses EnrollmentTracker.dbo.CourselD EnrollmentTracker.dbo.CourseName EnrollmentTracker.dbo.CoursePrice EnrollmentTracker.dbo. Students EnrollmentTracker.dbo.StudentsiD EnrollmentTracker.dbo.FName EnrollmentTracker.dbo.LName EnrollmentTracker.dbo.StudentEmail EnrollmentTracker.dbo.Enrollments EnrollmentTracker.dbo.EnrollmentID EnrollmentTracker.dbo.CourselD EnrollmentTracker.dbo.StudentID EnrollmentTracker.dbo.Price Data Warehouse Database Table nchart5) nvarchar(50) nchar(5) Table nchar(5) nvarcharfS0) Table nchar(5) nchar(5) nvarchar(100) IlmentTracker.dbo.BuildingVame nvarchari100) Table EnrollmentTracker.dbo.CourseSessions EnrollmentTracker.dbo.CourselD EnrollmentTracker.dbo.ClassroomID EnrollmentTracker.dbo.Date EnrollmentTracker.dbo. Start EnrollmentTracker.dbo.End EnrollmentTracker.dbo.Courses EnrollmentTracker.dbo.CourselD EnrollmentTracker.dbo.CourseName EnrollmentTracker.dbo.CoursePrice EnrollmentTracker.dbo.Students EnrollmentTracker.dbo.StudentsiD EnrollmentTracker.dbo.FName EnrollmentTracker.dbo.LName NA. NA Table nchar(5) nvarchar(80) decimal(18,4) Table nchar(5) nvarchart50) nvarchar(50) nvarcharf50) Table nchar(5) nchar(5) nchar(5) decmal(18,4) Int Dimesnion Table nvarchar(80) Dimension Table Table nvarchart70) nvarchar(60) nvarcharf55) IlmentTracker.dbo. StudentEmail EnrollmentTracker.dbo.Enrollments EnrollmentTracker.dbo.EnrollmentID EnrollmentTracker.dbo.CourselD EnrollmentTracker.dbo.StudentID EnrollmentTracker.dbo.Price EnrollmentTracker.dbo.EnrollmentDate int EnrollmentTracker.dbo.Enrollment Date EnrollmentTracker.dbo.FactEnrollmentCources Fact Table EnrollmentTracker.dbo.FactEnrollmentID