Question: Write an SQL query to create 2 tables DEPT, EMP with the given details DEPT Columns Datatype Size DID Varchar2 3 D Name Varchar2 10

Write an SQL query to create 2 tables DEPT, EMP with the given details DEPT Columns Datatype Size DID Varchar2 3 D Name Varchar2 10 EMP Columns Datatype Size Constraints Primary key Number 3 EID Varchar2 15 E Name Foreign key Varchar 2 3 DID Write an SQL query to create 2 tables DEPT, EMP with the given details DEPT Columns Datatype Size DID Varchar 2 3 D Name Varchar2 10 EMP Columns Constraints Datatype Size Number 3 E_ID Primary key E Name Varchar2 15 DID Varchar23 Foreign key

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Write an SQL query to create 2 tables DEPT, EMP with the given details DEPT Columns Datatype Size D_ID Varchar2 3 D_Name Varchar2 10 EMP Columns Datatype Size Constraints E_ID Number 3 Primary Key...

Write an SQL query to create 2 tables DEPT, EMP with the given details DEPT Columns Datatype Size D_ID Varchar2 3 D_Name Varchar2 10 EMP Columns Datatype Size Constraints E_ID Number 3 Primary key...

Write an SQL query to create 2 tables DEPT, EMP with the given details DEPT Columns Datatype Size D_ID Varchar23 D_Name Varchar2 10 EMP Columns Datatype Size Constraints E_ID Number Primary key...

A project has the following cash inflows OMR 34,000; OMR 39,000; OMR 25,000; and OMR 52,000 for years 1 through 4, respectively. The initial investment is OMR 104,000. 1. What is the Net Present...

Write an SQL query to create 2 tables DEPT, EMP with the given details DEPT Columns Datatype Size Varchar2 3 D_ID D_Name Varchar2 10 EMP Columns Datatype Size Constraints Primary key E_ID Number 3...

Write an SQL query to create 2 tables DEPT, EMP with the given details DEPT Columns Datatype Size D_ID Varchar23 D_Name Varchar2 10 EMP Columns Datatype Size Constraints E_ID Number 3 Primary key E...

con 300 Table : PURCHASE ORDER ORDER_NO AMOUNT ORDER_DATE CUSTOMER_ID SALESMAN_DELIVERY_DATE NAME 1001 05-03-2017 2001 AJI 05-05-2017 1002 200.20 10-07-2017 2002 SHALA 10-10-2017 1003 600 12-06-2017...

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS FOLLOW INSTRUCTIONS: DO NOT SKIP A SINGLE STEP SECTION I: NOTE: Do not specify any constraints with the create statement...

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS Successful people did not attain their success without first overcoming challenges.------- Catherine Pulsifer FOLLOW...

Create one sql script file to complete the following. You cannot run separate SQL statements for the homework. You will also need to place a semicolon after each SQL statement, a requirement for SQL...

For the transmission line shown below, what is the operative head (p/y) at point 3 if the slope of hydraulic grad line is J-h/L=0.008 m/m. 8 - 250 m 100 m L= 1000 m L= 1000 m 50 m 3. L= 1000 m 50 m 4...

The City of Springfield is considering the installation of downtown parking meters. Use the Coase Theorem to discuss the steps that should be taken to make the program a success.

Your firm receives 3 0 cheques from customers on an average day. These cheques, on average, are worth $ 4 5 each, and are processed and clear the bank in 5 days. In addition, your firm mails out 2 0...

The Molson Company had budgeted production for the year as follows: Quarter 1 2 3 4 Production in units 10,100 12,100 18,000 14,100 Three pounds of raw materials are required for each unit produced....

What is meant by a progressive tax? A regressive tax? A proportional tax? Comment on the progressivity or regressivity of each of the following taxes, indicating in each case where you think the tax...

KEY QUESTION What is the incidence of an excise tax when demand is highly inelastic? Elastic? What effect does the elasticity of supply have on the incidence of an excise tax? What is the efficiency...

LAST WORD Explain how a global-positioning antitheft device installed by one car owner can produce a positive spillover to thousands of others in a city.