country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

ICT330 Database Management Systems 2

tag 0 Download3 Pages / 643 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
  • Course Code: ICT330
  • University: Singapore University Of Social Sciences
  • Country: Singapore

Question:

Project One: Beta University Annual Fund

  • General Description

The Development Office of Beta University seeks to obtain donations for its Annual Fund from a variety of donors. The fund collects over ten million dollars each year. Donors include graduating seniors, alumni, parents, faculty, administrators, staff, corporations, or other friends of the university. There are approximately 100,000 potential donors. The Annual Fund is directed by Suzanne Hayes, who is responsible for raising funds and keeping track of donations. Suzanne wishes to create a database to help with both of these major responsibilities.

  • Basic Operations

Suzanne tries to raise funds in several ways during each fiscal year, which extends from July 1 to June 30. Each fall, all potential donors to the Annual Fund receive personalized letters from her, emphasizing their close ties to Beta University. The letters contain reply envelopes and forms on which the donors can fill in the amount they are pledging to contribute that year, and the method of payment they choose. Payment can be sent as a single check in the envelope, donors can choose deferred payments over a period of a year, or they can provide their credit card numbers to pay in a single lump sum. Often, the employer of the donor or of the donor’s spouse has a program to make a matching gift to the university, and the donor provides the contact information on the envelope. A letter acknowledging the gift and thanking the donor is sent as soon as the pledge is received. Suzanne is responsible for following up with the employer to collect the matching gift, which is paid in a single lump sum by the corporation.

Several fundraising events are held during the year. Suzanne solicits donations at a fall carnival, a holiday dinner dance, and a spring golf outing, among other events. Each class has a class coordinator who helps by contacting members of his or her graduating class. An additional letter from the class coordinator is made to ask for larger donations from reunion classes, those who are marking an important anniversary of graduation – whether five years, ten years, etc. – prior to their reunion celebration weekend. Each spring there is a phonothon during which current students and other volunteers call other potential donors and solicit pledges. All alumni who have not contributed by the end of May receive telephone calls from their class coordinator asking them for a donation. If the class coordinator is unable to contact his or her classmates, Suzanne or a volunteer makes these calls instead.

The donations are categorized by the group they are from, by the year of the donor (if applicable) and by size. There are ten “donor circles”, which are categorized by the size of the gift – President’s Circle for gifts over $50,000, Platinum Circle for gifts over $25,000, and so on. Gifts under $100 are not listed as belonging to a circle. An annual report listing all donors by category, year and donor circle is published and mailed to all actual and potential donors during the summer. The report does not list the actual amount each person contributed.

  • Information Needs

At present, Suzanne has a mailing list on a word processor that is used to generate labels and letters to potential donors. She would like to be able to personalize the letter further by adding a reminder of the amount of money the donor gave the previous year. A spreadsheet is used to keep track of pledges and donations. Large pledges from individual donors are ordinarily paid in monthly installments rather than in one payment, but currently there is no way to keep track of those payments. When a database is developed, Suzanne would like to be able to send reminders if payments are over a month late.

An Annual Fund Gift form is sent with all letters soliciting funds, with blanks for the donor to fill in the applicable information, as follows:

Beta University Annual Fund Gift Donor Name, Donor Address, Category (a check list specifying senior, alumnus/alumna, parent, administrator, etc.), Year of Graduation, Date of Pledge/Gift, Amount Pledged, Amount Enclosed, Payment Method, Number of Payments Chosen, Credit Card Number, Matching Corporation Name, Matching Corporation Address, Name of Spouse (if matching gift is from spouse’s employer),

When pledges are received by class representatives or during the phonothon, the same information is collected on similar forms.

Reports needed include

Annual Report to Donors This report was described previously. It lists names only, not amounts. However, the names have to be categorized as indicated. The report also includes summaries, including the total amount raised from all sources, the total for each class, the percent participation for each class, the total for each category, the grand total for each donor circle, and the class total for each donor circle. It is an important fundraising tool for the following year’s drive, since it is mailed to each potential donor.

Monthly Report This is an internal report that Suzanne uses to evaluate the progress of the fundraising for the year so far. It gives the totals and percentages of pledges and gifts received for the current month in all categories.

Payments Due Report Suzanne would like a report each month listing the pledge payments that were due that month but were not received. It should list the donor’s name and address, the amount due, the date due, the amount of the pledge, the amount received so far, and the date of the previous payment, if any.

Event Report Suzanne would like to generate reports showing who attends each of the fundraising events, and what pledges and gifts were received from the attendees.

Class Representative Contact List For each class representative, Suzanne would like a list of classmates to be contacted, including the name, address, telephone number, last year’s donation information, and this year’s donation information.

Phonothon Volunteer Contact List Each volunteer caller is given a list with information about the potential donors he or she is expected to call, including the name, telephone number, address, category, year (if applicable), and last year’s donation information.

In addition to the forms and reports listed here, there are several others that would be useful. Do steps 1.1 – 1.4 based on the information provided here and any additional applicable assumptions you need to make about the operations of the Annual Fund.

Task:

Step 1 Make a list of all entities and their associated attributes

