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

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

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

Post 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 22 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)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply