Question: SQL Q: Login to SQL and write SQL queries to do the following: 1. Create Employee and Department tables based on the following table specification

SQL SQL Q: Login to SQL and write SQL queries to do the

Q: Login to SQL and write SQL queries to do the following: 1. Create Employee and Department tables based on the following table specification and add all Constraints: Employee Department Size Column name Data Type Size 5 Varchar2 2 *DNO DName 15 Varchar2 15 2 Column name Data Type *SSN Varchar2 Name Varchar2 **Dept_num Varchar2 Age number * Primary Key, **Foregone Key lage>18 Name not null DName unique 2

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!