Question
7 For every database, list tables without IDX 8 For every database, list tables with PK but without FK 9 For every database/schema, list tables
7 For every database, list tables without IDX
8 For every database, list tables with PK but without FK
9 For every database/schema, list tables with IDX, index name (constraint name), fields used in IDX
10 For every database/schema, list tables with CC
11 For every database/schema, list tables with PGM
12 For every database/schema, list all views (View name, View description)
13 For every database/schema, list all table with audit table
14 For every database/schema, list schema, users, role, Dept
15 For every database/schema, list schema equipped with triggers to manage change in users
16 For every database/schema, list schema, dept, role, tables
17 For every database/schema, list schemas equipped with triggers to manage change in dept/tables
18 redo use case 1 thru 17 by distributed datbase setup This usecase is 17 distributed queries
Step 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