Computer Science
Create table Department as per following Table Instance Chart.
| Column Name | DeptID | DeptName |
|---|---|---|
| Key Type | Primary | |
| Nulls/Unique | NOT NULL | |
| Datatype | NUMBER | VARCHAR |
| Length | 2 | 20 |
DDL & DML
3 Likes
Answer
CREATE TABLE Department (
DeptID NUMBER(2) PRIMARY KEY,
DeptName VARCHAR(20) NOT NULL
);
Answered By
1 Like
Related Questions
Insert few records with relevant information, in the table.
Drop the column CustomerIncomeGroup from table Customer.
Create table Employee as per following Table Instance Chart.
Column Name EmpID EmpName EmpAddress EmpPhone EmpSal DeptID Key Type Primary Foreign Nulls/Unique NOT NULL Fk Table Department Fk Column Dept_ID Datatype NUMBER VARCHAR VARCHAR VARCHAR NUMBER VARCHAR Length 6 20 30 10 9, 2 2 View structures of all tables created by you.