You can download the solution to the following question for free. For further assistance in Accounting and Finance assignments please check our offerings in Accounting assignment solutions. Our subject-matter experts provide online assignment help to Accounting students from across the world and deliver plagiarism free solution with free Grammarly report with every solution.
(ExpertAssignmentHelp does not recommend anyone to use this sample as their own work.)
Q1 You have been asked to do an internship in a small Not-for-Profit organisation (NFPZ) which has recently been given approval to accept donations from individuals and organisations in the private and public sectors. You have been asked to design a simple database in MS Access to keep track of donors and donations based on the following business rules:
Draw an Entity Relationship Diagram (ERD) for the entities for the NFPZ Donor-Donation database showing attributes [just the name of the headings, not the actual data] and indicate the primary keys (you have to think about what are appropriate attributes)
**I don't want a screen print of the relationship in MS Access in this question as I want you to model the conceptual database design first using the figures provided under the Labs/Tutorials section of Blackboard.
Your answer should show cardinalities and whether or not the relationship is mandatory/optional. Link entities using foreign keys, if necessary. State assumptions, if any, you make about business rules. (5 marks)
Q2 This part of task 3 is worth 15 marks.
OPTION 1 (For Students who have MS Access)
Implement the ERD Q1 in MS Access as NFPZ Donor-Donation Database. Do screen prints (when you have the proper screen in front of you, press the Print Screen button on your keyboard, go to where you want to put it in your assignment document and click 'paste') of the following and paste them in your assignment document :
OPTION 2 (For Students who do not have MS Access)
Using the Week 4 Tutorial-Lab MS Access Manual as a guide, show how you would implement the extended ERD created in Q1 above into the existing database by doing the following:
(note: you can 'draw' the outputs using MS Word or you could draw the outputs by hand and then take a photo of them and paste that in your assignment document. To see examples of how the 'drawings' are done in MS Word, see the 'Sample of MS Access Drawings' document under the Assessment>Assignment folder on Blackboard
When naming your attributes, they have to be meaningful & distinctive (e.g. Donor Name instead of only Name (in databases sometimes more than one entity will have similar attributes like 'Address' and you need to differentiate which entity that attribute belongs to. Also, some words are 'reserved' or 'system' words (e.g. Name, Number, Date) and cannot be used on their own.
For data types, if it is a mixture of numbers & text, use 'text' data type. Remember also:
Review your requirements with our FREE Assignment Understanding Brief and avoid last minute chaos.
We provide you services from PhD experts from well known universities across the globe.
No more plagiarism worries. We give you a FREE Grammarly report with every assignment.
Our experts work round the clock to provide you with solutions before the scheduled deadline.
a) Tables from MS Access in Datasheet and Design View
Table 1 – Donors List
Table 2 – Donations List