Answered step by step
Verified Expert Solution
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
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 + DescendantStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started