Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create three separate stored procedures that insert into any table and include the like and join query. In addition, you are requested to show the

Create three separate stored procedures that insert into any table and include the like and join query. In addition, you are requested to show the results of these queries as a screen output
It is not important insert what ever you wish I just need codes and screen shots of results. Values are not important even you can insert donkey for every value
show the result as screen shot
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
4 Authors 6 7 lid 8 1 2 3 4 9 10 11 12 Authors Name Furkan Saglam Salih Kaya Ouzhan Kaya Berke imal Authors bio furkan was born in 1997 he studied bilgi university salih was born in 1996 he studied bilgi university ouzhan was born in 1995 he stuied bilgi university berke was born in 1998 he studied bilgi university 9 - Menino MOONID rechou 1 ay 2ary 34 -- Sess: 90 Member MIT TOGAR Members Member oma mere tema Turma.com Dermall.com Member phone 355455555 51-16567131 515 S1858505 be Author books ciste AU AUTHOR ter |||||||||||||||||| met Advents. And M 19 IWW 13 14 1 15 ld 16 17 18 Library_books library book condition To be received after 10 days To be received after 8 days To be received after 3 days To be received after 9 days Library Book isbn ISBN 478569712354 ISBN 457896312547 ISBN 321478985314 ISBN 547896547423 2 3 4 20 4 5 Authors 1 6 7 id 8 9 10 11 12 2 3 Authors Name Furkan Saglam Salih Kaya Ouzhan Kaya Berke imal Authors bio furkan was bom in 1997 he studied bilgi university salih was born in 1996 he studied bilgi university oguzhan was born in 1995 he stuied bilgi university berke was born in 1998 he studied bilgi university 4 6. Library database authors author_books Id VARCHAR(36) isbn VARCHAR(36) name VARCHAR(60) +---- title VARCHAR(200) bio VARCHAR(1000) author_id VARCHAR(36) genre VARCHAR(36) 1-H description VARCHAR(1000) library books date_published DATE id VARCHAR(36) > - isbn VARCHAR(36) condition VARCHAR(36) members id VARCHAR(36) name VARCHAR(100) email VARCHAR(100) phone_number VARCHAR(36) HI- member_books member_id VARCHAR(36) book_id VARCHAR(36) date_checked_out DATE

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

Oracle RMAN For Absolute Beginners

Authors: Darl Kuhn

1st Edition

1484207637, 9781484207635

More Books