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 1. Mr. Arun Kumar S/o Mr. Suraj

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

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

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

Database Systems For Advanced Applications 15th International Conference Dasfaa 2010 Tsukuba Japan April 2010 Proceedings Part 1 Lncs 5981

Authors: Hiroyuki Kitagawa ,Yoshiharu Ishikawa ,Wenjie Li ,Chiemi Watanabe

2010th Edition

3642120253, 978-3642120251

More Books

Students also viewed these Databases questions

Question

What does the start( ) method defined by Thread do?

Answered: 1 week ago

Question

What is the preferred personality?

Answered: 1 week ago

Question

What is the relationship between humans?

Answered: 1 week ago