Step 2 Make a list of relationships to be represented, and descriptive attributes for them

Step 3 Draw an E-R diagram to represent the enterprise. Be sure identify relationship participation and cardinality constraints, any weak entity sets, and rolenames, if needed.

Step 4 Update the data dictionary and list of assumptions as needed.

Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 3 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Database Management Systems 2. Retrieved from https://myassignmenthelp.com/free-samples/ict330-database-management-systems-2.

"Database Management Systems 2." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/ict330-database-management-systems-2.

My Assignment Help (2020) Database Management Systems 2 [Online]. Available from: https://myassignmenthelp.com/free-samples/ict330-database-management-systems-2
[Accessed 24 October 2020].

My Assignment Help. 'Database Management Systems 2' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/ict330-database-management-systems-2> accessed 24 October 2020.

My Assignment Help. Database Management Systems 2 [Internet]. My Assignment Help. 2020 [cited 24 October 2020]. Available from: https://myassignmenthelp.com/free-samples/ict330-database-management-systems-2.


MyAssignmenthelp.com is a one-stop solution for online proofreading services. You are welcome to ask ‘edit my paper’ for your pre-written paper. Our online essay editors will check your paper in no time and deliver a flawless assignment to help you bag the best grades. They have experience in dealing with all kinds of assignments based on more than 100 subjects. You can also ask our essay and assignment writers to write a perfect assignment from scratch for you.

Latest It Write Up Samples

HC1041 Information Technology For Business

Download : 0 | Pages : 8

Answer: Introduction Use of technology or more appropriately, the use of information technology has become a necessary need for management of the business operations of every organization irrespective of the fact whether the organizations are small, medium or large. The need of use of information system is very vital in large organization as it becomes very difficult to manage their complex business operations without the help of an informati...

Read More arrow

2527NSC Aviation Research Methods

Download : 0 | Pages : 11
  • Course Code: 2527NSC
  • University: Griffith University
  • Country: Australia

 Answer: Introduction All through Australian universal airplane terminals, duty-free shops were as of now taking into account worldwide and nearby travellers. An assortment of duty-free things, particularly liquor and tobacco things were the two most sold things in these stores. A portion of the traveller's even search for imported chocolates and exorbitant gifts, which were accessible in low expenses. These shops serve global travellers...

Read More arrow

MIS772 Predictive Analytics

Download : 0 | Pages : 5

Answers: 1. The analysis of the dataset in RapidMiner shows that the variables are either polynomial or integer. The information provided by AQA contains various information regarding the quality of service provided by Airlines. The information regarding the name of the airline contains no missing data. From figure 2 it is found that most of the travellers have flown in economy class. The least number of travellers have flown first class. Ther...

Read More arrow

HC1041 IT For Business

Download : 0 | Pages : 8
  • Course Code: HC1041
  • University: Holmes Institute
  • Country: Australia

Answers: Introduction This report is about the questions and answer about the case study “Blooming with Technology” and about the point of Sale system. The advantages and disadvantages of new POS system are discussed according to the case study. POS is helpful in gaining the competitive advantage as well as if it is connected with the Telecommunication Networks; it works wonders in the enterprises. 1. System of POS has some advan...

Read More arrow

ISY2001 System Analysis And Design

Download : 0 | Pages : 6
  • Course Code: ISY2001
  • University: Australian Institute Of Higher Education
  • Country: Australia

Answer: Introduction FastDrivers is a company recently created that provides driving lessons and the company provides online booking of lessons for the customers in New South Wales. The company wants to design an online booking system which performs the activities that are described in this report. The purpose of this report is to provide an analysis and design of online booking system to serve the customers of FastDrivers. The structure of ...

Read More arrow
Next

Save Time & improve Grade

Just share requirement and get customized Solution.

watch
question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Add File

Error goes here

1,462,727

Orders

4.9/5

Overall Rating

5,096

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

93 Order Completed

100% Response Time

Jackson Mitchell

MiM (Masters in Management) in Supply Chain Management

New Jersey, United States

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2115 Order Completed

97% Response Time

Kimberley Chen

MPA in Accounting

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

453 Order Completed

98% Response Time

Howard Asuncion

LLM in Criminal Law

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1592 Order Completed

96% Response Time

Jane Sima

Ph.D in Psychology with Specialization in Industrial-Organizational Psychology

Singapore, Singapore

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

hank you for being prepared for our meetings, Tom! By coming to each meeting with well-researched and thought-out ideas, you\'re helping us move forward in our process. I look forward to our next meeting.

flag

User Id: 427804 - 24 Oct 2020

Australia

student rating student rating student rating student rating student rating

tremendous graduate writing! Excited for the quick results! Always rely on these experts!

flag

User Id: 453763 - 24 Oct 2020

Australia

student rating student rating student rating student rating student rating

First I would like to thank the second Expert. The work is of a very high standard. I am grateful for that. Second, I do appreciate the first Experts efforts.

flag

User Id: 92806 - 24 Oct 2020

Australia

student rating student rating student rating student rating student rating

very detailed assignment. No grammar mistakes. The author throughly followed APA guidelines.

flag

User Id: 474516 - 23 Oct 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?