How to design student quarterly registration fact table

Fact table design - Showing something that did not occur

Hi everyone, I got a question about how to handle a situation with a user need. I have created a fact table factClassesStudentAttended. Those classes are for paramedic. The user wanted to know wich student took what classes and what was the

How to design a one to many relationship

I have a student quarterly registration fact table. Every student has academic programs (majors) associated with him/her and each student can have up to 5 of them. And each major can start and end at different times and has multiple parameters including

Fact table design: Sales Transaction with multiple Discount rows

Hi, I am designing a Sales DW where we can have multiple discounts on a given transaction line. I created a SalesTransaction (ST) fact table and a SalesDiscount (SD) fact table. In the current design the ST table has its own key that is a bigint

Transaction Fact design

hi I am faced with a problem designing a transaction fact in an investment firm. each transaction represents a trade the traders put in (buy,sale etc). The problem I am facing is: the metrics of a transaction change from one day to another day so a

Guidelines for FACT Table Design for High-Transaction Volume and High # of Measures ...

Hi All - This inquiry could actually be two questions, but the requirement is really presentation of row-wise high volume transactional data in a column-wise (columnar) FACT table. Here is a sample transactional data set: Interval Date TimeUni

Transactional detail fact table w/complimentary snapshot table. How do the two play together?

Take a detail daily banking transaction table with standard credit and debit level transactions. I want to build the accompanying snapshot that would present the higher level rollups of these lower transactions: There are about 250 daily transaction

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

Montly Snapshot views with transactional Fact table w/SCD2

I am a new at working with Dimensional Database design. I am struggling with something that probley is real easy to do, but just can't find documentation that will explain it. I want to create a monthly snapshot view of my transactional Fact table with

Questionnaire for medical record entries

Good afternoon, I am currently working on a data warehouse in the health care sector and I currently facing this problem: The aim of this warehouse is to have an overview of a cancer therapy. So, I have created the following fact table

cttc.student

asalam-o-alaikum how r u sir it is really a great forum i have completed my CCNA preparation frm CTTC tariq road frm sir munsif.. bt sir i want to give the exam of ccna so dats y i want latest dumps of PASS4SURE......

Fast Registration?

I woud like to suggest a fast registration box above the catgeories of the index, after the nav bar. I have seen it in forums not hosted by forumotion... This will be viewable only for guests. I will describe it as much as I can. I bet that you have seen

ForuMotion Coffee Mug Design

I just finished up my latest design which is a Fan Based art that I will be ordering very soon my own Official ForuMotion Coffee Mug from my design in photoshop. I drink coffee a lot and this way I will never have to forget about ForuMotion. I canno

wEdETykE Design

In ordinea in care le-am creat: 1. 2. 3. 4. 5. 6. 7. 8. Acestea sunt unele dintre creatiile mele.