Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Table 1: Sample data from the Excel spreadsheet. - note the data has errors which is another issue. Purchase Where Date Date product First Name

Table 1: Sample data from the Excel spreadsheet. - note the data has errors which is another issue. Purchase Where Date Date product First Name Last Name Delivery Address made available to sell/sold indicator email Craft Person Product Craft Person (member) Type/Qty/Size/ Price Paid/ Donation Consented to future contact (Buyer/Craft Person) 2022- 04-21 stall community 2022- 04-21/N Vivian Quilt/1/large/$300 Brown (Y) Y N/Y 2022- online 2022- Peter 04-21 04-01 Henstone 5705 Myrtle phenstone@yahoo.com Christine Hill, Logan Hot Water Bottle N/donation Y Green Cover/2/one to charity Central, (N) size/$15.00 of the 4114 month 2022- 04-25 online 2021- 12-03 Marsiella Connell 9 Sunfield sunbird@yahoo.com Lane, Jeff Metal hat Y Y Johnstone hanger/1/m/$50.00 Springwood, 4127 (N) 2022- community 2021- George Kloony gk0102@ymail.com 04-29 stall 12-01 Thelma Pearson Birthday N/ cards/3/post donation (Y) standard/$5.00 2021- 02-01 Blank to charity of the month Cards/1/small/$4.00 2022- online 2022- Enrique Kirgan 85 Rutledge kenrique@gmail.com Thelma. Easter 04-29 02-01 Avenue, Pearson cards/24/$3.00 Sydney, 2022- 2000 Blank 05-01 cards/10/$4.00 N Question 1 Start your report with a section to that explains and shows the conversion of the Excel Spreadsheet into normalized tables. To do this describe and illustrate the process of normalizing the attributes shown in Table 1 plus the attributes and the tables that have been randomly assigned to you in Question 2 to produce a set of well-designed 3NF relations. To Table 1, you may add purchaser, crafter and product identifiers. You may also add crafter home address and email details. Do not add more attributes than required to store this information (Table 1 plus your randomly assigned attributes and table that can be found in question 2). Marks will be deducted if there are other attributes added

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cima Official Exam Practice Kit Financial Operations

Authors: Jo Watkins

5th Edition

1856177335, 978-1856177337

More Books

Students also viewed these Accounting questions

Question

18. If you have power, then people will dislike and fear you.

Answered: 1 week ago