Page 1 of 1

CONTRIBUTORDIM contributor_key * P contributor_id * contributor_name * contributor_state * contributor_zipcode CONTRIBUT

Posted: Fri Jul 01, 2022 5:51 am
by answerhappygod
Contributordim Contributor Key P Contributor Id Contributor Name Contributor State Contributor Zipcode Contribut 1
Contributordim Contributor Key P Contributor Id Contributor Name Contributor State Contributor Zipcode Contribut 1 (79.77 KiB) Viewed 24 times
Based on the picture above, can you please help me on creating a fact table that is incorrect in atleast two differentways?
CONTRIBUTORDIM contributor_key * P contributor_id * contributor_name * contributor_state * contributor_zipcode CONTRIBUTORDIM_PK (contr UN UN UN UN UN CONTRIBUTIONFACT P contribution_id * contribution_key legislator_id UNKNOWN UNKNOWN UNKNOWN UNKNOWN * contribution_date * contribution amount UNKNOWN CONTRIBUTIONFACT_PK (contributio TIMEDIM Ptime_key UNKNOWN UNKNOWN UNKNOWN UNKNOWN UNKNOWN * time_date * time_week * time_month * time_year TIMEDIM_PK (time_key) INTERESTDIM * interest_key UNKNOW * interest_name UNKNOV * interest industry UNKNOV INTERESTDIM_PK (interest_nam LEGISLATORDIM IP legislator_id * legislator_key * * * legislator_state VARCHAR2 * legislator_first_name INTEGER * legislator_last_name VARCHAR2 * legislator_middle_name VARCHAR2 * legislator_email UNKNOWN legislator_telephone UNKNOWN UNKNOWN legislator_chamber legislator_affiliation VARCHAR2 (20) VARCHAR2 (20) VARCHAR2 INTEGER * legislator_fax LEGISLATORDIM_PK (legislator_id) VOTING_EVENTDIM * event_name * event_date Pevent_id INTEREST GROUPDIM VARCHAR2 (25) DATE INTEGER DATE * event_time VOTING_EVENTDIM_PK (event_id) Pinterest_group_name VARCHAR2 *interest_group_industry VARCHAR2 * interest_group_interest VARCHAR2 INTEREST GROUPDIM_PK (interest_group_name)