TABLE CREATION

Create table as per below data & briefly discuss the why you use these the script for creating of table . only one attribute will be primary key.

The other two attributes will Restrict the duplication and must store data values.

Table name: DEPARTMENT

DPT_CODE DPT_NAME    DPT_ALLOTMENT

-------- --------------- -------------

   57 IT            65000

   63 Finance    15000

   47 HR            240000

   27 RD            55000

   89 QC            75000