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

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 P * contributor_name * contributor_state * contributor_zipcode CONTRIB

Post by answerhappygod »

Contributordim Contributor Key P Contributor Id P Contributor Name Contributor State Contributor Zipcode Contrib 1
Contributordim Contributor Key P Contributor Id P Contributor Name Contributor State Contributor Zipcode Contrib 1 (79.77 KiB) Viewed 20 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 P * contributor_name * contributor_state * contributor_zipcode CONTRIBUTORDIM PK CONTRIBUTIONFACT TIMEDIM Ptime_key un * time_date un * time_week un * time_month un * time year un TIMEDIM PK (time_k unknown Unknown contribution_id * contribution key * legislator_id Unknown contribution_date Unknown contribution amount unknown CONTRIBUTIONFACT PK (contribution BILLDIM P bill_id * bill_key * bill_name * bill_summary * bill_introduction_date * bill_current_status * legislator_id BILL PK (bill_id) INTERESTDIM * interest_key Pinterest_name Unknowl Unknowl Unknowi * interest industry INTERESTDIM PK (interest_nam P* legislator_id LEGISLATORDIM * legislator_key * legislator_chamber * legislator_affiliation * legislator_state * legislator_first_name * legislator_last_name VARCHAR (20) VARCHAR (20) VARCHAR Integer VARCHAR Integer VARCHAR * legislator_middle_name VARCHAR * legislator_email unknown * legislator_telephone unknown * legislator_fax unknown LEGISLATORDIM PK (legislator_id) VOTING EVENTDIM VARCHAR (25) Date Integer Datetime VOTING EVENT PK (event id) Pinterest group name event name event date P event id INTEREST GROUPDIM * event time VARCHAR VARCHAR * interest group industry * interest group interest VARCHAR INTEREST GROUP 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