Data Warehouse Dimension Model Assignment Help | Project | Homework Problem Solution

At DatabaseHomeworkHelp we are opening the gates for data warehouse dimension model assignment help. If you are looking to get some data warehouse dimension model homework help you came on right platform. We took the responsibility of creating help with data warehouse dimension model assignment.

While designing data warehouse help with data warehouse dimension model project becomes vital for students. We promise to get more marks for you if you want data warehouse dimension model problem solution. We can really create the higher position in academia for you with our data warehouse dimension model project help. Learning is passion for many students and nothing can be more perfect for this other than our data warehouse dimension model online expert tutor service.

Our way is to get more knowledge in DBMS than anyone to give you data warehouse dimension model assignment help. Success for students we create is our success which is not possible if help with data warehouse dimension model assignment is not there. We call everyone to try us for our help data warehouse dimension model project once, and let us give you the data warehouse dimension model problem solution from professionals. All those who got our data warehouse dimension model project help consider themselves lucky as we actually made possible to get more marks for them.

Data warehousing is to place the right data at right place so that retrieving of it is quite easy and fast for the decision makers. Data warehousing dimension models is to reflect the capability and natural performance with proper measurement along with descriptive attributes of a business.

Note:-The assignment shown below is the property of databasehomeworkhelp website. This has put here in order to tell you more on our sample assignment capabilities. Also make a note that the below assignment is not our previous solution that our tutors has provided for our students. We never share them with anyone in order to maintain privacy, quality and rigor that we maintain on all our homework.

Task:

The objective of this project is to facilitate the administration staff of the RISD to enhance their performance while compiling the results and grading the students. This system also helps in maintaining the student record and teacher records for the particular class and subject. The data warehouse will help in building reports very quickly and real time data can be analyzed in no time as well as the historical data is also available

Solution:-                                   DIMENSIONAL MODEL

dm

Question:-  To get the schema details for the entities like students,class,test, test result, subject, teacher, teacher teaching the subjects.

Solution: – The following entities are,.

Dim_ Students:

Attributes date Type Constraints Key Comments
StudentId Number(4) Unique, NotNull Primarykey PK for student table
First_Name Varchar2(20) Not Null
Last_Name Varchar2(20)
DOB DateTime NotNull
Address Varchar(50) notNull
Contact_Number Number(11) NotNull
State Varchar(150

Dim_Class

Attributes date Type Constraints Key Comments
ClassID Number(4) Unique, Not Null Primarykey PK for student table
ClassName Varchar2(20) Not Null
Level Varchar2(20)

Dim_Test

Attributes date Type Constraints Key Comments
TestID Number(4) Unique, Not Null Primary key PK for Test table
TestTitle Varchar2(20) Not Null Test title
NumberofQuestion Number(4) Number of question
Totalmarks Number(4) Not Null Total marks of test
Passing_score Number(4) Not Null Minimum passing marks
SubjectId Number(4) Not Null FK Foreign Key from subject

Dim_Test_Results_details

Attributes date Type Constraints Key Comments
TestID Number(4) Unique, Not Null Primary key PK for Test table
StudentId Varchar2(20) Not Null StudenID
Marks Obtained Number(4) Not Null  Marks obtained by student
Year date

 Dim_Subject:

Attributes date Type Constraints Key Comments
SubjectID Number(4) Unique, Not Null Primary key PK from subject table
SubjectName Varchar2(20) Not Null Subject Title
ClassId Number(4) FK FK from Class

Dim_Teacher:

Attributes date Type Constraints Key Comments
TeacherID Number(4) Unique, Not Null Primary key PK for teacher table
Name Varchar2(20) Not Null Name of the teacher
Salary Number(10) Not null
Address Varchar2(50)
Phone Number(15)

Dim_District

Attributes date Type Constraints Key Comments
districtID Number(4) Unique, Not Null Primary key PK for Dsitrict table
Districtname Varchar2(20) Not Null

Dim_campus

Attributes date Type Constraints Key Comments
campusID number Unique, Not Null Primary key PK for campus  table
districtID Number(4) FK FK from district table
Campusname Varchar2(20) Not Null

Teacher_subject:

Attributes date Type Constraints Key Comments
TeacherID Number(4) Unique, Not Null Primary key Fk from teacher table
SubjectId Number(4) Not Null Primary key Fk from subject table
Year date Not null

Student_subject:

Attributes date Type Constraints Key Comments
StudentID Number(4) Unique, Not Null Primary key Fk from Student table
SubjectId Number(4) Not Null Primary key Fk from subject table
Year date Not null
Result Boolean
Grade Varchar(30