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
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
Get step-by-step solutions from verified subject matter experts
