Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE SOLVE IT CORRECTLY WITH OUTPUT SCREENSHOT OTHERWISE WILL DOWNVOTE OR IF YOU SOLVE PROPERYL WILL UPVOTE ALSO PLEASE PROVIDE A DETAILED ANSWER FAST WITH

PLEASE SOLVE IT CORRECTLY WITH OUTPUT SCREENSHOT OTHERWISE WILL DOWNVOTE OR IF YOU SOLVE PROPERYL WILL UPVOTE ALSO

PLEASE PROVIDE A DETAILED ANSWER FAST WITH OUTPUT SCREEN OTHERWISE WILL DOWNVOTE OR IF YOU SOLVE PROPERLY WILL UPVOTE ALSO

PLEASE SOLVE FAST FAST AND CORRECTLY

image text in transcribedimage text in transcribed

I HAVE UPLOADED IMAGE TWICE THIS IS THE SAME QUESTION BECAUSE BELOW PART WAS MISSING IN IMAGE THATSWHY

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

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

Students also viewed these Databases questions