Develop basic tools to expedite use of oracles dictionary

Assignment Help Database Management System
Reference no: EM13186658

Develop basic tools to expedite use of Oracle's data dictionary

Goals:

Develop and demonstrate SQL skills

Develop your facility with a data dictionary

Tasks:

1) Write a script that provides all of the information in, and duplicates the formatting of, Oracle's SQL*Plus describe command. Additionally, the output should add the comments on the rows. Input: owner and table name. Output: columns for Name, Null?, Type, Comments.

Format:Submit the code to query the data dictionary. You must submit the code as scripts that the instructor can run from an SQL prompt on an Oracle DBMS. Your submission must include a description of the scripts, their actions, and the order in which they should be run. Your code must not have any "side effects" (that is, it must not do anything not listed in the assignment description, and all of its actions must be described in the program header).
Criteria:

1) Well-written code

2) Code meets requirements

Instructions: Enter or paste your written work and/or click "Attachments" to upload your files.

Reference no: EM13186658

Previous Q& A

  What type of sampling technique is being used

A marketing expert for MTV is planning a survey in which 500 people will be randomly selected from each age group of 10-19, 20-29, and so on. What type of sampling technique is being used?

  Count rumford observed that using cannon-boring machinery

Count Rumford observed that using cannon-boring machinery, a single horse could heat 11.6 kg of water (T = 273 K) to T = 355 K in 2.5 hours

  Find the amount of work in joules required to empty

Find the amount of work in joules required to empty the trough by pumping the water over the top. (Note: Use as the acceleration due to gravity.)

  Compute the height if the temperature of the waterfall

Suppose Joule encountered the waterfall at Niagara Falls. Calculate the height if the temperature difference between the top and bottom of the waterfall is 0.20° F.

  What is the cost of renting the 100th tux

The cost of renting tuxes for the Choral Society's formal is $20 down, plus $88 per tux.

  Design the layout of users

The topology diagram for the different servers and locations and trust domains. For example, where is the firewalls, and where are the users located in the topology.

  Calculate rubbles incremental cost per unit

Flintstones, Inc., markets a small solid cylinder of a spark-producing alloy used to ignite the fuel in residential furnaces. Currently, the company's products are sold to other manufacturers who then incorporate it in their merchandise. The yearl..

  Compute the median, mean and mode for these payments

a sample of single persons receiving social security payments revealed these monthly benefits: $926, $799, $1187, $1088, $1065, $980, $939, and $1065. Compute the median, mean and mode for these payments.

  What is the condition number for d as a function of v

What is the condition number for d as a function of v?

  Depict all resonance structures for anisole

Draw all resonance structures for anisole to show why the methoxy group directs incoming electrophiles

Reviews

Write a Review

 

Similar Q& A

  Calculate canonical cover for set of functional dependencies

Calculate a canonical cover for above set of functional dependencies (show each step of your derivation with an explanation).

  Perform large number of client-server requests into database

A small business with 100 computer workstations is installing a new local area network. All of the users perform the usual operations of e-mail. State your reasoning. Draw a floor plan for each If possible, show both floor plans on one page.

  Explain efficient algorithm for edge-labeled graph

Explain efficient algorithm that, provided edge-labeled graph G with distinguished vertex v0 and sequence s = σ1, σ2, ..., σk of characters from Σ, returns path in G which begins at v0.

  Write an sql query

Write an SQL query to get the author of the book "The Alchemist"

  Database planner should spend a considerable amount of time

Provide what reports may be produced as a result of your database design.Based on the information you have researched, create a 2-3 page design document that includes a description of the database you would like to create as well as sample tables ..

  Write names-e-mail addresses for customers by foreign key

Illustrate all data in each of the four tables. Don't show foreign key columns. Write down the names and e-mail addresses for all customers who have had stove repair which cost more than $50.

  Create a database design - relational data model

Create a database design specification Enhanced Entity Relationship Diagram (EERD) and Relational Data Model from the given business description - Database Management System

  Create a table for patients with information

Create a table (by your own imagination) which comprises the least 25 patients with next information (columns): Calculate average of Value1 for each Gender.

  Advantages of database approach over file-system approach

How and why did database management systems become the organizational data management standard? Describe some advantages of database approach over file-system approach.

  Creating erd containing order and customer entity

Create ERD containing Order and Customer entity types connected by 1-M relationship from Customer to Order. Select suiatble relationship name using your common knowledge of intersection.

  Explain why data flow diagrams are developed in a hierarchy

Explain why data flow diagrams are developed in a hierarchy? What are the names of some levels in the hierarchy?

  Design a set of 3nf tables for database scenario

Draw an ER diagram for your database scenario. Design a set of 3NF tables for your database scenario.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd