Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I AM FRUSTATED NOW I AM UPLOADING THIS QUESTION 4TH TIME PLEASE ANSWER IT CAREFULLY OTHERWISE I WILL DOWNVOTE OR IF YOU SOLVE CLERLY AND

I AM FRUSTATED NOW I AM UPLOADING THIS QUESTION 4TH TIME PLEASE ANSWER IT CAREFULLY OTHERWISE I WILL DOWNVOTE

OR IF YOU SOLVE CLERLY AND WITH EXPALANATION AND WITH COMPLETE TEST CASE SCREENSHOT I WILL UPVOTE ALSO

OUTPUT WITH COMPLETE SCREENSHOT AND COMPLETE CODE PLEASEEEEEEE

image text in transcribedimage text in transcribed

1. Mr. Arun Kumar S/o Mr. Suraj Kumar has purchased 10 acres of land in 20000000. 2. Mr. Amit Kumar S/o Mr. Arun kumar has purchased 15 acres of land in 25000000. 3. Mr. Ram Kumar S/o Mr. Arun kumar and Mr. Amit Kumar S/o Mr. Arun kumar have purchased 20 acres of land in 30000000. 4. Mrs. Anjali Devi W/o Mr. Amit Kumar has purchased 12 acres of land in 15000000. 5. Mr. Manish Kumar S/o Mrs. Anjali Devi has purchased 17 acres of land in 17000000. 6. Mr. Manish Kumar S/o Mr. Amit Kumar and Ms. Priya D/o Mrs. Anjali Devi have purchased 20 acres of land in 19000000. Parse the above statements and store it in any data structure. Program should work with any number of statements and any name, land or amount. Your program should take the following input and calculate accordingly: Select * from LR where name = 'Arun Kumar' Select Sum(Land) from LR where name = 'Amit Kumar' Select Sum(Amount) from LR where name = 'Anjali Devi' Select * from LR where FamilyTree = 'Amit Kumar' Select Sum(Land) from LR where FamilyTree = Suraj Kumar' Select Sum(Amount) from LR where FamilyTree = 'Arun Kumar' purchased 20 acres of land in 30000000. 4. Mrs. Anjali Devi W/o Mr. Amit Kumar has purchased 12 acres of land in 15000000. 5. Mr. Manish Kumar S/o Mrs. Anjali Devi has purchased 17 acres of land in 17000000. 6. Mr. Manish Kumar S/o Mr. Amit Kumar and Ms. Priya D/o Mrs. Anjali Devi have purchased 20 acres of land in 19000000. Parse the above statements and store it in any data structure. Program should work with any number of statements and any name, land or amount. Your program should take the following input and calculate accordingly: Select from LR where name = 'Arun Kumar' Select Sum(Land) from LR where name = 'Amit Kumar' Select Sum(Amount) from LR where name = 'Anjali Devi' Select * from LR where FamilyTree = 'Amit Kumar' Select Sum(Land) from LR where FamilyTree = Suraj Kumar' Select Sum(Amount) from LR where FamilyTree = 'Arun Kumar' FamilyTree = Self + Descendant

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_2

Step: 3

blur-text-image_3

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

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2010 Barcelona Spain September 2010 Proceedings Part 1 Lnai 6321

Authors: Jose L. Balcazar ,Francesco Bonchi ,Aristides Gionis ,Michele Sebag

2010th Edition

364215879X, 978-3642158797

More Books

Students also viewed these Databases questions

Question

5. How would you describe your typical day at work?

Answered: 1 week ago

Question

7. What qualities do you see as necessary for your line of work?

Answered: 1 week ago