Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
price aggregator system provides users with a one-stop portal where they can ice of products across multiple Web sites. The portal allows users to not only t also view customer feedback and reviews of the different Web sites. Users a st create an account before using the portal for the first time, after which they sults of previous product searches as well compare the fluctuations in prices o ne. To provide this functionality, the system maintains the following data: SearchID, UserID, UserName, UserEmail, SearchDate, SearchTime, SearchCategory, SearchBrand, SearchModel, BrandID, LowestPrice, LowestPriceURL, Price2, Price2URL,

price aggregator system provides users with a one-stop portal where they can ice of products across multiple Web sites. The portal allows users to not only t also view customer feedback and reviews of the different Web sites. Users a st create an account before using the portal for the first time, after which they sults of previous product searches as well compare the fluctuations in prices o ne. To provide this functionality, the system maintains the following data: SearchID, UserID, UserName, UserEmail, SearchDate, SearchTime, SearchCategory, SearchBrand, SearchModel, BrandID, LowestPrice, LowestPriceURL, Price2, Price2URL,

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
Problem 7: A price aggregator system provides users with a one-stop portal where they can compare the price of products across multiple Web sites. The portal allows users to not only compare prices but also view customer feedback and reviews of the different Web sites. Users are required to first create an account before using the portal for the first time, after which they can review the results of previous product searches as well compare the fluctuations in prices over a given time. To provide this functionality, the system maintains the following data: SearchID, UserID, UserName, UserEmail, SearchDate, SearchTime, SearchCategory, SearchBrand, SearchModel, BrandID, LowestPrice, LowestPriceURL, Price2, Price2URL, Price3, Price3URL, Price4, Price4URL, Price5, Price5URL, LowestPriceURL_Rating, Price2URL_ Rating, Price3URL_Rating, Price4URL_Rating, Price5URL_ Rating Sample data for this set of attributes is as follows: 32332, 0332, Clark Kent, kentKalEl@mail.org, 12122018, 10.28.34, laptop, IBM, thinkpad, t61, 60, vintagelaptopsRUs.net, 68, thinkpadsLikeNew.org, 89, getoldLaptops.tv, 143, laptopslikenew.biz, 146, 123161IBM4U.net, 200, oldlikeNewPCs.biz, 4,3,4,3,5,4 a. Identify the functional dependencies between the attributes. b. Identify the reasons why this set of data is not in 3NF and indicate the normal form (if any) it is in. c. Including all intermediate stages, organize the attributes into a set of 3NF relations.
Transcribed Image Text:Problem 7: A price aggregator system provides users with a one-stop portal where they can compare the price of products across multiple Web sites. The portal allows users to not only compare prices but also view customer feedback and reviews of the different Web sites. Users are required to first create an account before using the portal for the first time, after which they can review the results of previous product searches as well compare the fluctuations in prices over a given time. To provide this functionality, the system maintains the following data: SearchID, UserID, UserName, UserEmail, SearchDate, SearchTime, SearchCategory, SearchBrand, SearchModel, BrandID, LowestPrice, LowestPriceURL, Price2, Price2URL, Price3, Price3URL, Price4, Price4URL, Price5, Price5URL, LowestPriceURL_Rating, Price2URL_ Rating, Price3URL_Rating, Price4URL_Rating, Price5URL_ Rating Sample data for this set of attributes is as follows: 32332, 0332, Clark Kent, kentKalEl@mail.org, 12122018, 10.28.34, laptop, IBM, thinkpad, t61, 60, vintagelaptopsRUs.net, 68, thinkpadsLikeNew.org, 89, getoldLaptops.tv, 143, laptopslikenew.biz, 146, 123161IBM4U.net, 200, oldlikeNewPCs.biz, 4,3,4,3,5,4 a. Identify the functional dependencies between the attributes. b. Identify the reasons why this set of data is not in 3NF and indicate the normal form (if any) it is in. c. Including all intermediate stages, organize the attributes into a set of 3NF relations.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS