Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create the below Queries: table [ [ Query # , Query Name,Query Fields,Table ( s ) , Other ] , [ Query 1 ,

Create the below Queries:
\table[[Query #,Query Name,Query Fields,Table(s),Other],[Query 1,All Users,All fields,Users,n/a],[Query 2,All Chats,All fields,Chats,n/a],[\table[[Queries 3-],[8]],\table[[Query Names:],[Session 0],[Session 1],[etc]],\table[[ChatId],[Session],[fromUser],[toUser],[message]],Chats,\table[[List in sequence by ChatId.],[Enter criteria for Session],[field for each session],[number in queries.]]],[Query 9,Donna,\table[[ChatId],[Session],[fromUser],[toUser]],Chats,\table[[List in alpha order by the],[toUser and then by ChatId]]],[Query 10,Peter,\table[[fromUser],[toUser],[messageTime],[message]],Chats,\table[[Include only messages],[from Donna1 and John1.],[Sort by message time from],[longest to shortest. Do not],[display the message time.]]],[Query 11,John,\table[[username],[messages],[toUser]],\table[[Users],[Chats]],\table[[List all messages sent by John],[Smith and sequenced by],[toUser. Should have 1 join.]]]]
image text in transcribed

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

Transactions On Large Scale Data And Knowledge Centered Systems Xxviii Special Issue On Database And Expert Systems Applications Lncs 9940

Authors: Abdelkader Hameurlain ,Josef Kung ,Roland Wagner ,Qimin Chen

1st Edition

3662534541, 978-3662534540

More Books

Students also viewed these Databases questions