Question: COMPLETE THE FOLLOWING EXPERIMENT USING SQL PLUS Consider the database for an organization. Write the queries for the following (i) Create the database (ii) Select

COMPLETE THE FOLLOWING EXPERIMENT USING SQL PLUS

Consider the database for an organization. Write the queries for the following

(i) Create the database

(ii) Select the current database

(iii)Create the following tables.

a. employee (emp_no,emp_name,DOB, address, doj, mobile_no, dept_no, salary).

b. department (dept_no, dept_name, location).

(iv) Include necessary constraints.

(v) List all the tables in the current database

(vi) Display the structure of the employee table

(vii) Add a new column Designation to the employee table

(viii) Drop the column location from Dept table

(ix) Drop the tables

(x) Delete the database

Step by Step Solution

★★★★★

3.46 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Solutions i Create the database eno SMALLINT ename VARCHAR20 NOT NULL WITH DEFAULT age INTEGER1 job SMALLINT salary FLOAT4 dept SMALLINT WITH JOURNALI... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (2 attachments)

6360a6730792c_234619.pdf

180 KBs PDF File

6360a6730792c_234619.docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Consider the database for an organization. Write the queries for the following 1. Create the database 2. Select the current database 3. Create the following tables. a. employee (emp_no,emp_name,DOB,...

Write SQL queries to answer the following questions: a. List the numbers of all sections of course ISM 3113 that are offered during the semester "1-2015." b. List the course IDs and names of all...

Create additional select queries for Coast Jewelers using statistics a. Create and print a select query for Coast Jewelers that calculates the total sales value of all rings in inventory. Save this...

An analysis of the Barty Battles businesss Cash account for October shows these entries: i Beginning cash balance: $1600 ii Collections from customers: $43 000 iii Payment for purchase of storage...

Required: (a) Prepare the memo to the partner. (b) Briefly discuss how the following three investor groups would classify and account for their investment: (i) Investor in Limited Partnership units...

Using both three and one-letter codes for amino acids, write the structures of all possible peptides containing the following amino acids: (a) Vat, Ser, Leu (b) Ser, Leu2, Pro

Threads Limited manufactures nuts and bolts, which are sold to industrial users. The abbreviated financial statements for 2010 and 2009 are as follows. Required: (a) Assuming that all sales and...

1. CPA QUESTION: Which of the following requirements must be met to create a bailment? I. Delivery of personal property to the intended bailee II. Possession by the intended bailee III. An absolute...

(a) When the ac generator in FIGURE 24-35 operates at high frequency, is the rms current in the circuit greater than, less than, or the same as when the generator operates at low frequency? In figure...

(Accounting Organizations and Documents Issued) Presented below are a number of accounting organizations and types of documents they have issued. Match the appropriate document to the organization...

jerry owns a small convenience store.On 1 October 2016, Jerry is looking after his 10-year-old niece, Sarah, while her parents are out of town. Jerry takes Sarah shopping at the local mall and he...

You are the CEO of Apple, whose iPhones are all assembled in China. President Trump publicly and privately asked you to move some of the production back to the United States. President Biden pushed...

Does the Tucson data-mining project inappropriately violate users' privacy, or is it an acceptable tradeoff to more intelligently combat terrorism? Explain your answer. 2.Were the local police...

The following Trial Balance was taken from the books of Tom Toy at 31 December 2012. Purchases/Sales Inventory 1.1.2012 Wages Loan - R Driscoll Cash Premises ms Dr Cr $ 57,341 80,340 4,173 10,650 242...

(11) The CPF Payable account has an opening balance of $5,600, and the amount due to the CPF Board is being paid on the last day of the month.

Tom learned to ask questions in math class, but he never learned to ask questions in English or history class. The problem is that "asking questions" did not demonstrate A Generality B Technology C...

Calculate the contribution to total performance from currency, country, and stock selection for the manager in the example below. All exchange rates are expressed as units of foreign currency that...

Consider the discrete group G of order 8 that has the following Cayley diagram e If we have the sequence of operations: fcagec, which of the options represents the reduction of the sequence to a...

What and where is the Quick Access Toolbar?

Create a new Coast Jewelers' Cost Analysis a. Using the ch7-02 file to start your work, create a worksheet to do the following: i. Calculate the Hi-Lo Method variable cost/hour open and fixed cost....

How is grouping used with the cash budget?

Consider the following computer results, which describe regression analyses involving two independent variables X1 and X2 and a dependent variable Y. Assume that your goal is to assess the...

Use the correlation matrix from Problem 1 to answer the following questions. a. Compute the semipartial rSBP(SMK|AGE). b. Compute the semipartial rSMK(SBP|AGE). c. Compare these correlations to the...

Use the output from Problem 11 in Chapter 8 and the output given here to answer the following questions. (Assume that no interaction occurs between TV advertising expenditure [X1] and print...