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

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.

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

Step by Step Solution

★★★★★

3.61 Rating (173 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

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

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

353-B-A-I-S (4475).docx

120 KBs Word File

Students Have Also Explored These Related 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...

Figure 5.16 is a sample from a spreadsheet used to record donors for a small college. you have been asked to design and implement a database to allow easy inputting, updating, and reporting of...

Figure 5.16 (pg. 191) is a sample from a spreadsheet used to record donors for a small college. You have been asked to design and implement a database to allow easy inputting, updating, and reporting...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Chapter 10 Business Process and Information Systems Development \"Jeff, we clean the clubhouse restrooms twice a day . . . in the morning before 7 and again just before lunch. We've been doing that...

I hope you can answer this question and find the reference below the question. Thank you Topic: Conducting personal job interviews using the STAR model 1- Design a two-hour training work plan for 10...

Analyze the project documentation from the case study for the data necessary to establish EVM parameters. In other words, is everything you need to establish the EVM parameters for this project...

1. What is JITD, describe it shortly. 2. What re the advantages and disadvantages of JITD 3. What problems do you found in barilla case? 4. List the lead time and inventory level in each stage of...

? The beverage and snacks company "Fizzy & Crispy is one of the largest juices, drinks, and snacks producers in Norway. Their products are famous over all Europe. They are mainly known for their soft...

The amount of time it takes Heather to cook dinner is directly proportional to the number of ingredients involved. If it take minutes to cook dinner when there are n ingredients involved how many...

Examine barriers to group effectiveness and their resolutions.

XYZ Corporation takes out a $1 million loan that semiannually pays six-month LIBOR + 50 bp on March 4, 1999. Assume that LIBOR is at 9 percent on March 4, 1999, 8.75 percent on September 4, 1999. and...

What is a database schema? What is a database subschema? Give some examples of database schemas and subschemas for the payroll file ofFigure. Social Seity L First Phone License Plate Ticket Number...

What are data manipulation languages? How are these languages related to database management systems? How are these languages related to databases?

What is SQL? How is SQL like an Access query? How is it different?

Laiho Industries's 2020 and 2021 balance sheets (in thousands of dollars) are shown. Do not round intermediate calculations. Enter your answers in thousands. For example, an answer of $1 thousand...

Big Sky Hospital plans to obtain a new MRI that costs $ 1 . 5 million and has an estimated four - year useful life. It can obtain a bank loan for the entire amount and buy the MRI or it can lease the...

Present Worth and Capitalized Cost What is the capitalized cost of $60,000 in year 0, $150,000 in year 2 and a uniform annual amount of $50,000 per year forever, beginning in year 5? Use an interest...