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.
Transcribed Image Text:
SOFTWARE PACKIDİ TAGNUMİ COMPID INSTDATE SOFTCOST EMPNUM Í EMPIAME LOCATION Accounting Accounting Sales 9/13/06 12/13/06 06/15/06 05/27/06 06/15/06 05/27/06 10/30/06 05/27/06 Dinh, Melissa Dinh, Melissa Alvarez, Ramon Feinstein, Betty Info Systems Alvarez, Ramon Feinstein, Betty Info systems Alvarez, Ramon Peinstein, Betty Home 32808 DB3232808 M759 37691 57772 754.95 611 380.00611 380.00 412.77 567 227.50124 170.24 567 B121 DB33 WPO8 37691 B121 Sales 57772 WP09 59836 B221 77740 35.00 124 35.00567 Home
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 78% (14 reviews)
a Shaded Attributes Primary Key First Normal Form 1NF Gift Date Donor Name Donor Number Receipt Numb...View the full answer
Answered By
Amos Kiprotich
I am a wild researcher and I guarantee you a well written paper that is plagiarism free. I am a good time manager and hence you are assured that your paper will always be delivered a head of time. My services are cheap and the prices include a series of revisions, free referencing and formatting.
4.90+
15+ Reviews
21+ Question Solved
Related Book For
Accounting Information Systems
ISBN: 978-1133935940
10th edition
Authors: Ulric J. Gelinas, Richard B. Dull
Question Posted:
Students also viewed these Accounting 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...
-
Biko owns a snowmobile manufacturing business, and Miles owns a mountain bike manufacturing business. Because each business is seasonal, their manufacturing plants are idle during their respective...
-
Discuss the various sources and strategies for integrating cost and value.
-
(Type of Lease, Amortization Schedule) Jacobsen Leasing Company leases a new machine that has a cost and fair value of $75,000 to Stadler Corporation on a 3-year non-cancelable contract. Stadler...
-
Overhead Application, Fixed and Variable Overhead Variances Zepol Company is planning to produce 600,000 power drills for the coming year. The company uses directl $1,777,500. The total fixed...
-
Suppose that the Goodyear Tire Company has historically held 42% of the market for automobile tires in the United States. Recent changes in company operations, especially its diversification to other...
-
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....
-
In the following flowchart, identify the documents, records, and procedures that illustrate the payment process using a vouchersystem. VOUCHERS CASHIER PAYABLE
-
What is credit evaluation and what are the five Cs?
-
List and briefly explain the different types of floats, and explain the float techniques.
-
Define business valuation and list its major purposes.
-
What is combined leverage? And what would it measure?
-
If you find yourself leaning toward starting up a new project right from the beginning, what would be the convincing reasons?
-
Suppose I claim that head size is a good measure of IQ and my measure is head circumference. Is the measure reliable? Valid? Explain.
-
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...
-
What is the balance in Work in Process Inventory at the end of each month? Work in Process Inventory April 30 $ May 31 A 10,140 15,950 June 30 $ 10,450
-
Sako Company s Audio Division produces a speaker used by manufacturers of various audio products. Sales and cost data on the speaker follow: Selling price per unit on the intermediate market $ 6 0...
-
Vulcan Company's contribution format income statement for June is as follows: Vulcan Company Income Statement For the Month Ended June 30 Sales Variable expenses Contribution margin Fixed expenses...
Study smarter with the SolutionInn App