Question: EMP Columns Datatype Size Constraints E_ID Number 3 Primary key E_Name Varchar2 15 D_ID Varchar2 3 Foreign key Salary Number 8,2 a. Write a SQL

EMP Columns Datatype Size Constraints E_ID Number 3 Primary key E_Name

EMP Columns Datatype Size Constraints E_ID Number 3 Primary key E_Name Varchar2 15 D_ID Varchar2 3 Foreign key Salary Number 8,2 a. Write a SQL query to add constraint CHECK to check Salary > 0 with a suitable constraint name (1.5 Marks) Write an SQL query to remove the table from the database. (1Mark)

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!

EMP Columns Datatype Size Constraints E_ID Number 3 Primary Key E_Name Varchar2 15 D_ID Varchar23 Foreign key Salary Number 8,2 a. Write a SQL query to add constraint CHECK to check Salary > 0 with a...

EMP Columns Datatype Size Constraints E_ID Number 3 Primary Key E_Name Varchar2 15 D_ID Varchar2 3 Foreign key Salary Number 8,2 a. Write a SQL query to add constraint CHECK to check Salary > 0 with...

q EMP Columns Datatype Size Constraints E_ID Number 3 Primary key E_Name Varchar2 15 D_ID Varchar2 3 Foreign key Salary Number 8,2 a. Write a SQL query to add constraint UNIQUE to the column Salary...

EMP Columns Datatype Size Constraints E_ID Number 3 Primary key E Name Varchar2 15 D_ID Varchar2 3 Foreign key Salary Number 8,2 name a Write a SQL query to add constraint UNIQUE to the column Salary...

EMP Columns Datatype Size Constraints Primary key E_ID Number 3 E_Name Varchar2 15 D_ID Varchar2 3 Foreign key Salary Number 8,2 a. Write a SQL query to add constraint CHECK to check Salary> 0 with a...

EMP Columns Constraints Datatype Size Number 3 E_ID Primary key E_Name Varchar2 15 D_ID Varchar23 Foreign key Salary Number 8,2 a. Write a SQL query to add constraint UNIQUE to the column Salary with...

Table Structure: flight COLUMN NAME DATA TYPE SIZE Constraint Fid Number 3 Primary key Fname Varchar 2 10 Splace Varchar 2 8 Dplace Varchar 2 8 Tdate date Seats Number 3 Note: Fid is Fight ID, Fname...

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

Sketch the transfer and drain characteristics of an n-channel depletion-type MOSFET with IDSS = 12 mA and VP = -8 V for a range of VGS = - VP to VGS = 1 V.

Repeat the previous problem, but close the positions on September 20. Use the spreadsheet to find the profits for the possible stock prices on September 20. Generate a graph and use it to identify...

Marcie works for an educational technology firm that recently launched its employee stock option plan ( ESOP ) . Marcie allocated all her investments in the ESOP. Good Financial Decision? Yes No

up to 2020 (Ratio analysis over time) The following information comes from the accounting records of Hercep Ltd. for the first three years of its existence: 2018 2019 2020 Statement of Financial...

=+dimensions, including recommendations on how HR should deal with it.

=+5 What are sustainable HR practices and how do they affect employees?

=+ Are some standards more important than others? If so, which ones?