Question: Create a dimensional model depicting the DBS Bank s phishing awareness campaign context, along with associated dimension tables that provide descriptive attributes related to the

Create a dimensional model depicting the DBS Banks phishing awareness campaign context, along with associated dimension tables that provide descriptive attributes related to the phishing awareness campaign fact table. The dimensions should include Participants dimension (that stores detailed information about each participant of the bank), Campaigns dimension (that contains information about the different phishing campaigns), Sessions dimension (that provides specifics about each session within the campaign, including the topic, the presenter, the format, and the duration), and Date dimension (that tracks temporal data for each participation record). Briefly explain your proposed dimensional model. You must label all the tables and keys and underline the keys. A screenshot of a hand-drawn figure is acceptable.

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!