Question

2. The Sooner Development Fund collects donations for various programs. When donors pledge to Sooner the system records the date of the pledge. Some donors may wish to target their gift to a specific program. Some donors also have company matches available from corporate sponsors. The operational database for this system looks like the following DONOR DonorlD (pk) CompanylD (fk) Name Address Match PLEDGE PledgelD (pk) DonorlD (fk) ProgramlD (fk) Amount Date COMPANY CompanylD (pk) Compa nyName PROGRAM ProgramlD(pk) Description a) Produce a dimensional model for the data warehouse that goes with this system to keep track of the pledge history of the organization. Provide a Data Schema (E-R diagram) including all attributes. Follow Kimball's rules

Answer 1

there is one to many cardinalitu between company and donor, since a single company can have multiple instances of donor

there is one to one cardinality between donor and a pledge, since a single donor can make only single pledge

there is one to many cardinality between program and pledge since a single program can have multiple pledges made by different donors.