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

Questions Cloud

What is the machine precision eps : Determine (exactly!) the relative error E of x* as an approximation to x? and calculate the ratio l~l/eps.
Depict a formula for the lowest molecular weight compound : Draw a formula for the lowest molecular weight compound that contains C, H, and possibly O, N or S, is a chiral compound, contains ONLY one functional group, and is a sulfide.
Build your own maze : Build your own maze and make it so easy so i can understand it. try to use for while statement. it is an easy task so please do not make it complicated and follow the instructions that im going to post. another thing do not use the maze that in th..
Compute p and v and t for initial and final states : Calculate P,V and T for initial and final states of each process and produce a plot of the two processes on a P,V diagram. Without resorting to equations, explain why the result for part (b) is greater than or less than the result for part (a).
Develop basic tools to expedite use of oracles dictionary : 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..
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.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Implement a database based on the provided er diagram

Analyse and comprehend a provided ER diagram and Database Schema and implement a database based on the provided ER diagram and Database Schema

  Show the rea diagram using microsoft word

Show the REA diagram using Microsoft Word

  Create microsoft access database

Create a Microsoft Access database. Create the tables, fi elds, data types, and primary key(s) for the database. Create the relationship(s) needed between the tables.

  Data entities of this enterprise

Consider a student club or organization in which you are a member. What are the data entities of this enterprise? List and define each entity.

  Prepare a report related to business communications

Prepare a report - The report should be related to Business communications.

  Craete the database to be fault tolerant

Explain the thought process of DBA as they craete the database to be fault tolerant. What policies would you suggest to get this goal?

  Describe the content, purpose, user access methods

describe the content, purpose, user access methods, and sources of data

  Design work breakdown structure for designing database

Design a work breakdown structure for the task below: Designing the database, Working on the website content

  Sketch hash table to result from using hash function

Sketch hash table of length 11 which results from using hash function h(i) = (2i + 5) mod 11, to hash the keys 12, 44, 13, 88, 23, 94, 11, and 39,

  Transform the tables into one or more tables in bcnf

Transform the tables into one or more tables in BCNF. State the primary keys, candidate keys, and referential integrity constraints.

  Explain the concept of physical data independence

Explain the concept of physical data independence and its importance in database systems,  List four significant differences between a file-processing system and a DBMS.

  Write names and e-mail addresses from database

Suppose a database has tables given below. Write the names and e-mail addresses for all customers who have had stove repair which cost more than $50.

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