10 UMLClass 230 30 130 250 Sales Fact -- bg=pink Price Discount VAT Total Cost NumberOfItems BuyerID DateID TimeID ProductID CategoryID ShopID SaleTypeID StaffID UMLClass 500 20 130 150 Date_Dim bg=yellow -- DateID Day Week Month Quarter Semester Year UMLClass 10 20 130 100 Buyer_Dim -- BuyerID BuyerName IDNumber BuyerType UMLClass 500 180 130 130 Product_Dim bg=yellow -- ProductID ProductName Category Cost VATRating Supplier UMLClass 500 320 130 70 Category_Dim bg=yellow -- CategoryID CategoryDesc UMLClass 500 400 130 70 Shop_Dim bg=yellow -- ShopID ShopLocation Relation 350 60 170 120 lt=- fg=blue 10.0;100.0;150.0;10.0 Relation 130 40 120 120 lt=- fg=blue 100.0;100.0;10.0;10.0 Relation 350 180 170 50 lt=- fg=blue 10.0;10.0;150.0;30.0 Relation 350 200 170 170 lt=- fg=blue 10.0;10.0;150.0;150.0 Relation 350 210 170 240 lt=- fg=blue 10.0;10.0;150.0;220.0 UMLClass 230 310 130 220 Stock Control Fact -- bg=pink Price Discount VAT Total Cost NumberOfItems SupplierID DateID TimeID ProductID CategoryID ShopID StaffID Relation 350 60 170 400 lt=- 10.0;380.0;150.0;10.0 Relation 350 200 170 290 lt=- 10.0;270.0;150.0;10.0 Relation 350 340 170 170 lt=- 10.0;150.0;150.0;10.0 Relation 350 420 170 110 lt=- 10.0;90.0;150.0;10.0 UMLClass 10 200 130 110 Supplier_Dim -- SupplierID SupplierName SupplierAddress SupplierContact SupplierPhone Relation 130 220 120 220 lt=- 100.0;200.0;10.0;10.0 UMLClass 500 480 130 190 Student_Dim bg=yellow -- StudentID StudentName StudentAddress StudentPhone StudentEmail LibraryNumber StudentType Course EntryYear GraduationYear UMLClass 10 520 130 80 Modules_Dim -- ModuleID Faculty Level UMLClass 230 560 130 160 Transcript Fact -- bg=pink Grade ResultID StudentID AssignmentID ModuleID CourseID FacultyID SemesterID UMLClass 10 450 130 60 Results_Dim -- ResultID ResultDesc UMLClass 500 680 130 90 Courses_Dim bg=yellow -- CourseID CourseDesc Faculty Level UMLClass 10 710 130 90 Faculties_Dim -- FacultyID FacultyName FacultyLocation Relation 130 470 120 160 lt=- fg=red 100.0;140.0;10.0;10.0 Relation 350 500 170 150 lt=- fg=red 10.0;130.0;150.0;10.0 Relation 130 540 120 140 lt=- fg=red 100.0;120.0;10.0;10.0 Relation 350 670 170 70 lt=- fg=red 10.0;10.0;150.0;40.0 Relation 130 680 120 80 lt=- fg=red 100.0;10.0;10.0;60.0 Relation 350 40 170 670 lt=- fg=red 10.0;650.0;150.0;10.0 UMLClass 1080 330 130 90 Library_Dim -- LibraryID LibraryName libraryLocation UMLClass 1080 80 130 160 Books_Dim -- BookID BookAuthor BookTitle BookISBN DateAcquired DateDeleted Location LoanType UMLClass 810 130 130 180 Library Loans Fact -- bg=pink FineDue FinePaid BookID StudentID LoanDateID DueDateID ReturnDateID LoanTypeID LibraryID UMLClass 1080 250 130 70 LoanTypes_Dim -- LoanTypeID LoanTypeDesc Relation 930 100 170 120 lt=- fg=green 150.0;10.0;10.0;100.0 Relation 620 200 210 330 lt=- fg=green 10.0;310.0;190.0;10.0 Relation 620 50 210 200 lt=- fg=green 10.0;10.0;190.0;180.0 Relation 620 50 210 220 lt=- fg=green 10.0;10.0;190.0;200.0 Relation 620 50 210 230 lt=- fg=green 10.0;10.0;190.0;210.0 Relation 930 260 170 60 lt=- fg=green 150.0;20.0;10.0;20.0 Relation 930 290 170 90 lt=- fg=green 150.0;70.0;10.0;10.0 UMLNote 740 10 240 80 KEY bg=cyan Facts - Red Conformed Dimensions - Yellow Independent Dimensions - White UMLClass 810 350 130 130 Student Fee Fact bg=pink -- PaymentAmount PaymentDateID StudentID PaymentTypeID CourseID PayerID Relation 620 410 210 120 lt=- fg=orange 10.0;100.0;190.0;10.0 Relation 620 50 210 370 lt=- fg=orange 10.0;10.0;190.0;350.0 UMLClass 1080 460 130 70 PaymentType_Dim -- PaymentTypeID PaymentTypeDesc Relation 930 420 170 90 lt=- fg=orange 10.0;10.0;150.0;70.0 Relation 620 440 210 300 lt=- fg=orange 10.0;280.0;190.0;10.0 UMLClass 1080 540 130 130 Payer_Dim -- PayerID PayerName PayerAddress PayerPhone PayerEmail PayerType Relation 930 460 170 130 lt=- fg=orange 10.0;10.0;150.0;110.0