Question: 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

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 Varchar2 15 E Name D_ID Varchar2 3 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 DID Varchar2 3 D Name Varchar2 10 EMP Columns Datatype Size Constraints Primary key Number 3 EID...

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...

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...

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...

Explain why individuals with severe carbon monoxide poisoning are often given transfusions instead of oxygen-rich gas.

The monthly of return on t-bills is 1%. The market went up this month by 1.5%. In addition, AmbChaser,Inc., which has an equity beta of 2, surprisingly just won a lawsuit that awards it $1 million...

Discuss the differences between the FIFO and LIFO methods of costing inventory.

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

What are the implications of rapidly rising health care prices and spending for ( a ) the growth of real-wage rates, ( b ) government budgets, and ( c ) off shoring of U.S. jobs? Explain.

KEY QUESTION What are the twin problems of the health care industry as viewed by society? How are they related?

LAST WORD What groups benefit and what groups lose from the U.S. sugar subsidy program?