Figure is a sample from a spreadsheet used to record donors for a small college. You have

Question:

Figure is a sample from a spreadsheet used to record donors for a small college. You have been asked to design and implement a data-base to allow easy inputting, updating, and reporting of contribution data.

a. Transform the structure into 3NF providing the intermediate steps of 1NF and 2NF.
b. Use a DBMS (such as Access) to implement yourstructure.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Accounting Information Systems

ISBN: 978-1133935940

10th edition

Authors: Ulric J. Gelinas, Richard B. Dull

See More Books

Question Posted: Dec 15, 2014 10:32 AM

See More Questions

You have been asked to design a rater-training program. What types of elements would you build into the process?
You have been asked to design a program that will allow a teacher to calculate the percentage and the final grade for students in a class. The program will prompt the teacher to enter the student's...
As an Electrical Engineer, you have been asked to design a receiver that detects a particular sequence of bits transmitted from a remote transmitter. Your system is a MOORE machine that has an input...
Show that the allocation which solves the first-order condition from Eq. (3.7) for a social optimum satisfies the second-order conditions. Equation 3.7 -C(e) = D'(E) i=1,.... (3.7)
If X is a Gamma random variable with parameters A and r, then find the moment generating function of X. (Use the result from Exercise 43.9 as an aid. Again, for this problem, that we are using t in...
An extension of the antitrust laws into the arena of international trade has taken the form of anti-dumping laws, which have been enacted by most Western countries, and which are increasingly being...
An electron travels to the right at $3.0 \times 10^{6} \mathrm{~m} / \mathrm{s}$ between two large, flat sheets that are parallel to each other and to the electron's line of motion. If currents per...
A paper mill is considering two types of pollution control equipment. The firm wants a 12% rate of return on any avoidable increments of investment. Which equipment should be purchased?...
Identify 2 tools used for backup purposes that would support business continuity to ensure that the data can be accessed during the disaster. Explain who is responsible for the backup. How often...
In a public sector company, the workers are very lazy and do not do their allotted jobs in the stipulated time. The vice-president calls the manager and questions him about the situation. The manger...
Transform the database structure that appears in Figure into 3NF. Be sure to show your intermediate steps of 1NF and2NF. SOFTWARE PACKID TAGNUM COMPID INSTDATE SOFTCOST EMPNUM EMPIAME LOCATION...
Technology Summary 5.2 uses examples of employee ID codes to illustrate five data coding types. Refer to those examples. Create student ID codes that illustrate each of the five coding schemes....
Rose and George are purchasing a house for $450,000. Their bank requires them to pay a down payment of 20%. The current mortgage rate is 10%, and they are required to pay 1 point at the time of...
Which of the following statements about a spliceosome is false? a. A spliceosome splices pre-mRNA molecules. b. A spliceosome removes exons from RNA molecules. c. A spliceosome is composed of snRNPs....
To make a new DNA strand, which of the following is/are necessary? a. A template strand c. Heavy nitrogen b. Nucleotides d. Both a and b
During the peptidyl transfer reaction, the polypeptide, which is attached to a tRNA in the __________, becomes bound via ________ to an amino acid attached to a tRNA in the __________. a. A site,...
A groove in a DNA double helix refers to a. the indentations where the bases are in contact with the surrounding water. b. the interactions between bases in the DNA. c. the spiral structure of the...
In agriculture, an advantage of triploidy in plants is that the plants are a. more fertile. b. often seedless. c. always disease-resistant. d. all of the above.
If an individual suggests that any decision regarding an increase in the minimum wage should only be made after objectively comparing the costs and benefits of the increase, a. That individual must...
Quality Chicken grows and processes chickens. Each chicken is disassembled into five main parts. Information pertaining to production in July 2012 is: Joint cost of production in July 2012 was $50. A...
Without looking back in your textbook, write down the double entries for (a) an increase and (b) a decrease in the allowance for doubtful debts.
What are data warehouses? How are they like databases? How do they differ from databases?
Why would a company be interested in creating a data warehouse? Why would a company not be interested in creating a data warehouse?
Discuss both the advantages and disadvantages of using a computerized database system rather than a manual system for storing and processing accounting data. In your discussion, provide some specific...
The city of Austin needs to collect $2,000,000 in property tax revenues. The city estimates 5% of the tax revenues will not be collectible. How much in tax levies should the city of Austin for the...
A bakery corporation earns a total revenue of $157,000. Its expenses are $52,000. If the bakery needs to pay 21% corporate income tax, how much tax will they pay? Show your calculations.
Year 1: Chip Corp had taxable income before taking a charitable contribution deduction of $25000. They made $4,000 in charitable donations that year. Year 2: Chip Corp had taxable income before...

Figure is a sample from a spreadsheet used to record donors for a small college. You have

Question:

Step by Step Answer:

a Shaded Attributes Primary Key First Normal Form 1NF Gift Date Donor Name Donor Number Receipt Numb...View the full answer

Accounting Information Systems

Students also viewed these Accounting questions