Filter out the records unrelated to our database

Assignment Help Database Management System

Reference no: EM13864071

Describe all the tables you have created.

get table_name, status, num_rows, user_stats in user_tables system view

get table_name, constraint_name, constraint_type in user_constraints or user_cons_columns system view. you need to filter out the records unrelated to our database.

get total record numbers from the following tables: movies, distributed_movie_list, movie_rent_list, customers, orders and order_items.

Compare the numbers of row counts with the num_row in user_tables. See whether any inconsistency.

display title, director_name, company names with one query

display title, actor_name with one query

spool the output to a text file (it should be labeled with your name)

Reference no: EM13864071

Questions Cloud

Did the supervisor display qualities of strategic leadership : List at least three examples of dysfunctional leadership that were displayed in the video and explain why they are dysfunctional? Did the supervisor display qualities of strategic leadership? Why or Why not

What would you do on Appointee Dilemma : You are the top civil service official in a large agency. The new administration has just appointed the cabinet secretary and her top political appointees.

Identify lessons the international business manager : Identify lessons the international business manager may learn.

Relationship between member states to the union nations? : Why do the authors of your textbook compare relationship between the AFL-CIO federation to national unions with the relationship between member states to the Union Nations?

Filter out the records unrelated to our database : Describe all the tables - get table_name, status, num_rows, user_stats in user_tables system vie

After reading the old pillars of new retailing : After reading The Old Pillars of New Retailing, discuss how these so called "old pillars" could have helped some of the retailers (such as Circuit City, Blockbuster, Office Depot) who had very challenging times recently.

Write a basic analytical essay on hansel and gretel : Write a basic analytical essay including a main point that is being proven and at least three supporting ideas (i.e. the same essay set up as the Drawbridge Exercise).

What are the tangible and intangible aspects : Describe your product or service offering as it is currently n terms of features and benefits, price and the total cost of ownership as discussed in the week's readings. Is it more product dominant or service dominant. What are the tangible and ..

Provide a detailed analysis of the business model : Provide a detailed analysis of the situation in your business model.

User Account

All Pages