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

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 Name Varchar2 15 DID 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 Varchar23 D_Name Varchar2 10 EMP Columns Datatype Size Constraints E_ID Number 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 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...

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

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

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

Figure P35.45 shows a desk ornament globe containing a photograph. The flat photograph is in air, inside a vertical slot located behind a water-filled compartment having the shape of one half of a...

Lubbly Fashh Sdn Bhd manufacture and sells three designs of blouse. The management accountant has forecasted the following production and sales data for the month of May 2020. Design Demand (units)...

Which of the following parity conditions is ( are ) correct? The interest - rate parity theory states that the forward premium / discount should be equal and opposite in size to the rational interest...

1. Jeffreys Company reports depreciation expense of $41,000 for Year 2. Also, equipment costing $143,000 was sold for a $10,100 loss in Year 2. The following selected information is available for...

Knowledge of process documentation (process flow charting)

3. What management, organization, and technology issues did Arup have to address when selecting Project Online as its global project portfolio management tool?

Bachelors degree in Computer Science, Computer Engineering, Management Information Systems, Project Management, or a related field